ETL Developer - ETL Informatica IDMC

CIEL HR; Mumbai; On-site; INR 1,400,000 - 2,200,000; Part time

Job summary

CIEL HR is seeking an ETL Developer in Mumbai to design and implement robust data pipelines using Informatica Cloud IDMC and Alteryx, with hybrid work arrangement.

Expect 6+ years of hands-on experience in ETL, SQL, data warehousing, and AWS Redshift, along with strong collaboration with business and IT stakeholders.

The role involves optimizing performance, error handling, and supporting SIT/UAT and production deployments in a dynamic environment.

Qualifications

• 6+ years of experience in ETL development.
• Experience with Informatica IDMC and AWS Redshift.
• Strong SQL and data warehousing knowledge.
• Experience with AWS services (S3, Redshift).
• Excellent communication with Business and IT stakeholders.

Responsibilities

• Develop and implement ETL/ELT pipelines in Informatica Cloud Data Integration CDIIICS.
• Build complex Alteryx workflows into scalable Informatica cloud mappings tasks and workflows.
• Optimize ETL jobs for performance, maintainability and reliability.
• Implement error handling, logging, scheduling and monitoring for Informatica pipelines.
• Support SIT, UAT and production deployment activities.
• Troubleshoot migration issues, resolve defects and ensure smooth cutovers to target platform.

Skills

ETL Informatica IDMC

AWS Redshift

SQL

Data Warehousing

Relational DBs

AWS S3

Alteryx

Communication

Tools

Informatica Cloud

Alteryx

Informatica IDMC

Job description

Job Title: ETL Developer

Experience: 6 + Years

Location: Mumbai

Work Mode: Hybrid

Duration: 6 Months

Job Description:

Role ETL Developer

Key Responsibilities

• Develop and implement ETL/ELT pipelines in Informatica Cloud Data Integration CDIIICS
• Building complex Alteryx workflows into scalable and reusable Informatica cloud mappings tasks and workflows
• Optimize ETL jobs for performance maintainability and reliability
• Implement error handling logging scheduling and monitoring mechanisms for Informatica pipelines
• Support SIT UAT and production deployment activities
• Troubleshoot migration issues resolve defects and ensure smooth cutovers to the target platform

Required Skills Experience

• ETL Informatica IDMC
• AWS Redshift DB
• Data Warehousing SQL Data Engineering
• Strong knowledge of SQL and relational database concepts
• Familiarity with AWS cloud services like S3 Redshift etc
• Good understanding of filebased and databasebased integrations
• Strong communication skills to work closely with Business and IT stakeholders