The Metric That Moved
A medium 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
- medium
- Seniority
- mid
Interview Prompt
Engagement events stream from the mobile apps at about 20,000 per second, monetization files arrive once a day from a dozen ad partners, and three internal services are pulled nightly. Definitions like an active story viewer get rewritten every quarter. Design the pipeline that lands these sources and shapes them into warehouse tables for analysts.
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