I had 3 rounds of interview including phone screen, in-person interview and HR round and it took a month to the offer.
Here are the details :
1. Recruiter reached out to me asking behavioral questions(phone screen)
2. 3 days after- Hiring Manager interview round with mixed of technical questions from SQL, Alteryx, data pipelines, visualization and analytical questions related the business problems they are facing in the team(phone screen)
3. 2 week after- In person interview with 6 different people from the same team and cross functional team and ranged from 30 min -45 min but last for 5 hours , questions related to analytical problem solving with the business problems, technical questions from data mining, SQL, Alteryx, Tableau, process related questions, questions evaluate the soft skills like communication, presentation, negotiation.
4. 1 week after- recruiter reached out to me about their decision with the offer