1. Was first given a take-home assessment that's about cleaning a given dataset and took me a day ish to finish
2. Zoom interview (90 minutes) about past experiences and then a SQL challenge
3. On-site interview (4 hours). Everyone seemed to be nice but you need to be careful about showing your thinking process of how to solve the problems as I sort of overlooking it when I started solving the coding problem. The interviewer consider me as memorizing the solution. I did have done the same question before but jumped into setting up the question for 2 minutes, then explained the solution I had in mind. I guessed it was these two minutes that made the interviewers think I had it memorized and lacked iterative thinking, which I did not expect them would think this way as I did walk them through my thinking process before I started coding the main logic. Overall the interview was not too hard, it's just that you did not know when you would accidentally give them a reason to red flag you.