Bikes Before Rush Hour
A hard Pipeline Design mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- Pipeline Design
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
Trip history lands once a day as files from about 40 city operators, each in its own schema, and every hourly station forecast depends on scheduling those files through ingest, cleaning and feature build before it runs. Design the pipeline from raw ingestion to a model-ready feature store that the forecast reads.
Summary
Bikes in, bikes out. The city needs to predict demand.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Draw your pipeline on the design canvas: sources, transforms, storage and checks
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision