Staff Data Engineer Top Tech Architecture
AdobeThe Panel and the Set-Top Boxes
We measure TV viewership for every major network and streaming service in the US. We collect second-by-second viewing data from a 40,000-household panel and set-top box data from 45 million devices, and our clients - the networks, advertisers, and agencies - depend on our overnight ratings reports. Design a pipeline that processes this data, applies the panel weighting to project national estimates, and reliably delivers reports to clients by 10am every morning.
Ask the interviewer clarifying questions to understand the requirements and constraints before designing.
When you're ready, click Ready to Design to start building.
The Panel and the Set-Top Boxes
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
- staff
Interview Prompt
We measure TV viewership for every major network and streaming service in the US. We collect second-by-second viewing data from a 40,000-household panel and set-top box data from 45 million devices, and our clients - the networks, advertisers, and agencies - depend on our overnight ratings reports. Design a pipeline that processes this data, applies the panel weighting to project national estimates, and reliably delivers reports to clients by 10am every morning.
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