I applied through college or university. I interviewed at Amazon (Seattle, WA) in Feb 2020
Interview
I was an university recruit and had two phone screens for the internship position. Both phone screens were one hour long - 30 mins each for SQL/Python and behavioral questions.
Interview questions [1]
Question 1
Write the SQL query to get the third maximum salary of an employee from a table named employees. Employee table employee_name salary Anna 24000 Amrit 34000 Paul 55000 John 75000 Kim 21000 Kyle 40000 H 50000
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
