I applied online. I interviewed at Amazon in Nov 2022
Interview
I had 2 back to back interviews of 45 mins. Both the interviewers were pretty chill. They do seem to look disinterested but actually they are just taking notes on what and how we answer their questions.
Interview questions [1]
Question 1
I was asked to design a database for a usecase. I was asked basic questions like joins and indexing. It was somewhat resume based too, so your previous experience matters.
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.
Top companies for "Compensation and Benefits" near you
