TechnicalBehavioralMultiple roundsVirtualFast process
SQL assessment was four questions, doable if you know window functions and CTEs. Power Day had two consecutive behavioral inetrviews about identifying unseen problems and explaining technical findings simply. Offer next morning
Questions Asked
1.“Why did Capital One end up on your list”
2.“Whats the difference between a metric and a KPI?”
Data Analyst
Toronto, ON
Summer 2026Declined Offer
University of Waterloo · Computer Science
4th year · 3.7+ GPA · 4+ past internships
Hard Interview
TechnicalMultiple roundsCase studyVirtual
SQL assessment first then Power Day with 2 case interviews a behavioral and a data challenge, cases were hard but manageable. Ended up declining for a better offer but would recommend applying, process is tough but fair
Questions Asked
1.“Write a SQL query to find the second highest salary from an employee table”
Business Analyst
Toronto, ON
Summer 2026Accepted
Western University · BMOS
4th year · 3.7+ GPA · 3 past internships
Hard Interview
Multiple roundsCase studyTechnicalVirtual
All behavioral on hirevue, conflict on a team and time you used data and why do u want to work at Capital One, 30 second prep is brutal and kept re-recording and by the third try just submitted whatever
Questions Asked
1.“Tell me about a time you helped prevent project scope creep”
2.“What's the difference between a business analyst and a project manager?”
3.“How do you handle a situation where two key stakeholders have conflicting requirements?”
Software Engineer
Toronto, ON
Summer 2026No Offer
University of Ottawa · Software Engineering
3rd year · 3.3-3.6 GPA · 2 past internships
Hard Interview
TechnicalMultiple roundsStressfulCase study
CodeSignal OA first, 4 questions in 70 minutes. Third one was doable but the last one involved matrices and was tough. Power Day was like 4 hours of interviews in a row. Had a case interview about whether to drop a credit card fee, actually interesting, then system design was designing some monitoring dashboard. Behavioral was STAR stuff. Just a long day overall
Questions Asked
1.“What's the difference between cookies and localStorage for storing session data?”
Business Analyst
Montreal, QC
Winter 2024Accepted
McGill University · Computer Science
4th year · 3.3-3.6 GPA · 2 past internships
Hard Interview
TechnicalMultiple roundsConversational
Excel assessment with a data set and like 7 questions then power day with one product interview and two case interviews, cases are quant heavy with P&L stuff and weighted averages. They send sample cases beforehand which are similar to the real ones so practice those
Questions Asked
1.“What is a business case and what sections should it contain?”
2.“How do you run a lessons-learned session at the end of a project?”
Software Engineer
Summer 2026Accepted
University of California, San Diego · Computer Science
3rd year · 1 past internship
Technical
There were 3 back-to-back rounds, technical was OOP design, and behavioral was standard. Each round was 1 hour long
Software Engineer
Summer 2026Accepted
University of Waterloo · Business and Computer Science
Had a leetcode style OA and a virtual job tryout (pick which of these statements describe your more, etc.) Then, I was invited for a power day with 3 back-to-back interview. 1 technical live coding round, 1 behavioural round, and 1 case study round. Entire process was very fast, from application to offer took less than a month. (Position is based in the US)