The interview process with Huron was fairly long. I was reached by one of their recruiters early December 2013 to see if I was interested in the position. Basic stuff here really, are you familiar with SQL, would be willing to relocate, etc. I then got a second call to set up a more in depth phone interview. This included 2 parts, a behavioral interview and a technical interview.
The behavioral interview had questions like, name me a moment where you went above and beyond for your employer, what is a weakness of yours, tell me a bit about yourself.
The technical interview was focused more on my knowledge of IT systems. Can you describe to me what a LAN is, describe to me 1st, 2nd, 3rd normal form, name me some SQL statements.
After that if they are still interested they will set up on on-site interview. This interview consists of 4 parts - A case question, a company overview, lunch "interview", and closing interview.
The case question I got was about an ER room and it's efficiency, how to come up with a solution, what to look for, etc. They also will give you a pretty basic math problem to do.
Company overview was basically just a description of the different units in the company, where your role will be, how they function, etc. Expect a brain teaser and an SQL question here (a basic one, like a join query or something)
Lunch interview is an opportunity for you to meet 2 employees and ask them any questions about the company, it wasn't them asking the questions, it is you, so take this opportunity to learn as much as possible.
Closing interview is where I was asked to kind of go through my resume, tell him why I think I'm a good fit, what makes me interested in the position, how comfortable am I with what I've learned today etc.
Really the on-site interview is them looking for a good cultural fit.
The entire process took about a month.