ETL Developer

About the Job:
We have an immediate job opportunity for the position of ETL Developer. The ideal candidate will be responsible for designing and building Informatica PowerCenter ingestion pipelines for all identified source tables to the Azure Data Lake Bronze zone, supporting both full initial loads and incremental CDC/batch loads. The role also includes implementing schema drift detection, metadata capture, and developing data quality checks at ingress.

Key responsibilities include:

• Building transformation logic on Cloudera CDP using Spark and developing unit tests for those transformations.
• Designing target RDBMS schema and producing DDL scripts with deployment guides.
• Integrating ETL pipelines into CI/CD processes while supporting CAB approval for production deployments.

Work Conditions: On-site, Contract
Experience Required: 6 to 14 Years
Notice Period: Immediate

Required Skills:

• 3+ years of hands-on experience with Informatica PowerCenter and familiarity with Informatica Cloud (IICS) is a plus.
• Solid experience in Azure data lakes, including ADLS Gen2 zone design and Azure Purview.
• Proven experience with Cloudera CDP, Apache Spark (PySpark or Scala), and Hive for large-scale data transformation.
• Strong SQL proficiency and experience with data modeling are a must.
• Experience within financial services data and knowledge of CI/CD pipelines are preferred.

Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.

Soft Skills:

• Excellent communication and leadership skills.
• Strong interpersonal abilities and collaboration skills.
• Capacity to work under pressure and meet tight deadlines.
• Positive attitude and strong work ethic.

Language Requirements:
Not specified.