I applied through college or university. The process took 3 weeks. I interviewed at OMERS (Toronto, ON) in Jan 2023
Interview
The interview was focused on skill-based questions and went into my proficiency with Python, SQL, Excel, and Power BI. They were mostly interested in my previous job experience and the extent of my contributions to the role. And in the second phase of the interview, they asked for direct coding-based questions. Finally, they asked me about the capital markets and investment management firm-related questions where I messed things up.
Interview questions [1]
Question 1
What are the joins in SQL, lambda function etc, how much do you know about capital markets?