A 30-engineer company has one daily Python ETL: it runs on a cron, lands rows in Snowflake, and feed
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
Interview Prompt
A 30-engineer company has one daily Python ETL: it runs on a cron, lands rows in Snowflake, and feeds a Looker BI dashboard. The transform has no orchestrator owning its schedule, no observability watching its output, hardcoded credentials, no catalog, no CI runner, and no cost attribution. Apply the section's six-undercurrents framing and add each one as named tooling around the four roles already on the canvas.
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