Whole process took 7 days from first call to getting an offer. It started with first telephonic round(50 min), they covered data modeling concepts, architecture, performance tuning, indexing, Enterprise architect, ERWIN. 2nd round was face to face where I was given technical written test which includes objective + subjective questions. Subjective were 3 sql queries quite complex for a person who didn't work on queries extensively. 3rd round was face to face interview with director who asked lot of technical question, these were in depth questions

Interview process was extensive, questions were based on your concept, approach for solving problem. Looking for vision of a person. Expertise in your area. Depth knowledge.