Went through a referral. Had three rounds in total, which took two months.

1. The first round was a phone interview. The questions were based on design principles and a few on basics. The interviewer expected non-textbookish answers. The task was to design a car manufacturing plant.

2. The second round was again a phone interview, focusing on SQL and fine-tuning queries, specifically indexing. After that, there were a few questions on algorithms and a coding workout on CollabEdit.

3. The third round was a casual chat with the manager about my likes, dislikes, etc. I was then asked to come for a face-to-face round.

4. The fourth round involved a whiteboard session with algorithm and data structure questions, focusing on strings. Later, I had a chat with two product managers who asked about my experience with Agile and how I would handle challenges in an Agile environment.

The whole process, although it took a bit longer, was smooth, very organized, and relaxed. After two weeks, I received an offer.

I was asked to design a disaster recovery system (not IT-related).