Loading interview...
Hourly ETL Pipeline with Consistency
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
- staff
Interview Prompt
We have an OLTP system that powers our customer-facing application. The analytics team needs this data refreshed every hour in the warehouse. Design an ETL pipeline that loads data from the source system to the target with consistency and reliability.
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