Capital One Senior Data Analyst interview questions

First round: OA Second round: take home challenge Final round: one behavior + two cases OA: SQL + Python BQ: tell me one of you proud project, and several follow ups on it.

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.