The Panel and the Set-Top Boxes
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
- L6
Interview Prompt
An on-call engineer saw one late operator file and one crashed show projection delay every network's 8am early ratings and every client's 10am finals. We weight a 40,000-home panel against set-top data for 45 million devices that each operator sends overnight on its own schedule. Design the pipeline, keeping every report exactly as a client received it.
Summary
Set-top boxes tell you who watched. Projection tells you how many.
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