I applied online. I interviewed at Amazon in Jul 2022
Interview
They started with an SQL question which was easy. Then the next question required using the windows function. Query tuning questions followed this...
Then the interviewer started asking me about data modeling questions, which I did not expect. Because, my recruiter said it's gonna be a SQL and Python Data Structure interview. But, there were no Python DS questions...
Interview questions [1]
Question 1
SQL.
We have a table below :
Team
------
India
England
Srilanka
Can you write a SQL code, by which we can generate all possible combinations between the above input teams?
We have the below dataset :
Employee_salary
Sanpshotdate | Employee | Doj | Current Salary
--------------------------------------------------------
01-Jan-2022 | 1 | 01-Jan-2021 | 1000
01-Jan-2023 | 1 | 01-Jan-2021 | 2000
01-Jan-2024 | 1 | 01-Jan-2021 | 2300
01-Jan-2025 | 1 | 01-Jan-2021 | 3000
a) Print for each employee what was current and immediate previous salary
b) Identify the employees based on the highest increase of salary from the first salary, who have joined more than 2 years ago
c) Identify the employees where salary increase between the last two years are more compared to the average salary increase in the last two years
I applied online. I interviewed at Amazon (Sydney) in Jul 2026
Interview
Applied online and got a link to SQL assessment and finished Phone screen round of 1 hour. Now requested to schedule a call with HR and also waiting to get to know next steps of the process.
Interview questions [1]
Question 1
SQL question, About my previous experience, little bit of data modelling and 1 behavior question
I applied online. I interviewed at Amazon in Jun 2026
Interview
Applied online. Got an OA. OA was not that difficulty, on the easier side to be honest. Got an email asking for interview availability.
Interview in a week. Will update soon.
Very difficult process it took me a round 1 month to get back what’s the review for the interview so I think overall it’s bad experience and difficult interview process while it has lot of questions I wa able to answer