Description

You will develop and manage data pipelines using Informatica technologies.

Responsibilities

• Develop and maintain ETL workflows using Informatica PowerCenter and IDMC.
• Design and execute test cases covering data validation, performance testing, and error handling for ETL processes.
• Support large-scale data pipelines and Data Warehouse environments.
• Participate in Agile ceremonies, including sprint planning and daily stand-ups.
• Perform production support, including participation in an on-call rotation.

Required Skills

• 7+ years of experience in data engineering or ETL development.
• Deep expertise in Informatica PowerCenter and Informatica IDMC.
• Proven experience with AWS services: EMR, ECS, Glue, Redshift, S3, SNS, SQS, Lambda, CloudWatch.
• Strong proficiency in Python for data processing and automation.
• Experience supporting Data Warehouse environments and large-scale data pipelines.
• Hands-on experience with Docker for containerized development and deployment.
• Experience testing ETL workflows (unit, integration, regression, data reconciliation).
• Proficiency in SQL across Redshift, Postgres, and Oracle databases.
• Experience working in Agile development environments.

Preferred Skills

• Experience with PowerCenter to IDMC migration.
• Exposure to CI/CD tools like Jenkins or GitLab.

Key Skills

Education

Bachelor's degree