Informatica IDMC Consultant

Teamware Solutions Inc.; Bengaluru; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Teamware Solutions Inc. seeks an experienced Informatica IDMC Consultant to design and lead end-to-end MDM SaaS, CDI, CDQ, and CAI solutions. You will engage clients, guide junior team members, and provide technical governance across projects.

The role requires strong SQL, data modeling, and troubleshooting skills, with hands-on experience in multi-domain MDM implementations and enterprise integrations. Bengaluru-based position with collaboration across on-site teams.

Qualifications

• 6+ years in data integration, data quality, application integration, or master data management.
• At least 4 years hands-on Informatica IDMC and MDM SaaS experience.
• Strong SQL, data modeling, integration architecture, performance tuning, and troubleshooting.
• Solid client-facing communication, workshop facilitation, and delivery ownership skills.

Responsibilities

• Design and lead end-to-end Informatica IDMC solutions across MDM SaaS, CDI, CDQ, and CAI.
• Lead multi-domain MDM implementations, onboarding, harmonization, migration, and reconciliation activities.
• Configure workflows, approvals, queues, and data governance validations.
• Review configurations for architecture, security, and operational alignment.
• Develop complex mappings, taskflows, schedules, and reusable integration components.
• Establish batch and near-real-time integration patterns across databases, files, APIs, ERP, CRM, and cloud apps.
• Optimize workloads via partitioning, pushdown optimization, concurrency tuning, and workload management.
• Define monitoring, reconciliation, restartability, audit, and error-handling standards.

Skills

Informatica IDMC

MDM SaaS

Data integration

Data quality

REST & SOAP

SQL

Performance tuning

Technical leadership

Client-facing communication

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

• 6+ years of experience in data integration, data quality, application integration, or master data management, with at least 4 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.