I had an initial recruiter screen, technical screen, a hiring manager call, then a full day virtual onsite. It was pretty standard as far as mature tech companies go, and they did a good job sheparding me along the process and keeping me informed.

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...

Applied to the position which already had 200+ applicants. And no surprise that wasn’t selected for interviews. The good news was they sent out an email letting you know that