Half a Million Rental Cars
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 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.
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