Capital One Sr. Data Analyst interview questions

The interview has 2 technical rounds and 1 loop. First-round: Proctored Codesignal test which includes SQL + 14 data manipulation questions that can be answered as per your convenience (using excel or python). Second - round: Data challenge ( airline dataset). You will be given 14 days to answer. Final Loop- contains 4 rounds. 1- Technical involves Data challenge presentation and technical discussion 2- Case study One 3- Behavioral 4- Case study Two More emphasis is put on the case studies than on the rest two rounds. Interviewers are good at giving positive impressions, so it wouldn't help you assess if your interview is going well. Even if you successfully answer your case studies, the chances are you might not be offered the position. I think they put more emphasis on how you present yourself, like maintaining your professionality even if they seemed friendly and do not get too comfortable. Remember that the loop lasts 5 hrs long, so make sure that you are energetic.

Overall the interview process was good and interviewers were friendly and willing to help you solve problems during the interviews. However, the case interviews require some background knowledge, especially financial knowledge so that I failed this test.