Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rolling Delinquency Rate Query

Hard
SQL & Data ManipulationWindow FunctionsDate FunctionsAggregationsAsked 1 times

Problem

Write a query to calculate the rolling 3-month delinquency rate for a specific portfolio given a set of loan performance tables.

Practicing as: Data Engineer interview at dv01

Hi, I'll play your dv01 interviewer for the Data Engineer role. Answer the question above like we're in the room, and I'll respond the way a real interviewer would.

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
dv01 Data Engineer Interview Questionsdv01 Interview Questions
Next questions
dv01Rolling Default Rate by VintageHardNaviRolling 30-Day Default RateHardLendbuzzRolling Delinquency and Approval TrendsMedium