It was a 4 round interview. First it's an interview with HR, then technical interview with Manager, then live coding interview(SQL focused and a bit of Python), then a virtual on-site interview( 3 separate 1 hour interviews with different departments. A week or two after the onsite interview I got rejected without giving a specific reason, and this is what bothered me the most since I've spent a total of 6+ hours overall interviewing at Affirm, and getting a generic rejection.
Interview questions [1]
Question 1
What is a problem you've faced at work and how did you handle it.
I applied through a recruiter. I interviewed at Affirm in Jan 2021
Interview
A recruiter reached out on LinkedIn and after recruiter call, there was an interview related to your background and project with Director.
After that, coding round was scheduled. It was more of SQL design round
Interview questions [1]
Question 1
Given loan process, how would you design your table and answer reporting questions, such total number of customers.