Data Engineer Top Tech Architecture
Texas InstrumentsNested Docs, Flat Reports
Our product team stores application data in MongoDB, but the analytics team needs it in Redshift for reporting. The documents are nested and schemaless. Design a batch ETL pipeline to move this data from MongoDB to Redshift.
Ask the interviewer clarifying questions to understand the requirements and constraints before designing.
When you're ready, click Ready to Design to start building.
Nested Docs, Flat Reports
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
- mid
Interview Prompt
Our product team stores application data in MongoDB, but the analytics team needs it in Redshift for reporting. The documents are nested and schemaless. Design a batch ETL pipeline to move this data from MongoDB to Redshift.
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