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.
Started with an OA, and then proceeded to data challenge, and afterwards it was Power Day which had 4 rounds of interview. 2 of them were more problem-solving, and one of them was walking through the data challenge
Interview questions [1]
Question 1
In one of the rounds I was a given a question related to debit/credit card
Powerday 4 rounds back to back. One data challenge presentation , two cases and one behavior round. Overall easy and it was a nice experience. Interviewers responded the follow up questions detailedly.
I applied through university. I interviewed at Capital One (Plano, TX)
Interview
1) CodeSignal proctored test. Tests analytical prowess and SQL. Time is tight, with increasingly difficult questions. You have to pass to move on.
2) Data Challenge. Python coding challenge to answer 5 questions. You need to merge/ clean your dataset and make a recommendation. You present it during power day.
3) Powerday. 4 interviews back to back. 2 case interviews, 1 behavioral interview, 1 data challenge interview.