I applied through a job portal and after 1-2 weeks of submission, scheduled a 30-minute phone screening.

The call went well, and they scheduled me for an F2F interview.

Four rounds of interviews were scheduled initially. On the day of the interview, they changed it to three rounds as one interviewer was unavailable.

First Round: Talk through of resume and many questions on Hadoop and how to handle different scenarios.

Second Round: Design an ER diagram for the iTunes App Store and write SQL queries on it (easy).

Third Round (Hiring Manager Round): He explained the current system and challenges, and asked 3-4 questions about how I would perform in particular scenarios.

Design a database design (ER Diagram) for the iTunes App Store.

What was the last technical book you read?

Are you part of any technical group memberships?