Applied through LinkedIn. Received contact from recruiter for 30 minute call. All behavioral questions. Next step was online technical Excel and SQL test. I had one hour to complete. It was not live (somebody did not watch you while you did it). Was not too difficult if you are used to using pivot tables and can run simple SQL queries. Then had video call with hiring manager. All behavioral. Final step was on-site with 4 people. 3 behavioral and one case. Case was not a typical consulting case and was more like brainstorming. Received a call two days later that I did not get the position. I felt the rejection reason was a bit weak considering I passed in all other areas and they knew my background before going through all the rounds. Maybe the other candidate was just better.

Excel test, case study over phone, Several rounds in person, then a follow up once more in person. Thorough, but moved reasonably quick to provide feedback. Good contact with the recruiter throughout