I only took the online assessment The testing was very friendly and easy-going The process was good I did not do well in it but good experience in viewing the questions
Interview questions [1]
Question 1
I remembered this question was given: https://leetcode.com/discuss/interview-question/1903168/Amazon-or-OA-or-validating-strings-with-regex
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.