Senior MDM Developer

Experience: 7–12 years in Data Engineering / Data Integration / Enterprise Data Management, with strong hands-on experience in Customer MDM or Identity Resolution.

1. MDM & Customer 360

• Strong experience building or developing Customer MDM / Customer 360 solutions.
• Good understanding of Golden Records, Customer/Party models, source systems, crosswalks and data lineage.
• Should have hands-on experience with customer/individual mastering and deduplication.

2. Entity & Identity Resolution – Critical

• Strong experience in Entity Resolution, Identity Resolution and Record Linkage.
• Hands-on experience with deterministic, probabilistic and fuzzy matching.
• Should understand blocking/candidate generation, matching scores, thresholds, precision/recall, false positives/negatives.
• Experience handling duplicate customers/individuals across multiple source systems.

3. Survivorship & Golden Record

• Strong understanding of attribute-level survivorship rules.
• Ability to determine which source/value should become the Golden Record based on source priority, quality, completeness, recency, verification, etc.
• Experience with merge/unmerge, crosswalks, source traceability and reversible merges.

4. Advanced SQL – Mandatory

• Strong/advanced SQL is mandatory.
• Should be comfortable working with large datasets and complex SQL.
• Experience with CTEs, window functions, MERGE, query optimization and set-based processing.
• Candidate should be hands-on in writing and optimizing production SQL, not just reviewing it.

5. Snowflake + dbt

• Strong hands-on experience with Snowflake.
• Hands-on dbt experience for transformation, modular models, testing, lineage and documentation.
• PostgreSQL experience is preferred.

6. Data Modeling & Data Quality

• Strong data modeling / entity-relationship modeling skills.
• Experience designing models around customers, individuals, organizations, identifiers, relationships and hierarchies.
• Should be able to perform data profiling, cleansing, standardization, validation, reconciliation and deduplication.

7. Engineering Mindset

• This is a custom MDM development/build role, not simply an MDM platform configuration role.
• Candidate should be comfortable reviewing existing logic, identifying gaps, writing production code, testing match quality and continuously improving the Load → Match → Merge → Review → Refine lifecycle.

Ideal Candidate Keyword Combination

MDM / Customer MDM + Customer 360 + Entity/Identity Resolution + Record Linkage + Probabilistic/Fuzzy Matching + Golden Record + Survivorship + Deduplication + Advanced SQL + Snowflake + dbt + Data Modeling

Good-to-Have

• D&B / D-U-N-S
• SAP Customer Master
• PostgreSQL
• Python
• Data Stewardship / Human-in-the-loop exception management
• Graph/network-based identity resolution