I submitted my resume on our university job postings and received a call for a telephonic interview after 2 weeks.

Telephonic interview was for about 30 to 40 minutes.

He asked me about myself, my past experience and some database questions (about indexes).

Then within a week I was called onsite for 1:1 interviews.

There where 3, 1 hour technical interviews.

They told me to design some databases on white board and write some queries.

All the 3 interviews went well.

I got a call from HR next day morning, that I was offered the position.

Design a database...Will you use index, on what columns, why? Write queries ()complex queries with 'exists' and 'non exists' clause.