Went through a referral. Had three rounds in total and took two months.
1> The first round--> This was a phone interview. The questions were based on design principles and few on the basics . The interviewer expected non-textbookish answers. Design a car manufacturing plant.
2> Second Round--> Again a phone interview. This time it was on sql and fine tuning queries. Indexing to be more specific. After that was a few question on algorithms and a coding workout on collabedit.
3> Third round --> The third round was a casual chat with the manager. My likes,dislikes etc. I was asked to come for a face to face round.
4>Fourth round--> A white board session with algorithms and data structures questions. The questions were on strings. Later had a chat with two product managers . They asked me my experience with agile and how I would handle agile environment related challenges. I
The whole process,although it took a bit longer , was smooth and very organized and relaxed.
After two weeks I got an offer.