Staff Data Engineer Elite Architecture
MaterialEvery Dataset Needs a Paper Trail
We're a pharmaceutical company ingesting data from clinical trial systems, commercial sales databases, and patient support program feeds. The data governance team has mandated that every dataset entering the warehouse must have a documented data quality check, a lineage trace, and an access control policy before it goes live. Design the ingestion pipeline and governance framework.
Ask the interviewer clarifying questions to understand the requirements and constraints before designing.
When you're ready, click Ready to Design to start building.
Every Dataset Needs a Paper Trail
A hard 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
- hard
- Seniority
- staff
Interview Prompt
We're a pharmaceutical company ingesting data from clinical trial systems, commercial sales databases, and patient support program feeds. The data governance team has mandated that every dataset entering the warehouse must have a documented data quality check, a lineage trace, and an access control policy before it goes live. Design the ingestion pipeline and governance framework.
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