Freddie mac Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
3Questions
1Company
3 Questions 1 Company
Showing 3 results
Freddie Mac
Medium
Data ScientistCompute 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-...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025
Freddie Mac
Medium
Data ScientistDesign 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...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025
Freddie Mac
Medium
Data ScientistAssess 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):...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025