There are two rounds, human resource for intention and behavioural questions, as well as some questions based on the resume. Then the full time staffs in the team would hold the second round.
I applied through college or university. The process took 2 weeks. I interviewed at RBC (Toronto, ON)
Interview
Couple of sql questions, pretty simple and basic ones like using the distinct features etc. Recommend learning the concept of window function. Then just some behavioural qs as to how do you manage time, my most impressive accomplishment etc.
Interview questions [1]
Question 1
Don't remember the exact question. but had to use window function for the sql query
HR has scheduled 30 min. of interview with manager. It was easy applied in June 2nd 2024, the Inteview was on 17th jun 2024 and accepted offer on 18 june 2024