Manulife Business Intelligence Analyst interview experience

It started with non-technical questions about my past experiences and communication skills, which set the tone before moving into the technical portion.

When the technical questions came, I was asked to explain SQL join concepts conceptually—specifically inner, left, right, and full joins. The way it was framed felt like they wanted a clear mental model rather than exact syntax.

Overall, it matched the difficulty level for me: I didn’t find it overwhelming, and the questions connected directly to the kind of day-to-day work implied by the role. I didn’t get an offer, but the process was