Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Reconciling Conflicting Metric Sources

MediumSQL & Data Manipulation00:00
Practice interviewer
In session
5 left
00:00

Your question is Reconciling Conflicting Metric 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

Explain your reconciliation approach

Two Alten Nederland reporting sources return different values for the same financial metric. Explain how you would investigate the discrepancy with SQL, isolate the root cause, and decide which result should be trusted or how the metric definition should be corrected.

What this tests

  • Aligning two sources to the same reporting grain
  • Using joins to detect missing versus mismatched records
  • Rebuilding metrics with aggregations and CASE logic
  • Communicating source-of-truth decisions clearly