Half a Million Rental Cars

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

Domain

Pipeline Design

Difficulty

medium

Seniority

L5

Problem

We operate a fleet of 500,000 rental vehicles across thousands of locations, each streaming continuous telematics while our reservation system records rentals and service centers log maintenance events, and the operations team has no unified view across the three. Operations dispatches off live vehicle position and needs it within minutes, with fast alerts when a vehicle leaves its assigned region or sits parked for days, while rental visibility can lag up to half an hour and fleet-utilization and maintenance reporting is fine the next day. Because vehicles constantly change depot, accumulate damage, and rack up odometer readings, any report on a past rental must reflect the vehicle's state as of that rental's date, so design the end-to-end pipeline and warehouse that unify the three sources on vehicle id and serve each consumer at its required freshness.

Summary

Every vehicle is reporting. Every rental matters.

Practice This Problem

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