Fifty Thousand Retailers
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 consumer packaged goods company selling through 50,000 retail partners worldwide, and sell-through data arrives three ways: distributor EDI files and retailer portal exports on daily and weekly drops, and direct-to-consumer orders that stream in continuously. Design one unified sell-through pipeline across all three channels where every row carries how fresh its source is, and where promoted units stay separable from baseline for demand planning. Retailer files routinely include duplicate and bad-code rows the data team needs to review, so route those aside for triage rather than silently dropping them.
Summary
Retail data at CPG scale. Every SKU, every store.
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