Informatica IDMC Consultant

Role Summary

The Consultant will design and lead end-to-end Informatica IDMC solutions across MDM SaaS, Cloud Data Integration, Cloud Data Quality, and Cloud Application Integration. The role combines hands-on engineering, solution design, performance optimization, client engagement, technical governance, and guidance of junior team members.

Mandatory Skills:

Mandatory capability Expected hands-on coverage

Informatica MDM SaaS Business Entities, relationships, hierarchies, match and merge, survivorship, Golden Records

Cloud Data Integration (CDI/CD)

Mappings, mapping tasks, taskflows, scheduling, parameterization, and orchestration

Cloud Data Quality (CDQ)

Profiling, cleansing, standardization, validation, enrichment, monitoring, and scorecards

Cloud Application Integration (CAI)

Process objects, service connectors, APIs, event-driven processes, REST and SOAP

Key Responsibilities

MDM SaaS

Design and implement Business Entities, relationships, hierarchies, reference data, match and merge strategies, survivorship rules, and Golden Record management.

Lead multi-domain MDM implementations, master data onboarding, harmonization, migration, and reconciliation activities.

Configure stewardship workflows, approval processes, queues, exception management, and business validations.

Review MDM configuration and ensure alignment with architecture, data governance, security, and operational requirements.

Cloud Data Integration (CDI/CD)

Design and develop complex mappings, mapping tasks, taskflows, schedules, parameterization frameworks, and reusable integration components.

Establish batch and near-real-time integration patterns across databases, files, APIs, ERP, CRM, and cloud applications.

Optimize workloads using partitioning, parallel processing, pushdown optimization, concurrency tuning, and workload management.

Define monitoring, reconciliation, restartability, audit, and error-handling standards.

Cloud Data Quality (CDQ)

Design enterprise data quality frameworks covering profiling, cleansing, standardization, validation, enrichment, monitoring, and remediation.

Define reusable rule libraries, scorecards, quality thresholds, exception outputs, KPIs, and governance controls.

Lead data quality analysis and root-cause resolution with data owners, stewards, and application teams.

Cloud Application Integration (CAI)

Design and develop process objects, service connectors, APIs, application integrations, and event-driven

orchestrations.

Define secure REST and SOAP integration patterns, error handling, observability, and response management.

Troubleshoot and optimize synchronous and asynchronous processes across enterprise applications.

Required Qualifications

3 to 6 years of experience in data integration, data quality, application integration, or master data management, with at least 2 years of hands-on Informatica IDMC and MDM SaaS experience.

Strong implementation experience across Informatica MDM SaaS, CDI/CD, CDQ, and CAI is mandatory.

Strong SQL, data modeling, integration architecture, performance tuning, and troubleshooting skills.

Solid understanding of REST, SOAP, JSON, XML, relational databases, security controls, and enterprise integration

patterns.

Strong client-facing communication, workshop facilitation, technical leadership, and delivery ownership skills.

Preferred Skills

Experience integrating SAP, Salesforce, ServiceNow, Oracle, Workday, Snowflake, Databricks, Azure, or AWS.

Knowledge of Data Governance and Catalog, Business Glossary, Reference 360, metadata management, or CI/CD for IDMC deployments.

Experience in multi-domain MDM programs and data migration initiatives.

Informatica MDM SaaS or IDMC certification.