Ctrl K
Data Engineer · Mid-level · System design

The 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.

~10 min by voice

How to approach it

The interviewer wants to see whether you can build a system that finds data problems before users do: which quality dimensions to monitor, where to put the checks, what to do when they fail, and who is responsible for fixing things. What matters is not a list of tests but the process around them.

Have you seen this question in a real interview?
Answers0
Avg. score—
Strong—
Practiced0
Topics
Similar questionsThe 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? SeniorWhat data quality checks would you set up for a table that gets updated every day? Junior

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