The Register Never Sleeps
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
- L5
Interview Prompt
We're a retail chain with 600 stores and a Snowflake data warehouse. Our POS terminals generate sales transactions in real time but right now they batch-upload to S3 at end of day, which means the operations team can't see intraday sales. Design a pipeline that gets POS data into Snowflake with low latency, while correctly merging with the historical data already in the warehouse.
Summary
Every swipe lands in the warehouse. The table has to stay current without breaking.
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