Capital One Senior 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.

1. Code Signal (1 SQL, 9 Data Analysis using any language) 2. Data Challenge (2 weeks to complete) 3. Power Day (4 Interviews: 2 Case Interviews, 1 Behavioral Interview, 1 Data Challenge Presentation)