Etl Developer

Role & responsibilities

Position Details

Role: ETL / Informatica IDMC Developer

• Experience: 5+ years
• Work Mode: Remote
• UAN: Mandatory

Job Description

Role Overview

We are looking for an experienced ETL / Informatica IDMC Developer with strong hands-on expertise in Informatica PowerCenter and Informatica IDMC/IICS. The candidate should have experience in ETL development, REST API integrations, SQL optimization, and cloud data integration.

Key Responsibilities

• Develop, enhance, and maintain ETL/ELT workflows using Informatica PowerCenter and IDMC Cloud Data Integration (CDI).
• Contribute to end-to-end migration projects from PowerCenter to IDMC.
• Integrate data across Oracle, SQL Server, Snowflake, and other database platforms.
• Implement REST API integrations using Informatica IDMC/IICS REST V2 or Web Services connectors.
• Handle JSON/XML payloads, API authentication, pagination, and data loading.
• Develop and optimize complex SQL queries and troubleshoot performance issues.
• Create and maintain UNIX/Linux shell scripts for automation and orchestration.
• Analyze source-to-target mappings and resolve data integration challenges.
• Collaborate with business and technical teams and maintain technical documentation.

Mandatory Skills & Qualifications

• 5+ years of hands-on experience with Informatica PowerCenter.
• 3+ years of experience with Informatica IDMC/IICS (CDI).
• Strong SQL skills, including query optimization and performance tuning.
• Experience with Oracle and Snowflake.
• Hands-on experience with REST API integrations, JSON/XML, authentication, and pagination.
• Strong UNIX/Linux shell scripting skills.
• Good understanding of ETL architecture, data modeling, and data warehousing concepts.

Preferred Skills

• Experience in at least one end-to-end PowerCenter-to-IDMC migration project.
• Exposure to Mass Ingestion, Cloud Application Integration (CAI), and Data Quality (DQ).
• Knowledge of AWS, Azure, or GCP.
• Familiarity with Control-M, AutoSys, or similar scheduling tools.

Mandatory Onboarding Conditions

• UAN is mandatory for all candidates.
• PF deductions will be processed