I applied online. I interviewed at Amazon (Seattle, WA) in Oct 2021
Interview
Two rounds back to back 45 mins each. After I applied I got 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 it on the 5th day accordingly.
Interview questions [1]
Question 1
1) Data warehousing basics
2) Python coding - intermediate level
3) 2 SQL questions - group by, RANK() types
4) Resume drill down
5) Tell me about a time you helped a teammate?
6) Hardest data pipeline you have worked on?
7) Difference between STAR, SNOWFLAKE and GALAXY schema
8) SCD and types
9) A recent ETL process you have worked on and challenges you faced in it
First round was OA with SQL questions, mcqs and 1 DSA then 2 Technical interviews SQL questions like joins, group by, NULL values, SQL theory, easy to medium leetcode, questions on resume
Interview questions [1]
Question 1
Asked me to differentiate between all 3 types of joins
The process started with an online assessment (OA) that included SQL and data-related questions. The technical interview focused on core data engineering concepts such as normalization, joins, and a self-join problem, along with some discussion on data modeling and query optimization.
Application
I applied through a recruiter. I interviewed at Amazon (Tel Aviv)
Interview
After submitting my resume, I received a home assignment with one week to complete it. Later, I attended two interviews that included personal and professional questions about my experience, previous projects, problem-solving skills, and relevant technical knowledge.
