I applied through university. I interviewed at BMO Financial Group (Toronto, ON) in Mar 2023
Interview
One round with HM with both technical and BQ. Mainly about SQL queries and culture fit for the team. Followup questions about previous experience with SQL and database. Positive interview experience.
Interview questions [1]
Question 1
Do you have experience dealing with large scale database?
I applied through university. The process took 2 weeks. I interviewed at BMO Financial Group (Toronto, ON) in Dec 2020
Interview
Initial hire vue recorded session. After that an HR representative will contact you for a one on one with the team lead. I was interviewing for a role at a new project that they were implementing within the firm. Interview was mostly behavioural with some basic SQL questions. I was promised i'd recieve either a rejection or offer after following up but never recieved either after following up twice.
Interview questions [1]
Question 1
Given this table, give me an SQL query to retrieve how much of "x" has carries the trait "y".
