Ho presentato la mia candidatura tramite l'università. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso RBC (Toronto, ON)
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Don't remember the exact question. but had to use window function for the sql query
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso RBC
Colloquio
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!
Domande di colloquio [1]
Domanda 1
experience with data analysis and talk to me about how you approached it.
Ho sostenuto un colloquio presso RBC (Toronto, ON)
Colloquio
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.
Domande di colloquio [1]
Domanda 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.
