Amazon Data Engineer interview questions

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)

The Interview experience was very good. They started with basic SQL questions, SQL queries and then advanced sql questions. Then they gave me One Medium level DSA question and I solved it. Then they asked ma questions about data warehousing, data modelling and other concepts.