The Distributor Filing Problem
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 are a large consumer goods company that receives weekly sales data files from hundreds of independent distributors. Each distributor uses its own reporting format, and the data feeds centralized analytics used by the sales forecasting and supply chain teams. Design the pipeline that ingests, normalizes, and loads this distributed data into the central warehouse.
Summary
Hundreds of suppliers. One warehouse. One deadline.
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