Retail & CPG · Informatica
Global CPG deploys multidomain MDM across 32 markets
92% golden-record match rate · $65M working-capital release
At a glance
Key metrics
Challenge
The situation
Thirty-two country organizations each ran their own customer and product masters. Duplicate retailer records broke promotion settlements. Inconsistent product hierarchies meant global brand teams couldn't see true performance of a SKU across markets. Working capital sat trapped in reconciliation disputes with trade partners.
Approach
How we delivered
- 01 Global data council chartered up front — sponsorship from CFO and Chief Commercial Officer, with country-GM accountability for data-steward resourcing.
- 02 Implemented Informatica IDMC MDM across customer, product, and supplier domains in sequence, each with a 6-month deliverable and measurable KPI commitment.
- 03 Built market-by-market rollout accelerator: pre-built mappings for SAP ECC, SAP S/4, Salesforce, and regional ERPs; automated match-rule tuning; exception-handling workflow pre-loaded for stewards.
- 04 Ran a "fix at source" program in parallel — every golden-record conflict flagged upstream so the next month's data landed cleaner.
Architecture
Solution architecture
Informatica IDMC as the system of reference for customer, product, and supplier. Source hubs (SAP ECC, S/4HANA, Salesforce, regional ERPs) integrate via CAI and CDI. Data quality rules authored in Informatica Cloud Data Quality, reference data managed in Informatica Reference 360. Stewardship via the IDMC Customer 360 and Product 360 apps. Downstream syndication to Snowflake for analytics and to Stibo STEP for PIM-side product enrichment. Reltio explored and deferred in favor of IDMC given existing Informatica footprint.
Outcomes
Measured results
- Golden-record match rate reached 92% across customer (up from 54% pre-program).
- $65M one-time working-capital release from resolving disputed trade receivables.
- 41% reduction in pricing leakage tied to promo-settlement disputes.
- Time-to-add a new retailer dropped from 11 days to under 2.
- Global brand teams, for the first time, reported SKU performance on a single global taxonomy.
Technology
Tech stack
MDM
- Informatica IDMC MDM
- Customer 360
- Product 360
- Supplier 360
Data quality & reference
- Informatica Cloud Data Quality
- Informatica Reference 360
Integration
- Informatica CAI
- Informatica CDI
- Event-based sync to SAP via IDoc
Source systems
- SAP ECC
- SAP S/4HANA
- Salesforce
- Regional ERPs
Downstream
- Snowflake
- Stibo STEP PIM
Apptad delivery
- Multi-market MDM rollout accelerator
- Match-rule tuning playbook
“We had spent fifteen years calling this an impossible problem. Apptad broke it into 90-day chunks and we actually started counting wins at quarter one.”
Related
More outcomes
Chasing a similar outcome?
Tell us your target — cycle time, cost, risk, adoption. We'll walk you through what we've delivered closest to it.