Amazon Data Engineer interview questions

Recruiter reached via email and described the process. It was to the point nothing more and nothing less. It is very easy if you have at least 1 year of experience as true data engineer. The questions are to the point and looking for absolute answers to validate if your stories or true or not.

After a brief telephonic interview (simple SQL + 2 lps), I went to the onsite, which was 4 sessions of 60 minutes each. The first one was only LPs with a technical manager. The second one was with another DE, who asked me some LPs and then went to the technical part: providing a schema, I was asked to create a script from scratch for an ETL to provide certain data (I had to write a function for each step of the process). I wasn't expecting this question at all and did really bad here. The third one was with the HM who asked some LPs. The fourth one was with a sr.DE who asked me some LPs and a lot of technical stuff about databases. After that we went through some simple SQL and Python scripting but I didn't have enough time.