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.