Senior IDMC Developer

Senior Informatica IDMC Developer

Experience: 8–12 Years

Employment Type: Full-Time

Work Location: Remote

Notice Period: Immediate Joiners Preferred

About the Role

We are seeking an experienced Senior Informatica IDMC Developer with strong hands-on expertise in Informatica Intelligent Data Management Cloud (IDMC), Cloud Data Integration (CDI), and Cloud Data Quality (CDQ).

The ideal candidate should have extensive experience designing, developing, configuring, and maintaining enterprise integration solutions using Informatica IDMC/IICS.

This is a hands-on development role requiring strong knowledge of cloud integration, complex mapping development, data quality implementation, workflow orchestration, SQL, and production support.

Key Responsibilities

1. Informatica IDMC Development & Configuration

• Design, develop, configure, and maintain integration solutions using Informatica IDMC/IICS.
• Work extensively with Cloud Data Integration (CDI), including mappings, mapping tasks, taskflows, and transformations.
• Develop complex integration pipelines connecting multiple cloud and enterprise applications.
• Configure source-to-target mappings, reusable components, parameterization, and dynamic mappings.
• Develop incremental and full-load data synchronization processes.
• Configure and maintain Informatica Secure Agent, runtime environments, connections, and scheduling.
• Troubleshoot mapping failures, integration issues, and processing errors.
• Optimize IDMC mappings and taskflows for performance and scalability.

2. Cloud Data Integration (CDI)

• Develop and maintain complex CDI mappings using Lookup, Joiner, Expression, Aggregator, Filter, Router, and other transformations.
• Design reusable mappings and parameterized integration processes.
• Configure taskflows, scheduling, dependencies, and error-handling mechanisms.
• Implement data synchronization between cloud applications, databases, and enterprise systems.
• Develop and optimize high-volume data integration solutions.
• Monitor integration jobs and resolve execution failures.

3. Cloud Data Quality (CDQ)

• Develop and maintain data quality mappings, cleansing processes, standardization, and validation rules.
• Perform data profiling and identify data quality issues across multiple source systems.
• Configure reusable data quality assets, rule specifications, and transformations.
• Implement data deduplication, parsing, standardization, and enrichment processes.
• Work with reference data and address validation capabilities.
• Integrate data quality processes into IDMC workflows to ensure data accuracy and consistency.

4. Integration & API Development

• Develop and support integrations between IDMC and upstream/downstream enterprise applications.
• Work with REST/SOAP APIs, web services, and cloud application integrations.
• Support batch and real-time integration requirements.
• Configure and troubleshoot data publishing and synchronization processes.
• Work with relational and cloud databases such as Oracle, SQL Server, and Snowflake.
• Troubleshoot connectivity failures, integration errors, and performance issues.

Required Skills & Experience

• 8–12 years of overall IT/data management experience, with significant hands-on development experience in Informatica IDMC/IICS.
• Strong expertise in Informatica Cloud Data Integration (CDI).
• Hands-on experience developing complex mappings, mapping tasks, transformations, and taskflows.
• Strong understanding of Informatica IDMC architecture and cloud integration capabilities.
• Experience with Informatica Cloud Data Quality (CDQ).
• Experience configuring and troubleshooting Informatica Secure Agent.
• Strong understanding of data integration architecture and data management concepts.
• Strong SQL skills with experience in Oracle, SQL Server, Snowflake, or similar databases.
• Experience integrating cloud and enterprise applications.
• Knowledge of REST/SOAP APIs and web-service integrations.
• Experience with parameterization, scheduling, error handling, and performance optimization.
• Good troubleshooting, debugging, and production support capabilities.
• Ability to independently develop, configure, test, and deploy IDMC solutions.

Good to Have

• Experience with Informatica Cloud Application Integration (CAI).
• Exposure to Snowflake cloud data warehouse integration.
• Knowledge of data profiling, cleansing, standardization, and enrichment.
• Experience with reusable mappings and dynamic mappings.
• Familiarity with cloud-based data governance and data management practices.
• Exposure to enterprise integration modernization and migration projects.

Candidate Profile

The ideal candidate should be:

• A hands-on Informatica IDMC/IICS Developer, not purely an administrator or support resource.
• Strong in CDI mapping development, taskflows, and transformations.
• Experienced in cloud integration and data quality implementation.
• Comfortable working independently within the Informatica IDMC environment.
• Able to understand complex business requirements and translate them into technical integration solutions.
• Strong in SQL, troubleshooting, debugging, performance tuning, and production support.
• Capable of collaborating with business, data engineering, application, and data governance teams.

Core Technical Skills

Primary / Mandatory:

Informatica IDMC | IICS | Cloud Data Integration (CDI) | Mapping Development | Mapping Tasks | Taskflows | SQL | Secure Agent | Cloud Integration | Performance Tuning

Secondary:

Cloud Data Quality (CDQ) | REST/SOAP APIs | Cloud Application Integration (CAI) | Snowflake | Data Profiling | Data Cleansing | Data Standardization