Applied online. Process took close to 6 weeks. 2-3 after applying, got a call from recruiter to make me understand the interview process, role/team overview etc. 1 hour SQL test and then calls with hiring manager and director of BI. Questions about background, interest in the role, case studies etc. Onsite also was similar. SQL test covers joins, window functions (I would rate it medium to hard). Turnaround took couple of weeks (May be hiring manager was on vacation??).

1st round with reruiter. 2nd round with hiring manager. Both on phone. 3rd round was on site and it was 4 1-1 interviews with managers and team members. No gotcha questions, mostly focused on experiences and fit for the company, with a bit of technical test and case studies. HR's turnaround was very quick, and the recruiter was very competent.