I was called in for a 30 min behavioral interview at first. This interview consisted of your classic behavioral questions such as "tell me a time when you accepted losses to continue a project..." I made sure to give precise and detailed explanations of the situations I had been in for each of these questions. Overall this process went smoothly. I was called the next night to return the following morning to conduct a full on 2 hour follow up interview. This interview consisted of a technical and a case study session. The case study session came first and involved the interviewer asking questions based on a scenario. The technical asked questions mainly concerned with SQL, databases and networking/IT. After this process I was called 3 days later to inform that I had passed unto the next round which will consist of them flying me down to Portland for a full day engagement.

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.