Hi Everyone!
While preparing for my data engineering intern interview at Amazon, I found very little information about the rounds and what questions are asked. So I decided to write about my own experience! Hope this helps.

Role - Data Engineering Intern 6 months (Jan - May)
Background - Tier 2 CSE
Previous Internhip - Summer Internship at an MNC
Offcampus

Number of Rounds - 3

1. Online Assesment - Technical Assesment for 1hr 30 mins, this included questions based on DS, OS, DBMS and CN.

2. Round 1 Interview - 1hour

   • The interview started with very simple questions to be implemented in python(they did not mention the language explicitly but I guess they expect python knowledge). The questions asked were balanced paranthesis and top k frequent elements both I solved quickly.

   • Next he went on to discuss about my project for 5-10 mins and he was interested by it so asked some more questions regarding the use case.

   • He then asked some questions about python decorators, lambda functions and list comprehension.

   • Next I was asked some SQL conceptual questions such as difference between Row(), Rank(), and DenseRank(). After this he asked 2 simple sql query questions. These questions were top 3 salaries in each department and to find all pairs of employees in a database with equal salaries.

   The interview ended in 40 mins with some more discussion on project and experience.

3. Round 2 Interview - 1 hour 10 mins

   • After regular introduction the interviewer started with SQL conceptual questions like why the language is called Structured Query Language and what is the structure of a SQL query with name of all the clauses. He asked me all the databases that I have worked with and if I had noticed any difference in them.

   • I was asked 3 sql queries initially, where I had to print the id of all the days which had greater temperature than the previous day. Next he moved on to department's maximum salary. After this he asked about the last person to get on a lift with maximum capacity of 1000kg. In most of the SQL queries, understanding of window functions was crucial.

   • After asking the sql questions he moved on to asking about Database warehousing concepts such as tables, dimension table, star and snowflake schemas, ETL pipelines and other similar questions.

   • He then asked me to model the database of a food ordering service and list down all the tables that would be required to get information about offers applied on orders, he gave some more queries to be executed on this table which I executed and the interview ended with a final project discussion.

Both of my interviewers were really helpful and nice so the rounds went very smoothly.
Verdict - Not Yet revealed but expecting it to be good.