Amazon Interview Experience| On-Campus Internship

Amazon has visited our campus for 11 months internship for the role Data Engineer. The interview process had 3 rounds.
Round 1: Online Test

Round 1 was an online test which consisted of about 65 mcq questions. Some questions had negative marking. Not all questions were of same marks, based on complexity the questions ranged from 1 mark to 4 marks. Questions were from topics like Java, DBMS, Linux, Big data and Aptitude. They were about 4-5 Aptitude questions which were easy to solve. Questions from Linux were mostly based on grep command. Most of Java questions were from threads, exceptions and inheritance. We were given code and we had to predict the output or find error in code. They were 5-6 Big data questions on topics like YARN. Most of SQL questions were based on joins.
Out of 300 students they have shortlisted 33 students for next round.

Round 2: Technical Interview

Round 2 was a one-to-one interview. The interviewer asked me to tell about myself and checked thoroughly my resume. He started asking me few python questions like exception handling as i mentioned python in my resume. He asked me to code operations on linked list like insertion, reverse. He also asked me about cloud computing and its advantages. He asked me about my projects and even asked me draw the database schema of my project.Then he started asking me questions in DBMS. They have concentrated mostly on DBMS topics and complex SQL queries.
He asked queries like second largest salary, top 5 salaries and some questions based on joins. He also asked me about primary key, foreign key. He also asked me some questions on Data Mining and Data warehousing.

Round 3: Technical + HR Interview

Round 3 was Technical and HR interview but the interviewer asked me mostly technical questions. First he asked me to tell me about myself and then asked about my goals and passion. He then asked me to code merge sort and Dijkstra’s Algorithm for shortest path.Then he asked me some complex SQL queries based on joins.

Some of the other questions which were asked to my friends were sorting an array consisting of 0s, 1s, 2s (they were expecting dutch national flag approach), window functions in SQL.

All The Best!!