The initial steps take a long time, especially the HR component. Once the HR interview is complete, felt like it took a couple weeks for next interview, but after that the rest of the process went by fast. As i was an internal hire, the start date was pushed out based on the discussion between old and new managers, which sucked!
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
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.?