Job Description :

We are looking for an IICS/IDMC Senior Developer with strong hands-on experience in Informatica PowerCenter, IICS/IDMC, and IPU Optimization.

The role involves analyzing existing PowerCenter ETL workflows and executing end-to-end migration to IICS/IDMC, including redesign, optimization, testing, reconciliation, and production validation.

Mandatory Skills :

- Informatica PowerCenter

- IICS / IDMC

- IPU Optimization

- Strong ETL/data integration experience

- SQL and Unix Shell Scripting

- Experience with any enterprise scheduling tool

Good to Have :

- IICS capabilities such as CDI, Mass Ingestion, and Database Ingestion

- Informatica PowerExchange

- Experience with Oracle Exadata, Teradata, DB2, MySQL

- Mainframe file processing

- Data cleansing, validation, mapping, and reconciliation

Key Responsibilities :

- Analyze existing PowerCenter mappings, workflows, sessions, and dependencies.

- Assess migration feasibility and identify equivalent IICS/IDMC components.

- Perform end-to-end PowerCenter-to-IICS migration using Informatica migration utilities and manual conversion where required.

- Redesign and optimize ETL logic according to cloud best practices.

- Migrate and validate mappings, workflows, parameter files, variables, schedules, dependencies, error handling, and logging.

- Perform unit testing, system testing, data validation, and reconciliation.

- Troubleshoot performance issues and optimize ETL workflows.

- Ensure data accuracy and completeness after migration.

- Work with stakeholders to resolve migration-related technical issues.

Ideal Candidate :

A senior Informatica professional with 6+ years of experience, strong PowerCenter fundamentals, proven IICS/IDMC migration experience, and hands-on expertise in IPU optimization.

Candidates who have independently handled PowerCenter-to-IICS migrations end-to-end would be preferred.