Pennymac Loan Services Financial Analyst Interview Questions
The questions to prepare for a Pennymac Loan Services Financial Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain VLOOKUP vs INDEX/MATCH and how lookup design maps to SQL joins and key matching.
Pennymac Loan ServicesTests your ability to write correct SQL joins and perform grouped aggregations for loan reporting.
Pennymac Loan ServicesTests your data cleaning approach, validation checks, and ability to protect analysis quality.
Pennymac Loan ServicesCompute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIUse joins and LAG to isolate departments driving a large month-over-month spending variance.
State of California
University of Chicago
The Church of Jesus Christ of Latter-day SaintsMerge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.
ArtefactTests your understanding of secondary market mechanics and how securitization supports mortgage lending.
Pennymac Loan ServicesTests your ability to explain MSR valuation drivers and prepayment risk mechanics.
Pennymac Loan ServicesSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your ability to compute basic rates and unit conversions.
Pennymac Loan ServicesEvaluates relevance of your capital markets mortgage experience to Pennymac Loan Services financial analysis work.
Pennymac Loan ServicesAssesses your analytical process from defining the question to producing conclusions.
Pennymac Loan Services