Freddie mac Data Scientist Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Implement blocked time-series cross-validation
Implement a panel-aware blocked time-series cross-validation splitter with an embargo. Input: DataFrame columns [loan_id, msa, month]. Requirements: (...
Design a quasi-experiment for FHFA policy
Causal Impact of FHFA's April 15, 2024 Multifamily Underwriting Tightening Context On April 15, 2024, FHFA tightened underwriting standards for multif...
Compute leakage-safe rolling features in pandas
Using pandas on a 50M-row monthly panel with columns [loan_id, msa, month, property_type, delinquent_90dpd (0/1), upb], create features for each loan-...
Choose estimators for panel rent regressions
Panel Rent–Vacancy Elasticity and Inference: Design, SEs, and Time-Series Diagnostics Context You have a monthly property-level panel from 2010-01 to ...
Design a hierarchical MF delinquency forecasting system
Forecasting 90+ Day Delinquency Rates for Multifamily Loans: Hierarchical, Leakage-Safe System Design Context You need to forecast 90+ day delinquency...
Prove SQL proficiency with concrete outcomes
SQL Proficiency Self‑Assessment and Evidence (Technical Screen) Provide a concise self‑rating and concrete, real‑world examples that demonstrate your ...
Design SQL cleaning, mapping, dedupe, and keying
Assume PostgreSQL 15. You may choose a different SQL dialect if you clearly state it and adapt syntax accordingly. Schema and small sample data: - Tab...
Assess SQL cleaning, mapping, joins, keys, and DDL/DML
You inherit a small retail analytics warehouse. Use the schema and sample rows below to answer all parts. Schema and sample data (minimal rows shown):...