Store, Site, and Distributor
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
Sales records arrive on three clocks: store registers and the website emit each sale as it happens, while distribution partners send a weekly file of their sales and sometimes resend a corrected week to replace the original. Design the pipeline that lands all three in one view of performance across channels.
Summary
Sales data is piling up. Someone has to make sense of it.
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