I applied through a staffing agency. The process took 2 weeks. I interviewed at TD (London, ON) in Dec 2023
Interview
First call with HR wasnt pleasant but they moved me along to the next stage. There were about 3 rounds of interview, same day within 90 minutes, moving from one meeting room to another. Overall it was a great experience as the process showed they needed someone with a good understanding of what the job entails.
Other Business Intelligence Analyst interview reviews for TD
The first round was with HR, where they asked common interview questions. After that, I received a case study that involved developing a dashboard, which I had to present in the next round within five minutes. The final round was an interview with two team managers—one focused on team dynamics and collaboration, while the other assessed my technical skills by asking SQL and Python questions. I was also required to write code in Notepad while sharing my screen.
Interview questions [1]
Question 1
They asked about my experience working with clients and stakeholders and how I manage multiple tasks. I was also given SQL queries and asked to identify errors in the code. Additionally, they presented three tables without common columns and asked how I would join them.
In the Python section, I was asked to write a function, but I don't recall the exact question.
I applied online. I interviewed at TD (Toronto, ON) in Dec 2024
Interview
This one was a quick process as they were looking for immediate joining and there was a 1 interview day for all candidates, only the technical round(last round). Other roles take upto 2-3 months to be finalized.
Interview questions [1]
Question 1
How would you filter rows that have - in the identifiation number by joining to to a dependent table.
