Nightly Exports Are Too Slow
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
- L5
Interview Prompt
Our healthcare analytics platform pulls claims and member data from several operational databases, and the nightly full exports are both too slow for the utilization management team's same-day authorization decisions and heavy enough that the database teams will not sign off on any further load to production. Every record that lands in the analytics warehouse is regulated PHI, so member identifiers and clinical fields have to be stripped or pseudonymized before they reach the warehouse, not masked in views layered on top of it. Design a change-capture replication pipeline that keeps the warehouse current without adding load to the source systems.
Summary
Healthcare claims change constantly. The warehouse cannot fall behind.
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