Informatica MDM Consultant / Architect

About Company:

BDO is a global network of professional services firms with a presence in over 166 countries, revenue of over USD 14 billion, and experience of over 60 years. Its a leading service provider for the mid-markets with client service at its heart.

BDO India Services Private Limited (or BDO India) is the India member firm of BDO International. BDO India offers strategic, operational, accounting and tax, and regulatory advisory & assistance for both domestic and international organizations across a range of industries. BDO India is led by more than 300+ Partners & Directors with a team of over 10,000 professionals operating across 14 cities and 20 offices. We expect to grow sizably in the coming 3-5 years, adding various dimensions to our business and multiplying and increasing the current team size multi-fold.

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