2 back-to-back interviews, 1 hour each.
LP questions for half of the interview. The rest of the time is technical fundamentals like DWH, OLAP, OLTP, Star/Snowflake, etc.
SQL question using CTE and DENSE_RANK.
Interviewer-specific, but questions are usually general DE fundamentals. No need to get super specific about tools like Apache or AWS unless you or they decide to bring it up.
The following metrics were computed from 52 interview experiences for the Amazon Data Engineer Intern role.
Amazon's interview process for their Data Engineer Intern roles is fairly selective, failing a large portion of engineers who go through it.
Candidates reported having very good feelings for Amazon's Data Engineer Intern interview process.