I applied online. The process took 3 weeks. I interviewed at CIBC (Toronto, ON)
Interview
few basic questions, few in-depth SQL and python questions. Few scenario based questions. Overall, good balance of question types. More focus on SQL and Azure. Behavioural questions were kept for round 2.
Interview questions [1]
Question 1
Again, scenario of a schema for which I needed to design the whole schema.?
There are three rounds of interview, including one round of HR interview, one round of hiring manager interview and one round of skip level interview. The process was smooth and straightforward.
I interviewed with CIBC for different positions, and typically with 3-4 rounds,
Very straightforward and professional with structure.
HR- phone call/ teams
HM-experience, deep dive
Cases- not for every role, excel/ complex formulas applied
HM's Manager- culture fit check