Which Promotion Is Actually Working
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
- L6
Interview Prompt
ERP shipment events stream out continuously, about two million a day, while each of roughly 300 retailers drops a daily sell-through file and third-party market data lands once a week. Design the ingestion and analytics warehouse that turns all three into ROI for about forty concurrent trade promotions, each source loaded on its own cadence.
Summary
Was the promotion worth it? The data knows.
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