The longest interview process I've ever had. Started with a screening with the recruiter - he asked two basic technical questions - how to find unique values in a dataframe, and what is a window function. Moved on to a technical round. Had a 30mins SQL interview asking about basic SQL functionality, and then 45mins python interview - mostly about string/tuple/dict manipulation with for loops. Basic stuff. Moved on to the hiring manager. Just behavioral questions and learnt more about the role. Moved on to the final "on-site". 6 interviews, 4.5 hours in one day... 3 technical interviews. First one was an hour long and was about data exploration. This really should be a take home. It's insane to ask questions about the data, without letting me explore the data - when I would try to, the interviewer would tell me I was overthinking it. Which is fine, but it was a domain I was not an expert in, unrelated to the role. I needed to understand the data before I could answer questions about it. Interviewer was also very unclear in her ask. I got the impression that she was junior and was inexperienced in running these sessions. Next one was a modeling. Had to build a model from scratch - from data pre processing to validation and evaluation. Was actually fairly easy since I prepared a framework ahead of time. So be prepared to take a dataset a build a full model around it in an hour. Next interview was a case study with AB testing. It was a half hour and fairly straightforward. Then I had 2 more behavioral interviews and a final interview with the hiring manager again. One of my behavioral interviews was not great - the person I was talking to did not seem interested in talking to me. She was also asking me behavioral questions that didn't really make sense...