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.
Skills: powercenter,iics,idmc,ipu optimization
