Sr. Data Engineer Top Tech Architecture
RedditThe Analysts Cannot Touch Production
Our product runs on a transactional database that the analytics team cannot query directly. We need to replicate it to a separate analytics system where they can run reports. The source data is messy and split across several tables that need to be normalized and combined before it is useful. Design a pipeline to replicate and prepare this data.
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 Analysts Cannot Touch Production
A medium 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
- medium
- Seniority
- senior
Interview Prompt
Our product runs on a transactional database that the analytics team cannot query directly. We need to replicate it to a separate analytics system where they can run reports. The source data is messy and split across several tables that need to be normalized and combined before it is useful. Design a pipeline to replicate and prepare this data.
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