Status: 9+ yrs Experience, Currently working as Sr. Data Engineer for Major Video Streaming Platform.
Position: Senior Data Engineer (L6) at Amazon
Location: Remote, USA
Date: January, 2022

There was total 7 rounds of interview.

Phone Interview : (2 Technical )
1. Technical phone screen (1 hour):
- 1 Amazon LP(Leadership Principle) questions
- 1 SQL, 1 Easy Algo, lots questions from ETL , Cloud, DB query fine tuning
2. Technical phone screen (1 hours):
- 1 Data Modelling Quetion, 1 SQl, Lots question on ETL, Big Data

Onsite (5 rounds):

Onsite has total 5 rounds of interview ( 3 Technical + 2 LP):

1. First Technical : 1 Leadership Principle + Data Engineering (Designing ETL Workflows, Understanding on DB Concepts/Architecture, Handling Big Data Volumes)
2. Second Technical : 1 Data Modeling (DM), De/normalization, Usability of DM) + 1 follow up hard SQL from your data model design + 2 Easy Coding (Python) + 1 Leadership Principle
3. Third Technical : Lots of Big Data Performance related question + 2 Hard SQL question
4. Fourth : 3 LP
5. Fifth : 4 LP ( For all LP, You need very real time experience to deal with those questions, as they cross validate your answer on very granular level)

Result: Offer for L5

Overally, Amazon recruiter are really amazing, please follow the information and instructions closely and prepare accordingly. the pattern and the area they will tell you to prepare are the question that going to come on your respective interview. Basically they are setting a syllabus for you.