Senior Informatica IICS / IDMC Developer

Tata Consultancy Services Limited; Hyderabad, Chennai, Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Tata Consultancy Services Limited is seeking a senior ETL specialist with 7+ years of experience to develop and optimize data integration solutions using Informatica IICS/IDMC CDI. You will design mappings, tasks, and configurations, and migrate PowerCenter artifacts with validation to modern cloud data integration platforms.

Candidate should excel in SQL, data modeling, performance tuning, and CI/CD driven delivery, while contributing to governance, testing, and production support.

Qualifications

• 7+ years of ETL/data-integration experience with hands-on development in Informatica IICS/IDMC CDI.
• Strong experience in mappings, tasks, and runtime configurations.
• Experience migrating PowerCenter workflows to IICS/IDMC with validation.

Responsibilities

• Design, develop and optimize ETL/ELT mappings and workflows.
• Implement incremental loads, CDC, and SCD with robust error handling.
• Collaborate on performance tuning, pushdown optimization and query tuning.
• Ensure deployment, monitoring, and incident resolution within CI/CD pipelines.

Skills

ETL development

Informatica IICS

IDMC Cloud Data Integration

Data integration

SQL proficiency

Tools

Informatica PowerCenter

Git

Job description

Role & responsibilities

• 7+ years of ETL/data-integration experience with strong hands-on development in Informatica IICS/IDMC Cloud Data Integration (CDI).
• Proven experience developing mappings, mapping tasks, reusable transformations, parameters, parameter files and runtime configurations.
• Hands-on experience assessing and migrating Informatica PowerCenter workflows, mappings and sessions to IICS/IDMC, including conversion remediation and validation.
• Strong ETL/ELT design expertise covering incremental loads, change data capture (CDC), slowly changing dimensions (SCD), complex transformations, restartability and idempotency.
• Experience designing taskflows with dependencies, scheduling, parameterization, exception handling and recovery, plus Secure Agent installation, configuration and troubleshooting.
• Advanced SQL proficiency including complex joins, analytical functions, stored procedures, data reconciliation and query tuning.
• Experience integrating relational databases, flat files, cloud data warehouses, REST APIs, JSON and XML sources and targets.
• Strong knowledge of performance optimization using pushdown optimization, partitioning, session and mapping logs, bottleneck analysis and root-cause analysis.
• Practical experience in testing, deployment, production monitoring, reruns, incident resolution, Git-based version control and CI/CD-driven asset promotion.
• Knowledge of access control, secrets handling, governance and audit requirements, with strong review, mentoring, communication and documentation skills.