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?
