I applied online. I interviewed at Bell (St. Catharines, ON) in Jan 2025
Interview
Leetcode problems into 5 minute recorded "interview question" answering section. They weren't questions that could be worked out on the fly, as the time constraints were so limited that they had to be whatever the current, most time-optimized answers were.
You will first receive two phone interviews, which consist of some basic questions, and then you will have an on-site interview where most of the questions are common intermediate database questions. The interviewers are enthusiastic and happy to answer all your questions.
Interview questions [1]
Question 1
What is the difference in the usage of having and where clause and what is the execution order of SQL statements?
I applied online. The process took 3 weeks. I interviewed at Bell (Montreal, QC) in Nov 2022
Interview
3 interviews.
1 Phone with recruiter
1 with hiring manager
1 technical interview.
Was tested on my knowledge of SQL, Python and SAS. They care more about your process thinking rather than your technical skills. How you'd deal with missing data. Urgency vs importance. And if you know sas outside of proc SQL.
Interview questions [1]
Question 1
How familiar are you with SAS. Everything is done with SAS here.