The Distributor Filing Problem
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
A consumer goods company receives weekly sales files from hundreds of independent distributors, each in its own reporting format, and the sales forecasting and supply chain teams analyze them centrally. Design the pipeline that ingests, normalizes, and loads these files 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
- 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