The Fleet That Never Stops
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
- L5
Interview Prompt
We run a large last-mile delivery fleet where every truck streams its GPS location continuously, and operations needs a live map showing each vehicle within seconds of it reporting, plus alerts when telemetry looks anomalous. Trucks routinely drop off the network in tunnels and rural stretches, then reconnect and dump hours of buffered pings at once, and the ingested history still has to come out complete. The data science team needs a clean archive of that history to train route-optimization models, but driver location is treated as personal data, so analytics can see it only masked or aggregated, never as raw coordinates. Design the pipeline.
Summary
Every truck is talking. Not everyone can hear them yet.
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