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

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.