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.
Robust 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.
Robust 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