I received an online test as a pre-screening with technical questions around SQL and big data. A recruiter then reached out to me 2 months later and advised me that my resume and online test answers were evaluated against open positions and found to be more suitable for Data Analyst Manager role. I was asked if I was still interested in interviewing for that role which I happily agreed with. Next interview was 1-hour technical skills assessment with Director. It started with a scenario for which I was asked to write psuedocode/SQL query for 4 questions - which I was able to answer all successfully. Then Director mentioned that he can't evaluate me for Python because I wasn't familiar with it and seemed disappointed even though I had mentioned beforehand that I wasn't familiar with it. Director himself wasn't sure what full brackets for column names are used for in SQL. Recruiter then reached out to me again and advised that they would not be moving forward with my application. I asked for an honest feedback on what they didn't find compatible in my interview but was told that they can't provide specific feedback. Then recruiter mentioned that I could still be considered for a senior analyst role if I was interested. It seemed like Capital One was confused about which role they wanted to hire for and what kind of candidate to look for. They kept changing roles for interview which made me lost all interest in the company.

1. Take home test 2. 4-5 rounds of technical, role play and managerial rounds 3. Over all good experience 4. Basic ML fundamentals, Python coding, ML model building life cycle, communicating ML performance to stake holders