Six Hours to Miss a Deadline
A medium Pipeline Design mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- Pipeline Design
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
Design an incremental replacement for our nightly warehouse load, which today rebuilds about 12 billion rows of credit positions and ratings feeding risk models and regulatory reporting. Only around 1 percent of those rows change on a normal day, yet every night we reload all of them.
Summary
The rebuild works. It just doesn't finish in time.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Draw your pipeline on the design canvas: sources, transforms, storage and checks
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision