The Agency That Changes the Columns
A medium 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
- medium
- Seniority
- L6
Interview Prompt
What ETL pipeline should we build to land a government agency's weekly regulatory reporting file in our warehouse, when columns get added or renamed between files and sometimes the whole layout shifts?
Summary
The schema changed overnight. Again.
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