Top 47

Prep plan

Updated weekly · Last refresh Aug 30

Freddie Mac Financial Analyst Interview Questions

The questions to prepare for a Freddie Mac Financial Analyst interview. Questions from real interview reports rank first. Updated weekly.

47questions

~6htotal time

Track your progressSign up free to work through all 47 questions and resume where you left off.

Start practicing free →

1

SQL & Data ManipulationStart here. 4 questions + 3 drills · ~62 min

SQL Matching RecordsMedium

Tests SQL skills for combining datasets and using join logic to find overlaps.

SubqueriesJoinsData Wrangling

Freddie Mac

SQL Data ManipulationEasy

Tests SQL fundamentals for transforming and aggregating data to produce summaries.

Group ByCase WhenAggregations

Freddie Mac

SQL Joins AnalysisMedium

Tests SQL proficiency with joins and ability to structure queries for analysis.

JoinsGroup ByAggregations

Freddie Mac

SQL Duplicate DetectionEasy

Find duplicate customer profiles by grouping on identifying fields and returning only repeated records.

Group ByHavingAggregations

Adtalem Global Education

Amerisave Mortgage

Citrine Informatics

SQL Inner Join for MatchesEasy

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

SubqueriesJoinsData Wrangling

Rank Employees Within DepartmentsEasy

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

Window FunctionsJoinsRanking

Advance Business Capital

More SQL & Data Manipulation questions with a free account

2

Finance & Accounting6 questions · ~48 min

Freddie Mac Housing Market ActivitiesMedium

Evaluates your ability to describe Freddie Mac’s market activities and purpose.

company knowledge

Freddie Mac

Multi-Family and Underwriting KnowledgeMedium

Assesses your domain knowledge for analyzing multi-family credit and risk.

Freddie Mac

More Finance & Accounting questions with a free account

3

Behavioral & Leadership34 questions · ~272 min

More Behavioral & Leadership questions with a free account

4

More topics3 questions · ~24 min

Tell Me About YourselfEasy

Tests your ability to deliver a clear, relevant introduction tailored to the role at Aqr.

Competitive AnalysisGo-to-Market

Investment Opportunity MetricsMedium

Tests understanding of valuation and performance metrics and ability to select relevant measures.

KPIsLeading IndicatorsDiagnosis

Improving a Business ProcessMedium

Assesses your process improvement approach and measurable impact.

market understanding

Freddie Mac

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 47 questions plus 3 hands-on drills to finish this plan.