First hr will email and schedule a short phone screen. Then interviewed by hiring manager on Teams. Hands on SQL and pbi questions was asked. Then second round to meet with director on site.
Initial recruiter screening, followed by a technical interview assessing SQL, analytics, and problem-solving, then a behavioural interview focused on teamwork, communication, and role fit, with final review by hiring managers.
I applied through an employee referral. I interviewed at Enercare (Markham, ON) in Dec 2025
Interview
Basic SQL Functions and queries such as JOINing tables, difference between left and right joins, and other basic functions
Resume/Work Experience in terms of SQL Usage
Should understand Excel basic functions like XLookup, Cleaning Data, Removing dublicates, etc
Interview questions [1]
Question 1
What are left and right joins, and what is the difference between them?