I applied online. I interviewed at Amazon in Jan 2021
Interview
One online interview divided into two parts- 30 minutes each interview. Each 30 minute interview is held with a different Amazon employer.
First 30 minutes: 15 minutes background resume questions, 15 minutes Apache Kafka and Data Warehousing questions (coding)
Second 30 minutes: 15 minutes resume questions, 15 minutes SQL questions (coding)
Interview questions [1]
Question 1
Tell us about your past experiences
Showed a SQL query and asked to tell them the solution
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
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.
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.
