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
Me postulé en línea. Acudí a una entrevista en Geotab (Oakville, ON) en feb 2026
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 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
Preguntas de entrevista [1]
Pregunta 1
Why Geotab? What do you know about Geotab? Why this role?