The interview process lasted about one month and during this time period, I did three rounds of interviews. First was the recruiter round. Shortly after passing that, I was given a take home assignment consisting data analysis and written portion (estimated time spent: 3 hrs to generate a good report). after one week later, I was told I passed and will be moving to a live technical troubleshooting. It took one extra week to schedule that. After completing the live interview, I waited for one more week and was finally rejected. Overall, the process was very slow but on the bright side you have lots of time to prepare. Btw please do not be like me and study for 5 hours and on top of that, take a sql course to prepare for the live interview. You will only need to know very basic sql and look at the API docs for at most one hour to prepare yourself. no need to memorize anything from API docs, but you should familarize with the doc so you know where to look

It was a very straight forward process and always make sure to lean into your recruters. They want you to nail the interview. They provide you essentially everything that will be in the interview leading up to the interview itself.