I applied online. I interviewed at Amazon (Bellevue, WA) in Oct 2024
Interview
Online Assessment with 15 MCQ mysql general knowledge questions, then two SQL leetcode style questions in a hackerrank assessment. Topics included joins, window functions, string manipulation and regex.
Two hour long back to back interviews with two different engineers. Both included some leadership principle questions, example formats of "Explain a time you were in X scenario and did Y", or "How would handle X situation on a team". One technical coding question per interviewer SQL/Python leetcode.
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.
