Senior Developer
First seen by Alion on Sep 5, 2026.
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.
Skills
IICS, Informatica IDMC, Power Center, ETL, Data Integration, SQL, Teradata