Dataford
Top 20
Prep plan
Updated weekly · Last refresh Aug 30

The Federal National Mortgage Association - Fannie Mae Data Analyst Interview Questions

The questions to prepare for a The Federal National Mortgage Association - Fannie Mae Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

20questions
~3htotal time
Track your progressSign up free to work through all 20 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Handling Missing and Dirty SQL DataMedium
Recently asked

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityThe Federal National Mortgage Association - Fannie Mae
Calculating Net Present ValueMedium

Evaluates your understanding of NPV and your ability to apply it to project evaluation.

npvFinancial AnalysisThe Federal National Mortgage Association - Fannie Mae
Maximizing Profit From DataMedium

Assesses your approach to analytical problem solving and decision-making using data.

business strategyData AnalysisThe Federal National Mortgage Association - Fannie Mae
Writing Outer Join SQLMedium

Evaluates your SQL proficiency with outer joins and correct query construction.

sqlThe Federal National Mortgage Association - Fannie Mae
Solving Complex Problems With SQL or PythonMedium

Tests your technical depth and structured problem-solving with SQL or Python.

sqlpythonThe Federal National Mortgage Association - Fannie Mae
Finding the Break-Even PointMedium

Evaluates your ability to model break-even analysis and translate it into actionable insights.

Data Analysisfinancial metricsThe Federal National Mortgage Association - Fannie Mae
SQL Moving Average With WindowsMedium
Practice
Practice drill

Calculate each customer’s 30-day moving average of daily transaction totals using aggregation and a PostgreSQL window frame.

Data AnalysisJJP Morgan ChaseFinacleThe Federal National Mortgage Association - Fannie Mae
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
Top Users by Region QueryMedium
Practice
Practice drill

Rank the top 10 ResMed myAir users in each region using joins, aggregation, and ROW_NUMBER().

Data AnalysissqlResmed
2
Behavioral & Leadership13 questions · ~104 min
Resolving Team Disagreement on ApproachEasy
Recently asked

Tests conflict resolution in a delivery context, including communication, influence without authority, and ability to preserve team trust while reaching a decision.

Influence Without AuthorityConflict ResolutionCommunicationThe Federal National Mortgage Association - Fannie Mae
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
Efficient Ride-Hailing DecisionMedium

Assesses your product sense and ability to make data-driven tradeoffs between options.

efficiencycomparisonThe Federal National Mortgage Association - Fannie Mae

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 20 questions plus 3 hands-on drills to finish this plan.