I applied online. The process took 4 weeks.

Took like 4 weeks total. OA first, then a quick phone screen for basic SQL. Onsite was 5 rounds: data modeling, ETL architecture, coding/SQL, and the bar raiser.

• IMO data modeling is the real filter here, you have to design a schema from scratch (expect a lot of follow up ques).
• ETL round is mostly just knowing which AWS services to plug together for data pipelines.
• Coding is pretty standard Python.

Also another imp thing is the leadership principles. They ask LPs in literally every single round so you need to have like 5/6 STAR method stories ready to go.

For prep, just skim the Kimball data warehouse book for the modeling stuff. I also did a mock on Prepfully with an Amazon DE just to test my LP stories, which helped a lot.

Design a data model for Amazon Prime.