I applied through a staffing agency. The process took 2 weeks. I interviewed at Capital One (Bengaluru) in Sept 2014
Interview
There will be 5 round of the interview, 1.Written SQL aptitude which includes null,aggregate functions, joins and inbuilt functions like string etc.
2.second round will be face to face technical , where you will provide with the data sets and interviewer asks you retrieve data according to his needs. Mostly about joins ranks max min etc
3. Third interview will be puzzle round where you asked about problem solving skills of sorting , grouping, fibi series , searching , eliminating duplicates etc, you have to write the algorithm or pseudo code
4. Behavioral, where you will be asked with the how manage the pressure, how do you work in multiple projects, etc..
5. HR it is to close the deal, about compensation, notice period etc
Interview questions [1]
Question 1
well prepared for the scenario based questions and good knowledge about SQL
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.