I applied through university. I interviewed at Amazon (Bengaluru) in Mar 2025
Interview
Conducted virtually (Amazon Chime) or on-campus.
Focused on SQL, Python, and Data Engineering fundamentals.
SQL: Joins, subqueries, window functions, case statements, schema design.
Python: Data structures, pandas/numpy basics, ETL scripting.
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.