6 rounds in total 1. Initial screening round - discussion on past experience and compensation expectations. there is one huge negative aspect to their hiring process. The recruiter says they might offer you a lower level if they think your performance during the interview wasnt up to the mark. the compensation offered would be significantly different for the lower position. 2. past experience/explain a project - pretty straightforward, interviewer hardly spoke. 3. SQL coding round - more or less simple questions. they say you wont be penalised if you don't know SQL, but they do. In my case, I couldnt remember how to compute a cumulative sum and how to get the week number on SQL. the guidelines mentioned in their doc are bogus. My interviewer himself didnt know the exact function to use for a certain question. But, I was penalised for not remembering how to perform a certain operation later on in the round 4. Behavioral questions - I was penalised for "lack of ambiguity in the projects discussed". random round. 5. Deliveroo case study assignment - they'll penalise you for not including metrics/columns that aren't available in the sample data set they provide you. even if you answer the question when prompted on the missing metric, you'll still be penalised. 6. case study round - this was the worst round. Very rude interviewer. She interrupted me multiple times before I would even finish my answer. Extremely impatient. at one point she even got angry about me not knowing we couldnt split orders based on certain conditions for the control and treatment groups. I'm not from the ecommerce space. How would I have knowledge of this? Her feedback was that I don't communicate very well and that I dont have knowledge of statistical concepts. Extremely disheartening experience.