Started with a phone screen by recruiter and he set me up for a technical screening with a Data Engineer at Amazon, jumped directly to tech questions after a short introduction and a behavioral question (which I wasn't expecting). I was tested on few easy - medium SQL queries, spark and dimensional modelling. Did ok, with the technical screening and then was later invited for onsite in couple of weeks. Onsite interview was exhausting, had 5 interviews back to back, mostly behavioral and ETL, Dimensional design questions on 4 interviews, last interview was mostly advanced sql with window functions, partitions, indexes and SCD's.