The Migration That Cannot Break Morning
A hard 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
- hard
- Seniority
- L5
Interview Prompt
The 6am reports cannot miss a single morning while we move 60 production pipelines from our on-premises platform to a cloud warehouse before the hardware lease ends in nine months. Design the architecture that carries the migration itself, from the old and new pipelines through to the reports.
Summary
It all works today. Moving it without losing a single report is the hard part.
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