Capital One Sr. Data Analyst interview questions

The interview process had 3 rounds. Round 1: CodeSignal Online Assessment - The OA had 14 statistics questions, which had to be solved using Excel sheets, and 1 SQL leet code question. Round 2: Data Challenge - A 10-day-long assignment to answer a few business questions from the given metadata. The focus is on data lineage, wrangling, outlier handling, and calculations to provide the correct recommendations. Round 3: Power Day - 4 interviews at a stretch. 2 Case interviews, 1 Data Challenge defense, and 1 Behavioral round.