I applied online. The process took 1 week. I interviewed at Scotiabank (Toronto, ON) in Nov 2019
Interview
talking directly to manager and asked some technical SQL questions. no phone interview and talking about 40 mins, then i went home waiting for almost 2 weeks for result
Interview questions [1]
Question 1
what is the difference between union and union all
Reached out to by HR after 1 week and a team member after applying online after 1.5 weeks. Was given less than a working day of notice for the first-round online interview. During the call, the questions felt unstructured. They repeatedly pressed me on why I wanted the role, but never actually explained what the role fully entailed. Communication stopped immediately after the call—no feedback, no update.
two rounds of interview, one hirevue and one in person and one group coffee chat, friendly process in general, very interesting to learn about the team. good experience over all, thumbs up
nice vibe with very professional structure. with multiple normal bq and mainly ask you about your resume, so need to prepare your resume carefully, you need to familiar with anything on your resume
Interview questions [1]
Question 1
about your resume, how to improve processing effiency