Top 50
Topic roadmap
Updated weekly · Last refresh Sep 14

Top 50 financial data Interview Questions

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

50questions
~11htotal time
526companies 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. 35 questions · ~477 min
SQL Month-over-Month Revenue ComparisonMedium
Practice
Recently asked

Compare each product's current and previous month revenue, including absolute and percentage changes.

Window FunctionsLag/LeadDate FunctionsGoogleKeyrus France
SQL Window Functions for Portfolio AnalysisHard
Practice
Recently asked

Rank portfolios by monthly net transaction value using PostgreSQL window functions.

Window FunctionsPivotfinancial dataMacquarie Group
SQL for Market MetricsMedium
Practice

Aggregate daily market metrics by product, including volume, price range, average price, trade counts, and VWAP.

Date Functionsfinancial dataGroup ByIntercontinental Exchange Holdings
Maximizing Money in Infinite BagsMedium
Practice
Recently asked

Find the highest-value consecutive bag segment for each financial input case.

Data Manipulationfinancial dataAggregationsAmazon Web Services
Prepayment and Journal EntryMedium
Practice
Recently asked

Identify valid prepayments and return the corresponding debit and credit journal entry accounts.

ledgerfinancial datadata validationAccenture
Second-Highest Transaction for AdvisorMedium
Practice
Recently asked

Use DENSE_RANK and a join to find the second-highest distinct posted transaction for a Raymond James advisor account.

Subqueriesfinancial dataRankingRaymond James Financial Services
SQL for Options Average PriceEasy
Practice

Calculate the average option trade price for the previous calendar month using date filtering, aggregation, and a reference join.

Date Functionsfinancial datasqlCiti
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 & Leadership8 questions · ~109 min
More Behavioral & Leadership questions with a free account
3
Pipelines3 questions · ~41 min
More Pipelines questions with a free account
4
More topics4 questions · ~54 min
Peak Transaction Volume in WindowMedium
Practice
Recently asked

Use a sliding window to find the maximum transaction volume within a bounded time range.

aggregationfinancial dataArraysT. Rowe Price
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.