The first phone interview was a short 15 minute HR interview. The second phone interview was 1 hour long and consisted of basic skills questions as well as a logic test (the "bridge crossing" puzzle). A couple weeks later I went in for the first in-person interview, which consisted of a 'fill in the circles' multiple choice logic test, another logic puzzle test, a whiteboard code question, a whiteboard SQL question, and some 'corporate culture' (do-you-fit-in-here) questions. This interview took 4 hours. They wanted me back the next day for another in-person, which consisted of more code and SQL questions, customer service questions, and a code problem (on a machine with the interviewer watching over my shoulder). This interview took 2 hours.
When it was all said and done, they said their goodbyes, and called me back a few days later, saying I was "95% of what they wanted," and did not make me an offer.
