Ctrl K
Sign inStart free
Data Engineer · Senior · System design

The warehouse has two thousand tables, and the business regularly finds out about broken data before the data team does. How would you build a data quality control system?

~10 min by voice

How to approach it

This checks whether you can build a data quality system as a product: prioritize by criticality, combine hand-written rules with anomaly detection, block bad data before it reaches consumers, and work with sources and people, rather than just "write tests for everything".

Have you seen this question in a real interview?
Answers0
Avg. score—
Strong—
Practiced0
Topics
data qualitydata observability
Similar questionsWhat data quality checks would you set up for a table that gets updated every day? JuniorThe business complains that the numbers in dashboards regularly turn out to be wrong, and they find out about it from users. Design a data quality control system for the data warehouse. Mid-level

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Sign in to answer

Best with headphones · ~10 min