Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Reliable ETL with Backfilling

Health Care Solutions At HomeHardPipelines00:00
Health Care Solutions At Home
Your interviewer · Data Engineer
In session
Interviewer

Welcome to your interview for the Data Engineer role at Health Care Solutions At Home.

The question is on your right: Reliable ETL with Backfilling. Take a moment with it first.

Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen. You have three graded attempts to score 7/10 or better.

Only Submit answer is graded - discussion is free practice.

Problem

How would you design a reliable ETL pipeline for patient and billing data with validation, monitoring, and backfilling at Health Care Solutions At Home?