onsite
Senior Oracle PL/SQL Technical Specialist - HCLTech
Software Engineer
Lead the design, development, and optimization of Oracle PL/SQL and Talend ETL solutions, integrating data across Oracle, Snowflake, and other sources to deliver high‑performance data pipelines and analytics.
About the role
Key Responsibilities
- Architect and develop robust Oracle PL/SQL code for database performance and data integrity.
- Design, build, and maintain Talend ETL/ELT jobs that ingest, transform, and load data from Oracle, Snowflake, and other sources.
- Implement complex data pipelines using Java and Python within Talend to automate transformations and enhance scalability.
- Optimize SQL queries and ETL workflows for maximum throughput and minimal latency.
- Collaborate with data architects and business stakeholders to translate requirements into technical solutions.
- Monitor, troubleshoot, and tune production data pipelines to ensure reliability and compliance.
Requirements
- 5+ years of experience in Oracle PL/SQL development and database administration.
- Proven expertise in Talend, Snowflake, and large‑scale ETL/ELT design.
- Strong programming skills in Java and Python for custom job development.
- Deep knowledge of SQL performance tuning and data modeling.
- Excellent problem‑solving skills and a collaborative mindset.
Skills
snowflakejavapythonsql