The Sale That Needs to Land Now
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 a global luxury e-commerce marketplace where sales arrive from three channels in three shapes: the web storefront pushes JSON events, the mobile apps send batched JSON, and partner retail integrations are polled as XML, and every order has to be reconciled into one canonical record before anything downstream reads it. Merchandising runs live flash sales and needs sales from all three channels landing in their dashboard within minutes to tune discounts, so no channel can sit behind a daily-batch-only path, while the data science team only needs a clean daily archive for modeling. Many buyers are in the EU, so customer email and shipping address are GDPR-regulated and can never sit in a queryable table in the clear.
Summary
Three channels feeding one view. Not all of them speak the same language.
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