Amazon Data Engineer I interview questions

For the phone interview, I had two medium-level SQL questions and one easy-to-medium leetcode-style Python question. They used a whiteboard instead of hack rank, so I didn't have a chance to test the code. Later there were one or two questions regarding the database system design, and some follow-ups of how to optimize it.

The interview process was good, well structured and absolutely within the time frame. The interviewer asked me about : scd type 2 and have I ever implmented it, data modelling concepts: How would I design a streaming data model as well as a batch data model? Warehousing concepts: basic warehouse concepts and my personal experience with one 2 SQL questions (1. Employee time in and time out and 2. top 10 sellers ) 1 python question (anagram)