The Whiteboard Exercise
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 run an e-commerce marketplace where transactions live in a Postgres database, customer records come from a rate-limited CRM API, and a partner ships the daily product catalog as CSV files over SFTP. About 50 business analysts open a dashboard at 8am each morning to slice yesterday's transactions by customer, product, channel, and date, so all three sources have to land in the warehouse during the overnight window: the customer detail from the CRM, the product detail from the partner catalog, the transactions from Postgres. Keep the load resilient to the partner's occasional CSV column changes and the CRM API's rate limits, and design the pipeline end to end.
Summary
Marker in hand. Draw the whole thing.
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