Real, anonymous reports from people who interviewed for Business Analyst at Zomato, newest first and distilled into what to expect across the loop.
After an initial online screening, I ended up in a fairly straightforward sequence: two technical interviews and then an HR round. The whole thing felt structured and not overly drawn out—each interview segment ran roughly 40 to 60 minutes. The technical portion was mostly SQL, and it stayed that way from start to finish. I got grilled on things like different join types (inner/outer/self joins), aggregates, and how queries behave, and there were a couple of stats-oriented questions too—central tendency style reasoning and even a box-plot related question showed up. A few guesstimates also came up, and they were more “figure it out with assumptions” than anything else.
My interview journey leaned strongly into SQL depth plus a bit of statistics and problem-solving. After an early screening, I had a technical screen where I shared my screen and worked through multiple SQL prompts—joins and window-function style questions came up, along with questions about the sequence of execution. There were a few questions in total, and the way it was paced made it clear they wanted correctness and clean reasoning, not just buzzwords.
The interview process heavily emphasizes SQL skills, with multiple rounds dedicated to assessing proficiency in joins, window functions, and query execution. Candidates should prepare for both practical SQL questions and theoretical discussions around data handling and analysis.
Candidates can expect case study prompts that require applying analytical skills to real-world business scenarios, often involving data interpretation and problem-solving. These questions assess how well candidates can connect analytical reasoning with business context.
The interview includes behavioral rounds focused on cultural fit and communication skills, often involving discussions about past experiences and motivations for applying to the role. Candidates should be ready to articulate their alignment with the company's values and their career aspirations.
Expect to encounter guesstimate questions that test logical reasoning and the ability to make assumptions based on limited information. Candidates should practice structuring their thought processes and articulating their reasoning clearly.
The interview process is structured but can vary in length and intensity, often starting with an online assessment followed by multiple interview rounds. Candidates should be prepared for a mix of technical and behavioral questions, with a focus on maintaining a coherent narrative throughout.
The overall difficulty of the interviews ranges from easy to medium, with a strong emphasis on technical proficiency and analytical depth. Candidates should be ready for a rigorous evaluation of their skills, particularly in SQL and data analysis, while also managing the pressure of timed assessments.
