Informatica MDM (Master Data Management)

Module 1: Master Data Management Concepts

• MDM definition: single version of truth for business data
• MDM styles: consolidation, registry, coexistence, centralised
• Business entities: customer, product, supplier, employee
• MDM vs data warehousing: complementary roles
• Informatica MDM products: MDM Hub, Customer 360, Product 360
• MDM programme stakeholders: business and technical

Module 2: Informatica MDM Hub Architecture

• Hub Store: operational reference store (ORS)
• Staging, base object, and cross-reference tables
• Trust and validation framework
• MDM Hub Console navigation
• Schema Manager, Match and Merge Manager
• Hierarchy Manager and Relationship framework

Module 3: Data Modelling in MDM

• Base object creation and configuration
• Column and data type definition
• Lookup tables and code lists
• Parent-child relationships and foreign keys
• History tracking and effective dates
• Entity 360 data model design

Module 4: Data Loading & Staging

• Stage tables: landing zone for source data
• SIF API: Service Integration Framework
• Informatica PowerCenter to MDM integration
• Delta detection and incremental loading
• Batch group and batch jobs
• Source system mapping and trust settings

Module 5: Matching & Merging

• Match rule sets: fuzzy and exact matching
• Match columns: token, fuzzy, null handling
• Match batch and interactive matching
• Merge survivors: trust and override rules
• Unmerge and manual merge operations
• Match review and data stewardship workflow

Module 6: Data Quality in MDM

• Cleanse functions: standardisation and normalisation
• Address verification integration
• Duplicate identification before merge
• Data quality rules and validation
• Informatica Data Quality (IDQ) integration
• Data quality reporting dashboards

Module 7: Hierarchy Management

• Hierarchy types: explicit and profile-based
• Relationship types: account/contact, org chart
• Temporal relationships with date ranges
• Hierarchy query API
• Data governance: approval workflows
• Entity 360 view for end users

Module 8: MDM Operations & Governance

• Data stewardship: workflow for review and approval
• Siperian Hub Services: SOAP API
• MDM REST API for modern integration
• MDM performance tuning: batch sizing
• MDM security: role-based data access
• MDM programme governance and KPIs

Our Informatica MDM instructors are certified Informatica professionals who have implemented MDM programmes for global enterprises in retail, financial services, and life sciences. They bring data governance methodology alongside technical MDM Hub expertise — helping organisations define business entities, ownership rules, and data quality frameworks.