Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Handling Incomplete Financial Data

MediumSQL & Data Manipulation00:00
I
Practice interviewer
Your interviewer
In session
I
Interviewer

Welcome to your interview.

The question is on your right: Handling Incomplete Financial Data. 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 (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.

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