Data Integration Consultant - Informatica IDMC
First seen by Alion on Sep 11, 2026.
Role : Informatica IDMC / IICS Data Integration Consultant
Experience : 8+ Years overall | 46+ Years hands-on IDMC experience.
Work Mode : Hybrid.
Notice Period : Immediate Joiners to 30 Days preferred.
About the Role :
We are looking for experienced Informatica IDMC / IICS professionals with strong expertise in enterprise data integration, ETL/ELT, cloud data integration and MDM. The ideal candidate will work on large-scale data integration and cloud transformation initiatives and collaborate with architects, business stakeholders and technical teams.
Key Responsibilities :
- Design and implement end-to-end data integration solutions using Informatica IDMC / IICS.
- Work with Cloud Data Integration (CDI), Cloud Application Integration (CAI) and Cloud Data Quality (CDQ).
- Develop scalable ETL/ELT pipelines across cloud and on-premise environments.
- Develop mappings, workflows, task flows and transformations.
- Build batch, real-time and API-based integrations using REST/SOAP.
- Design data integration architecture and data models.
- Work on MDM solutions including Customer 360, Business 360 and Reference 360.
- Support cloud migration and modernization initiatives.
- Implement data governance, data quality and validation frameworks.
- Monitor data lineage, metadata and data accuracy.
- Troubleshoot complex integration issues and production failures.
- Manage Secure Agents, runtime environments and connectivity.
- Integrate IDMC with enterprise systems such as SAP, Oracle, Salesforce, Snowflake and data lakes.
- Develop API integrations and data ingestion solutions.
- Provide technical guidance, mentoring and code reviews.
- Collaborate with business stakeholders and architects to translate requirements into technical solutions.
Must-Have Skills :
- 8+ years of experience in Data Engineering / Data Integration / MDM.
- 46+ years of hands-on experience with Informatica IDMC / IICS.
- Strong experience with CDI, CAI and CDQ.
- Experience with ETL/ELT, data pipelines and data modeling.
- Strong SQL skills.
- Knowledge of APIs and scripting using Python/Shell.
- Exposure to AWS, Azure or GCP.
- Understanding of data governance, metadata and data lineage.
- Experience with Git, CI/CD and DevOps practices.
- Strong stakeholder management and communication skills.
Good to Have :
- Informatica IDMC / MDM certification.
- Experience with Customer 360 / Business 360.
- Cloud migration or hybrid architecture experience.
- Exposure to real-time streaming and event-driven architectures.
- Experience with enterprise-scale integration projects.
Education :
B.E / B.Tech / M.E / M.Tech or equivalent qualification.
Skills
Informatica, Informatica IDMC, IICS, ETL, Data Integration, MDM, Data Lineage, Metadata, Data Pipeline, Data Modeling, SQL