The Acquisition Still Taking Bookings

A hard Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant feedback.

Domain

Pipeline Design

Difficulty

hard

Seniority

L6

Problem

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.

Practice This Problem

Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and checks it automatically.