Everything Lands, Then It Ships
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
- mid
Interview Prompt
Every night roughly 900 of our distributors drop about 3,000 sales files into a shared bucket, around 40 million rows in CSV, semicolon exports and the odd spreadsheet, with columns that drift without warning. Design the nightly batch pipeline that turns them into trustworthy daily sales by distributor and product for BI each morning.
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