The 2nd round interview consisted of two phases: technical interview, and case interview. You had to get there early to do a SQL and Math problem which was reviewed during the two interviews. Pretty intense, I've never seen that before.

On-campus recruiter performed a behavioral interview on campus. Standard questions such as tell me about a time when...(solved a problem, worked with a difficult person, etc.). Recruiter called me that night to schedule Case/Tech interview for the next day. Tech interview - database, networking, server, and OS questions (not "what is the answer to this tech question", but "describe your experience with...") Case interview - Recruiter walked me through a fictional case in which I had to gather requirements, problem solve, and present solutions for a hospital emergency room. Recruiter constantly asked "What else?" every time I gave an answer, which made me think I was missing something even if that wasn't the case. Scheduled on-site visit for a couple weeks later. They made it sound like the job was pretty much mine. Product/tools introduction from a team lead, lunch with two analysts or associates, interview with a manager. Product/tools intro - they made this sound like more of a training than anything else. Most of the time spent was listening to how things work, but there were two ridiculous problem solving questions that apparently lost me the job. Manager Interview - mostly they were gauging my interest in the company (which was very high), goals, some resume clarification questions, etc... Two days after getting home from the trip, they called and said I wasn't good enough in the problem solving.