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.

The topics include indexing in SQL Server, clustered index, execution plans, index seek, and bookmark lookups.