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

Freddie Mac Data Engineer Interview Questions

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

23questions
~3htotal time
Track your progressSign up free to work through all 23 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 5 questions · ~40 min
Schema Evolution HandlingMedium

Tests your ability to build resilient pipelines that tolerate upstream schema changes.

Data Qualityschema evolutionCloudFreddie Mac
Real-Time Streaming with Zero LossHard

Tests your streaming architecture choices and your strategies for exactly-once or zero-loss delivery.

Data QualityStream ProcessingCloudFreddie Mac
ETL Ingest from Multiple VendorsHard

Tests your ETL design skills for integrating heterogeneous vendor data with reliability and correctness.

data integrationETLBatch ProcessingFreddie Mac
Normalization vs Denormalization in ETLMedium

Tests your data modeling judgment and how you apply normalization and denormalization during ETL.

transformationsETLData ModelingFreddie Mac
More Pipelines questions with a free account
2
Behavioral & Leadership15 questions · ~120 min
Spark Optimization for Data SkewHard

Tests your ability to diagnose and optimize Spark performance issues caused by skew and shuffle overhead.

performancesparkshufflesFreddie Mac
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Join Types and PerformanceMedium

Tests SQL join semantics and performance tradeoffs for large-scale analytical workloads.

Joinsperformancemany-to-oneFreddie Mac
Explain Spark Lazy EvaluationMedium

Assesses your understanding of Spark execution semantics and how transformations are planned.

sparkFreddie Mac
Indexing for Read-Heavy AnalyticsHard

Tests your database design and indexing skills for fast analytical reads at scale.

Performance Tuningstar schemadata integrityFreddie 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
SQL Duplicate DetectionEasy
Practice
Practice drill

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

Group ByHavingAggregationsAdtalem Global EducationAmerisave MortgageCitrine Informatics
The finish line: interview-readyComplete all 23 questions plus 3 hands-on drills to finish this plan.