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 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
Standard three-round process consisting of an online assessment followed by a comprehensive interview loop, where candidates were evaluated across technical skills, problem solving ability, and overall fit for the role.
1
Top companies for "Compensation and Benefits" near you
