The Vendor Who Never Warns You
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
- L5
Interview Prompt
An external vendor sends us a data file every month, and its structure shifts without warning: new columns appear, existing ones get renamed, and some are occasionally dropped. Design the pipeline that ingests it for the analysts' monthly reporting.
Summary
Every month, something is different. The dashboards have no idea.
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