Geotab Data Analyst Intern interview questions

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.

First round was HR screening, mostly intro questions, behavioral stuff about projects, and basic questions about my experience. Some very basic technical too like SQL joins, indexes, and 1 of Python. Second round, I got the coding round invite about 3 days after screening. It was on Google Meet, they gave a CoderPad link and I had to share my screen. There were 5 SQL questions, intermediate level, based on Geotab fleet data. Definitely practice window functions, COALESCE, basic CTEs, AVG, ROUND, etc. Total time was 1 hour. Final round, I got the invite about 1 week later. It was 45 mins with the hiring manager and a senior team member. Mostly resume deep dive. They asked me to explain projects and then did a lot of follow ups on why I made certain decisions. They also screenshared my GitHub and went through it. Overall vibe was really nice, everyone was welcoming. I ended up getting the offer (pay and perks were great), but I had already accepted another offer, so I had to decline.