Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Handling Incomplete Financial Data

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

Your question is Handling Incomplete Financial Data. 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

You are given Ati financial data that appears incomplete or inconsistent across related tables. Explain how you would use SQL to investigate missing joins, NULL-heavy fields, duplicate records, and conflicting values before producing a final reporting dataset.

What This Tests

  • Using LEFT JOINs to find unmatched records
  • Using aggregations to profile and reconcile data
  • Using CASE WHEN to classify anomalies
  • Explaining when to filter, flag, impute, or escalate issues