Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Reconciling Data Across Sources

MediumPipelines00:00
Practice interviewer
In session
5 left
00:00

Your question is Reconciling Data Across Sources. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

You need to log in / sign up to chat or submit.

Problem

Scenario

You're working with data that arrives from multiple internal systems before financial analysis begins. The sources do not always line up cleanly, so you need a repeatable way to compare records, resolve differences, and produce a trusted dataset.

Question

What is your process for reconciling data from different sources before analysis?

What this tests

  • ETL design for multi-source finance data
  • Join strategy across inconsistent business keys
  • Data quality checks before analysis
  • Idempotent reruns and exception handling