Analyze Returning Borrowers Across Two Days of Logs
Company: Affirm
Role: Software Engineer
Category: Data Manipulation (SQL/Python)
Difficulty: medium
Interview Round: Technical Screen
Overview: Analyze two days of loan activity to find users who appear on both days and have at least two distinct loan types across their combined records. Retain an extensible per-user aggregate for an injected trust policy, with clear duplicate, ordering, complexity, and test semantics.
Read the full Affirm Software Engineer interview experience this question came from