I applied through college or university. The process took 3 weeks. I interviewed at Geotab (Oakville, ON) in May 2021
Interview
it was quite smooth, first is hr screening, second a real-time coding test and third panel interview with three interviewers asking technical questions not limited to the coding test. some behavioral questions were also asked.
Interview questions [1]
Question 1
Can you give another solution for the coding question?
1. data model design: give me a senario and let me design a database schema. There will be hints
2. SQL questions: give a few schemas and let me write sql query
2. data visualization
I applied online. I interviewed at Geotab (Oakville, ON) in Feb 2026
Interview
The process had 3 rounds. Round 1 was a phone screen with a recruiter covering background, motivation, and basic fit questions. Round 2 was a live CoderPad session with a senior analyst — 5 SQL problems ranging from joins and aggregations to window functions and overlapping interval logic, all written in MySQL. Round 3 was a 45-minute behavioral interview with two senior data analysts on the team. They did a deep dive into resume projects — pipeline architecture, dashboard design decisions, metric selection, fault tolerance, and SQL optimization practices (query plans, CTEs vs subqueries, partitioning, slot contention). The last 15 minutes were reserved for candidate questions. Heard back with a decision within a few days of the final round.
Interview questions [1]
Question 1
Walk us through your data pipeline project — how does it all fit together from data ingestion to the dashboard? Follow-ups included: how did you handle late-arriving data, what Airflow operators did you use, how did you choose which metrics to put on the dashboard, and how did you determine which visualization types were best.
initial screening with recruiter to talk about background and availability, then technical interview on SQL and databases, then interview with hiring manager to talk more about your background and overall fit
Interview questions [1]
Question 1
Why Geotab? What do you know about Geotab? Why this role?