Capital One Sr. Data Analyst interview questions

Phone Interview with HR, and Online Test and Onsite (four behavioral questions and two cases). Then talked with the hiring manager for one hour. Got an offer very quickly

There were 6 rounds of interview. 1st round is 20 mins aptitude and 25 minutes sql+algorithms 2nd and 3rd are pure techinical rounds where you will be asked to write some queries from the dataset which they already have. Mainly analytical functions like lead, rank etc. 4th will be like a manager round / behaviour round. 5th will be a case round and 6th will be a case round again. I was told i El be having only case analysis round but they took one more case round and i did not get through in the 2nd case round.