Informatica IDMC Consultant

Teamware Solutions; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Teamware Solutions in Bengaluru is looking for a Consultant to design and lead end-to-end Informatica IDMC solutions across MDM SaaS, data integration, and cloud data quality. The role blends hands-on engineering, solution design, performance optimization, and client engagement.

You will guide junior team members and govern data projects while ensuring secure, scalable integration across ERP, CRM, and cloud applications. Strong SQL and REST/SOAP with multi-domain MDM experience are required.

Qualifications

• 3–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.

Responsibilities

• 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.
• 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.
• 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.

Skills

Informatica IDMC

MDM SaaS

Data Integration

Performance tuning

REST/SOAP

SQL

Job description

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
• Mappings, mapping tasks, taskflows, scheduling, parameterization, and orchestration

Cloud Data Quality (CDQ)

• Profiling, cleansing, standardization, validation, enrichment, monitoring, and scorecards
• 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.
• 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.
• 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.