Role & responsibilities

- 7+ years of ETL/data-integration experience with solid 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.

📌 Senior Informatica IICS / IDMC Developer (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru