Dataford
Dataford
Top 18
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

18questions
~2htotal time
Track your progressSign up free to work through all 18 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

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
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
Writing Outer Join SQLMedium

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

sqlThe 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
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
SQL ExperienceMedium
Practice
Practice drill

Aggregate approved employee hours by department, including departments without qualifying records.

experienceJoinsCase WhenNational IndemnityDayforceAvalara
Advanced SQL for Fraud MetricsHard
Practice
Practice drill

Evaluate fraud model thresholds using CASE logic, aggregations, and window ranking for precision and recall.

fraud detectionLag/LeadKPIPhonepe

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 & Leadership12 questions · ~96 min
Walking Through Resume ProjectsEasy

Tests project ownership, prioritization, and communication by asking you to explain resume work with clear scope, decisions, and impact.

Stakeholder ManagementCommunicationOwnershipThe Federal National Mortgage Association - Fannie Mae
Clarifying Conflicting Stakeholder RequirementsEasy

Tests stakeholder requirement gathering under ambiguity, with emphasis on communication, alignment, and turning conflicting input into clear requirements.

Stakeholder ManagementCommunicationOwnershipThe Federal National Mortgage Association - Fannie Mae
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 18 questions plus 3 hands-on drills to finish this plan.