Dataford
Top 18
Prep plan
Updated weekly · Last refresh Sep 22

Freddie Mac Risk Analyst Interview Questions

The questions to prepare for a Freddie Mac Risk 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
StrategyStart here. 3 questions · ~24 min
Rates, Prepayment, and Credit RiskHard

Tests understanding of interest rate effects on prepayment behavior and downstream credit risk.

credit riskFreddie Mac
Loan-to-Value and Risk PricingEasy

Tests understanding of LTV mechanics and how they drive credit risk pricing decisions.

LTVFreddie Mac
Drivers of Mortgage Credit RiskMedium

Tests ability to identify and explain key factors driving credit risk in mortgages.

Business Acumencredit riskFreddie Mac
2
Behavioral & Leadership11 questions · ~88 min
Overcoming a High-Stakes SetbackMedium

Tests resilience and ownership under pressure, especially in ambiguous situations that require clear prioritization and measurable recovery.

personal growthresiliencechallengeFreddie Mac
More Behavioral & Leadership questions with a free account
3
More topics4 questions · ~32 min
LIBOR vs EURIBORMedium

Evaluates your grasp of benchmark rates used in financial risk modeling and analysis.

Freddie Mac
Live Coding: Prime NumbersHard

Tests Python coding ability and correctness on a data-processing task.

coding challengepythonFreddie Mac
Interest Rate Swaps BasicsMedium

Assesses your understanding of interest rate derivatives relevant to Freddie Mac risk analysis.

Freddie Mac
SQL Joins and Missing LoansMedium

Tests SQL join logic and the ability to diagnose missing records in loan datasets.

null handlingJoinsfinancial dataFreddie Mac

Sign up to see every question

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

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Rank Employees Within DepartmentsEasy
Practice
Practice drill

Rank active Revature employees within each department using RANK and a department join.

Window FunctionsJoinsRankingAdvance Business CapitalRevatureFreddie Mac
SQL Inner Join for MatchesEasy
Practice
Practice drill

Filter Freddie Mac loan records to return only current loans, ordered by loan identifier.

SubqueriesJoinsData WranglingFreddie Mac
Window Function for Second-HighestMedium
Practice
Practice drill

Use window functions to identify regions tied for the second-highest mortgage application volume.

Window Functionsfinancial dataRankingFreddie Mac
The finish line: interview-readyComplete all 18 questions plus 3 hands-on drills to finish this plan.