Two rounds, back to back, 45 minutes each.

After I applied, I received an email from the recruiter to schedule an interview. I had a 7-day buffer to schedule it.

They were very kind.

Amazon has a policy of giving out the results within 5 business days of the interview, and I received mine on the 5th day accordingly.

Data warehousing basics Python coding - intermediate level 2 SQL questions - GROUP BY, RANK() types Resume drill down Tell me about a time you helped a teammate Hardest data pipeline you have worked on Difference between STAR, SNOWFLAKE, and GALAXY schema SCD and types A recent ETL process you have worked on and challenges you faced in it