First, I had to clear the hackerrank online test, which had around 3 SQL and python questions. One problem-solving question and one question for making a dashboard. First interview at Bolt for Senior Data Analyst position. -Interviewer introduced himself and the job. -Asked for my introduction. -Asked to explain one data analysis project from start to end. -the difference between where and having in SQL. -Primary Key? -How to deal with null values in a column? - commerical team asked to make dashboard for key kpis. write squence of steps on how to make it. - The conversion rate in Bolt food app dropped by 10% in the last 2 days. asked to identify reasons behind the change, describe the metrics and what are the steps. And then cross-questioning on it. - 30% increase in gross sales in Bolt Food app. why management is unhappy after this - bolt is expanding in a new city. how would u determine the area of operation and prices They really want to check your problem-solving skills. I didn't make past first interview round

5 interviews Hr screening case study sql test and then 3 more interviews. Interviews are highly technical in terms of statistical understanding. Moreover business understanding should also be top notch.