Capital One Sr. Data Analyst interview questions

There were many rounds. 1. Telephonic casual interview by recruiter 2. Coding challenge (Basic SQL, and coding using any language) 3. Data Challenge ( given a data you have to do your analysis) - this took a long time and effort 4. Onsite interview- There were 4 interviews here a. Behavioral - General Tell me a situation question b. Case- Mobile App checq deposit case. You have to basically find break even. It was hard to understand what the interviewer was telling. c. Data challenge interview- The interviewer will ask about the Data challenge. Be ready to answer any question d. Case Interview- Credit card case. Where one group is divided into test other into control. You have to find the profit . The hardest for me was case interview. Despite a lot of prep. I would suggest the biggest factor here is to comprehend what the interviewer is asking and putting it in a equation. Once you figure the equation you can easily crack the case as it is simple Math. I believe there are not many openings here and the interview just keeps happening. I invested more than a month on this process and did not get a job. More than Data analysis they look at how well you understand the Banking domain which is not appropriate for I am from a Technical background. Advise to all : do not put all your eggs in this process. This is a little shady considering that they value only a crappy case interview so heavily.

I had overestimated the importance of database management and underestimated the role of Python programming for this position when preparing for the interview. While Python is one of my most proficient programming languages, all of the programs I developed in this language were for homework assignments, not professional or semester-long academic projects. The interviewer was intent on having me detail how I analyzed data with Python (and only Python). This threw me off. Granted I sent a list of the work I have done with Python programs in my thank you letter to the interviewer, but I'm afraid the damage is done. I wish the interviewer allowed me to summarize my projects that utilized other programming languages, like MATLAB and R-Statistics.