Towers and Phones, Same Story
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
Our connectivity team collects telemetry from cellular towers globally - signal strength, handoff events, and coverage measurements - and we need to combine this with mobile app performance logs to understand how network conditions affect user experience. Design the data warehouse pipeline including the ingestion architecture and the dimension/fact schema.
Summary
Tower signals meet app events. Somewhere in between is the truth.
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