How do you create a 'golden record' from fragmented data?
Tests your ability to design a data reconciliation system. A great answer outlines a process: profiling sources, defining survivorship rules, implementing a matching engine, and creating a stewardship process. A red flag is suggesting a simple one-off script.
This tests your practical experience with Master Data Management (MDM) and data reconciliation. A great answer outlines a multi-stage process: profiling sources to understand quality, defining survivorship rules (e.g., billing system has the most accurate address), implementing a matching/merging engine, and establishing a data stewardship process for manual review. A major red flag is proposing a simple ETL job without a strategy for conflict resolution, duplicate handling, or ongoing maintenance.
Read the original → Wikipedia: Master data management
- #data engineering
- #system design
- #mdm
- #etl
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.