I applied through an employee referral. The process took 2 months. I interviewed at RBC (New York, NY) in Apr 2018
Interview
There was only one round because of referral I guess. In person, 2 hours, 4 person, one to one. Most of the questions were behavior questions and some SQL questions.
Interview questions [1]
Question 1
Some basic SQL questions. e.g. What is the difference between left join and right join