Three Providers, One Workout
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 connected-fitness platform that ingests workout events from three external providers, each with its own data format and delivery mechanism, and the same session often arrives from more than one provider at once. Finishing a workout is the user-facing reward, so a completed session has to reach the leaderboard within about a minute and count once no matter how many providers reported it. Heart rate and GPS are protected health data: they cannot sit on the leaderboard's own store, only permissioned consumers may read them, and every read of the raw fields has to be audit-logged.
Summary
The same ride, reported three times.
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