4,500 Stores Before Sunrise
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
Every night, 4,500 stores each upload a CSV of their current inventory to S3, and some of those files land late. Design the pipeline that takes those uploads into the warehouse the replenishment team works from.
Summary
The shelves open at 7. The data better be there.
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