AMAZON | Data Engineer 2 | L5 | INDIA | Offer
Anonymous User
1064

Positon : Data Engineer 2, L5

Applied via Referral.

Amazon

I can't share the exact question, hence sharing abstract of it.

Phone Screening :

Started interview with discussion about project.
Design Data Modeling question, based on design it was asked to write some queries. 
Make sure to clarify requirement and do think about edge cases.
You should be able to write SQL based on your desing.

R1:

Design Question : Data Modelling same as phone screening + DSA (easy)

R2 :

Project + SQL (Medium)

R3 :

Project + LP + Script (Something like log file is there create report from that based on certain condition. I used python pandas to solve it.)

R4 :

LP + Project + Database Questions(Indexing, Performance tuning, resource management, efficient join, debugging query)

R5 :

Bar Raiser Round : LP (Make sure you are ready with followup questions).

Got Offer:
YOE : 5 years
Base : 36 LPA
Bonus : 12 + 10
Stocks : 400

Comments (6)