Senior Informatica MDM Consultant — SKU / Product Master Data

Role summary
We are seeking a hands-on Informatica MDM Consultant to design, configure and deliver a SKU master data solution on Informatica MDM. The engagement establishes a single trusted "golden record" for a defined SKU catalogue (initial scope: 150 SKUs), consolidating data from multiple source systems (Excel and database sources), synchronising to SAP HANA, and maintaining consistent SKU identity across SAP HANA and Syndigo.

This is a build-and-configure role with a robust stakeholder-facing component: the consultant will work directly with business SMEs and data stewards during discovery to confirm field definitions, match/survivorship logic and the golden-record ownership model, then configure the platform to deliver against that design.

Domain note: The scope centres on packaging specification data for consumer/product SKUs. Prior exposure to product/packaging master data (e.g. CPG, manufacturing, retail) is a strong advantage.

Key responsibilities
SKU golden record & data model




Design and build the SKU master data model (base objects/business entities), establishing a single trusted record for each SKU consolidated from multiple sources.
Define and manage packaging specification attributes (text-based fields), including data types, acceptable value formats and validation, confirmed with business SMEs.
Source system onboarding & integration
Configure ingestion from two source systems (Excel files and database sources) into MDM.
Configure downstream synchronisation of golden records to SAP HANA.
Maintain cross-system identity / key mapping so that SKU identifiers remain consistent across MDM, SAP HANA and Syndigo.
Matching, merging & survivorship
Configure and tune match rules (exact and fuzzy) to identify and consolidate duplicate or overlapping SKU records across source systems.
Define trust and survivorship rules that determine, at attribute level, which source system wins in conflict scena

📌 Informatica Developer (India)
🏢 Caelius Consulting
📍 India