Informatica MDM Architect

BDO India; Mumbai; On-site; INR 2,500,000 - 3,500,000; Full time

Job summary

BDO India is seeking a senior MDM consultant to evaluate and strengthen master data management across enterprise systems. You will assess business processes, data ownership, and governance to improve data quality and stewardship.

You will review MDM architecture, integration patterns, data flows, and migration controls, advising on pragmatic improvements and industry best practices for multi-site organizations.

Qualifications

• 7+ years of experience in data management / MDM / data architecture.
• 5+ years of hands-on Master Data Management experience.
• Strong experience with Informatica MDM or another leading MDM platform.
• Experience assessing MDM architecture, data quality, integration and operating models.
• Profisee experience is desirable but not mandatory.

Responsibilities

• Business & Current-State Assessment: document challenges and stakeholders.
• MDM Architecture Assessment: evaluate architecture and patterns.
• Integration & Data Flow Assessment: review end-to-end data flows and interfaces.
• Data Quality & Migration Assessment: assess data quality and migration controls.
• MDM Operating Model: review governance, roles, and incident processes.

Skills

MDM

Informatica MDM

Data architecture

Data governance

Data quality

Root cause analysis

APIs

SAP

Salesforce

Oracle

Tools

Profisee

Azure

Microsoft Fabric

Microsoft Purview

Job description

Experience

• 7+ years of overall experience in data management / MDM / data architecture
• 5+ years of hands‑on Master Data Management experience
• Strong experience with Informatica MDM or another leading MDM platform
• Experience assessing MDM architecture, data quality, integration and operating models
• Profisee experience is desirable but not mandatory

Required Technical Experience

Mandatory:

• Strong experience with Informatica MDM or another enterprise MDM platform
• Strong understanding of MDM architecture and implementation patterns
• Experience with matching, merging, survivorship and golden-record concepts
• Strong understanding of data quality and data governance
• Experience reviewing enterprise integration architectures and data flows
• Experience with data migration, reconciliation and validation
• Experience assessing MDM operating models and stewardship processes
• Ability to analyse complex MDM implementations and identify root causes of business/data issues

Desirable:

• Profisee experience
• Azure / Microsoft Fabric / Microsoft Purview
• API and integration architecture
• SAP, Salesforce, Oracle or other enterprise source/consumer systems
• Experience with MDM health checks or independent implementation reviews
• Experience in retail, FMCG, hospitality or multi‑site organisations

Key Responsibilities

1. Business & Current-State Assessment

• Understand the business processes dependent on master data
• Document current challenges, business impacts and manual workarounds
• Understand how master data is created, maintained, approved and consumed
• Identify key business and technology stakeholders
• Assess current data ownership, stewardship and governance arrangements

2. MDM Architecture Assessment

• Review the overall MDM architecture and solution design
• Assess the alignment between business requirements and the existing MDM implementation
• Identify unnecessary complexity, duplication or over‑engineering
• Assess MDM patterns including - Master data domains, Golden records, Matching and deduplication, Survivorship, Hierarchies, Data stewardship, Data governance
• Assess whether the current solution is aligned to MDM best practices

3. Integration & Data Flow Assessment

• Review the end‑to‑end data flow between source systems, MDM and downstream applications
• Analyse how master‑data changes propagate through the organisation
• Identify potential causes of incorrect downstream updates
• Review integration patterns, interfaces, APIs, batch processes and event‑driven processes
• Assess data ownership and system‑of‑record responsibilities
• Review reconciliation, monitoring, error handling and exception‑management processes
• Identify control gaps contributing to downstream business issues

4. Data Quality & Migration Assessment

• Assess the quality and integrity of data migrated into the MDM platform
• Review migration methodology, reconciliation and validation controls
• Identify potential gaps in data profiling and cleansing
• Review DQ rules, thresholds and exception processes
• Determine whether current DQ controls are overly restrictive relative to business requirements
• Recommend a pragmatic approach to data-quality management

5. MDM Operating Model

• Assess the current MDM support and operating model
• Review roles and responsibilities across business, IT, data stewards and support teams
• Assess governance and decision‑making processes
• Review incident and problem‑management processes
• Identify opportunities to improve operational ownership and accountability