I applied through an employee referral. The process took 3 weeks. I interviewed at Sun Life (Toronto, ON)
Interview
The interview process was easy and simple. HR sent a Zoom link and the actual interview was conducted over Zoom with just the hiring manager and took approximately 30 minutes.
Interview questions [1]
Question 1
Tell me about yourself.
Explain joins in SQL.
What Pandas is used for.
Pretty ok, it had multiple rounds-first with code, Hiring manager and later with HR team, pretty standard. Mostly uses Azure and AWS as cloud and Python for coding. Technical round included python coding
Started with talking about previous work experience and familiarity with aws and databases, then some behavioural questions and team culture introductions, then the technical interview part - mostly writing sql queries, improving on sql queries, fixing bugs in python code
Interview questions [1]
Question 1
Group by, having by, order by, sql query to extract information requested
2 rounds, hr, director, behv based, and asked your programming experience. Tableau and Power BI experiences are assets. Their HR can get back to you really quick and the whole process took 3 weeks.
Interview questions [1]
Question 1
Do you have previous experience in dashboard reporting?
