Brief behavioral interview to start. After discussing various topics on my resume, we moved on to some technical questions about SQL. Overall a very relaxed and inviting interview. I left feeling much more informed and interested in the company.

Did an on-campus interview with Informatica at IU. This went well. Basic interview questions to start with. Why would you be an ideal candidate? Tell me about a project the went wrong. and so on. Then there was a chance to ask them questions. I asked about things like the culture and the travel time. Do your research but dont be too nervous. Then I was asked to go to Chicago to do an onsite interview. They paid expenses. This was a whole morning process. There was 3 separate interviews. A rotation of sorts. They all asked general questions but then each had some interesting things to say. I had one rude and negative guy and two nice and pleasant guys. Not sure if this was a tactic on their part or an actual personality trait of that man. But the interviews went well. They called me 2 weeks later and offered the job.