Capital One Senior Data Analyst interview questions

It had 4 rounds. 1st is Online Assessment with 14 MCQs related to Excel and 1 SQL function. 2nd is Recruiter call to match and relate experience. 3rd is Data challenge which is take home assessment, to be done in 10 days and go to maximum extent of analysing the data as per industry norms and standards. 4th is Power day with 4 rounds- Behavioural, 2 Case, Data Challenge technical. Recruiter and interviewers were friendly and highly supported.

It was sticked to the job qualifications, intermediate level experience, had to write a pre assessment test which was sticked to technical questions, Asked to write a sql query which was in Joins