I applied online. The process took 3 weeks. I interviewed at Sun Life
Interview
As my first interview process was fairly straightforward, it started with a 30min phone screen followed by a take home technical test. The last stage that I got to was being interviewed by a manager, senior software developer and a junior developer. They where all very welcoming and made me feel very comfortable.
Interview questions [1]
Question 1
Since the role revolved around data, they ask about me experience in manipulating data.
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?