Telephonic interview: Tell me about your self. Tell me about your last project. Why did you chose SQL Server on Oracle. Diff between these products.Then explain me the code (sent by HR 10 min prior to the interview). Tune these queries. Then interviewer asked me to write a few queries on a online notebook. and a few more questions. Onsite Interview: First Round: Interviewer asked me some basic Q's on my resume.About me and about my last project. Then he gave me a problem to solve. It was logical Database related problem. The problem was: Give me a very efficient way to find distinct / uniques in a table having trillions of records. I want to extract data on monthly, weekly and quarterly basis. He was very good and provided me various hints. Lunch Round: Questions related to my education, my experience, etc Second Round: He was database architect. He provided me a piece of information and asked me to build a database for him accordingly. Then he asked me normalize and normalize the structure as per needs. He asked me write 7-10 queries to extract data from this structure. Third Round: It was with prog manager. A very young and dynamic guy. He took my phone interview. He gave me a few events and asked me to explain various business information i can extract from those events. The information i was supposed to extract, was for a business client who has no sense of technology. He wanted to know how his business is doing with those events and it was difficult to explain. Overall it was a great experience and i almost cried when i saw a rejection. I so want to part of this team. They have some of the best people in the team. If you got in, you should feel lucky. This blog is to help you prepare yourself for the interview. This is not an attempt to leak any information.