I applied through an employee referral. I interviewed at Capital One in Apr 2021
Interview
1. Online assessment; sql and python coding
2. HR phone call
3. take-home challenge about airbnb dataset
4. onsite, 4rounds, take home challenge presentation and the others focus on case study on credit card knowledge
Interview questions [1]
Question 1
credit card knowledge;
break-even point calculation
I applied online. I interviewed at Capital One in Oct 2021
Interview
Got the online assessment of about 14 to excel problems and 1 SQL problem. The OA itself is not difficult, but I was expected to test Excel. I wasn't finished on time. The SQL problem is pretty friendly, basically the medium to easy on Leetcode. If you want this position, prepare for excel.
Interview questions [1]
Question 1
14 Excel about data cleaning and analytics. A pivot table is frequently used, make sure you are proficient in it.
1 SQL problem, pretty easy.