The Acquisition Still Taking Bookings
A hard 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
- hard
- Seniority
- L6
Interview Prompt
We acquired a hotel chain that runs on a completely different reservation system than ours, and both systems stay live and take bookings for an overlapping set of hotels while their data changes constantly. Operations needs a single unified view of all inventory across both systems that stays current within minutes of any change, reconciled into one count when the two systems disagree. Revenue management separately needs to trace any past inventory count back to the source update that produced it, so the pipeline also has to keep a durable, queryable history of every change.
Summary
Two systems, two schemas. One truth.
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