On Final round, there are live business cases led by an interviewer. I was given a business problem (e.g., increasing revenue for a retail bank product), and I had to walk through the problem structure, make assumptions, perform quick math, and propose recommendations. The interviewer provided data along the way.
Tip: Capital One's cases are not like consulting (McKinsey-style) but more conversational and practical, often with data interpretation and business sense.
Online assessment - hr call - data challenge-hr prep call- power day. 4 round, 3.5 hrs. Data - case - BQ - Case. Typical questions. Got ghosted after power day.
Attended the first CodeSignal round and waiting for the next round results. It might be a lengthy process as it took 3 months for the codesignal assessment to arrive. Good Luck
Interview questions [1]
Question 1
It had 15 questions with 6 questions asked with regards to one csv, 1 SQL question, rest were based on 4 csv data. I'd say start with the 4 csv and try using sheets as its very simple analysis questions. Mostly joins, aggregatins