I met a recruiter at the school career fair and handed him my resume. Then applied online.

Day 3, I got a call that my resume is picked for first rounds of interview on school campus.

Day 9, First rounds: There was a written test, and discussion with two recruiters following it. The exam tests on database design, SQL queries and basic algorithm skill.

I couldn't complete the test on time (we were given only 20 minutes). The interviewers discussed the exam content and helped solving the queries that I did not. They were looking for approach.

Day 16, I got a call for final rounds at office, NY

Day 22: There was a reception with "one employee per every intern candidate" and had very good opportunity to network with all. There were details given and ice-breaker events

Day 23: There were three rounds of interview(1, 2 and 1 interviewers in each round). All four of them were super cool and helpful. I was even provided manuals for a function I was supposed to use in solving a query. Again, they tested skills on design, knowledge of databases, and querying

Day 26: I got a call from HR that I got selected. Friday was interview and they updated selection on Monday. It was amazingly quick.

1. Design a scenario and normalize. (Realize anomalies and redundancies)

2. SQL queries (Aggregation, rank, etc.)

3. Database knowledge (Keys, indexes, all questions included a "when do you do it or not do it")