Two rounds of interviews. The first was a 1:1 on campus and involved a written test prior to speaking with the interviewer. The test was 3 questions, two involving database design and a third relating to algorithms. With some basic SQL knowledge, the first two were fairly straightforward. The third was a little more challenging because it was a very specific question and involved some computer science knowledge. The interviewer was extremely friendly and very helpful when I didn't know something. I didn't even finish the test, which wasn't a problem.

The second round was on site and had three different groups (2 were 1:1 and the other had 2 interviewers). Same level of difficulty with questions, just more intense. Everyone was very professional and helpful, not as intimidating as I'd expected. Overall, it was a good experience.

How would you find all prime numbers less than or equal to some number n?

Design a database for a set of airlines, airports, and passengers. (And a few subsequent questions relating to your design)