Sixty Minutes, Every Hour
A medium Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- medium
- Seniority
- L6
Interview Prompt
We run an OLTP database behind a customer-facing app, and the analytics team needs its data in the warehouse within an hour of every change, refreshed on the hour. Design a pipeline that pulls source changes without loading the live database, exposes each hour to consumers all at once so a dashboard never reads a half-updated hour, and can replay missed windows after an outage without dropping or double-counting rows. Deletes at the source, including GDPR erasures, must stop the record from being queryable.
Summary
Every hour, on the hour. No excuses.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision