Capital One interview questions

I had to walk through a case interview where I broke down a business problem, did some quick math, and interpreted charts to support my recommendations. It wasn't very difficult just need to explain your thought process

1- Online Codesignal assessment of 15 questions 2- HR phone screen (30 min) 3- Interviewer-led mini case interview (45 min) 4- Technical Fit SQL interview (1 hr) 5- Powerday (2 full cases back to back, 1 hr each) - I did not make it to this step. The process was rather drawn out and long given that I gave the initial SQL test in early July and my last step (technical fit) happened mid-september. They don't tell you why you didn't make it and do not disclose any feedback which is not helpful. I also felt blindsided by their team in technical fit interview. The guide mentioned it would involve verbal questions and SQL assessment involving answering their database questions with "pseudocode". In the actual interview, the interviewer fully expected me to write executable queries (which is fine) without any syntax error even though I had no indication of which SQL engine it is. Their overall process is thorough but I think they are very conventional and sort of stuck in the past with their interview practices.