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
wasn't bad at all. 50/50 in terms of behavioral and technical. the people were extremely nice and the questions asked were things you should be aware of from the JD. No live coding, just questions that make you think on how to answer with examples. Still waiting to see if i got in!
Interview questions [1]
Question 1
experience with data analysis and talk to me about how you approached it.
1 30' interview, tackling 1 behavioural and 2 technical questions. They asked for the difference between inner/outer full join, answer a PD database question, but you may search up the syntax. Everything was as listed in the description of the job.
Interview questions [1]
Question 1
Tell me a time you solved a problem at work and how you approached it.
Thirty minute interview, fifteen minutes behavioural and then the rest was spent on an easy SQL / Python problem. Coding wasn't mentioned in the email interview invite. Behavioural questions were general behavioural questions to get you talking about your skills and questions about your background and previous experience.