Long, difficult, with high exceptions and high competition. Even at the final stage, you are trying to outcompete other applicants. The bright side is the recruiter helps you prep with docs/materials that you're expected to study so there are no surprises.

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