Dataford
Top 50
Topic roadmap
Updated weekly · Last refresh Sep 13

Top 50 Reconciliation Interview Questions

The most frequently asked Reconciliation questions across all roles and companies, ranked by real interview frequency. Updated daily.

50questions
~8htotal time
445companies covered
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 28 questions · ~284 min
Find Duplicate Records QueryEasy
Practice

Find duplicate Unity Test Framework runs using GROUP BY and HAVING, including duplicate groups containing NULL values.

Group ByReconciliationHavingUnity TechnologiesValueMomentumValueLabs
Clean Null Campaign MetricsEasy
Practice

Use CASE and COALESCE to standardize missing StackAdapt campaign metrics and count incomplete rows by campaign.

null handlingData WranglingReconciliationStackadaptCvent
Validate Bank Reconciliation CompletenessHard
Practice

Compare ledger and bank transactions to flag unmatched items and reconciliation gaps.

Data WranglingReconciliationAggregationsADP
Unify Campaign Performance SourcesMedium
Practice
Recently asked

Use CTEs, joins, aggregations, and CASE logic to combine Salesforce, Marketo, and Google Analytics into one monthly campaign report.

Data WranglingperformanceReconciliationPalo Alto Networks
SQL Duplicate Transaction DetectionMedium
Practice

Identify repeated transaction records within February 2025 using aggregation, date filtering, and account joins.

fraud detectionJoinsReconciliationSoFi
Deduplicate Shipment Events for Lead TimeMedium
Practice

Use CTEs and ROW_NUMBER to remove duplicate shipment events, fill missing created times, and compute shipment lead time in days.

null handlingReconciliationdata integrityAnduril
Clean and Reconcile Bank ExportsHard
Practice

Clean mismatched transaction fields and reconcile Rippling records against bank settlements.

data cleaningfinancial dataData WranglingRippling
Dynamic Fee Reconciliation in SheetsMedium
Practice

Reconcile Rippling payment fees against contract rates and identify processor fee anomalies.

financial dataReconciliationdata anomalyRippling
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
2
Behavioral & Leadership19 questions · ~193 min
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~30 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.