Two Systems, One Room Count
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 operate a hotel booking marketplace with two independently evolving inventory databases: one from a legacy on-prem system and one from a newer cloud platform. Both are continuously updated by hotel partners, but they use different schemas for the same logical entities. Design a system to synchronize both sources into a unified, consistent inventory view that the booking platform and analytics team can query.
Summary
Two booking systems. Rooms do not duplicate themselves.
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