Amazon Data Engineer interview questions

Recruiter called me to setup phone/video interview with technical manager. I gave them my availability and a call was scheduled for technical and behavioral questions. The first interview was was around 60 mins, which included Sql, Python and technical and business related questions.

Got to 2nd round, first round was take-home test very SQL based and very meticulous. Questions required a strong understanding of SQL and underlying processes regarding JOINS, analytic queries, processing order etc. Second round was technical call with Senior Engineer surrounding SQL, python (numpy, pandas etc.) and PySpark.