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
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.
In my 5th semester, Amazon visited our campus to hire interns for multiple roles, and I was shortlisted for the Data Engineer role.
I cleared the online assessment and attended two technical interviews. The first round focused on coding, while the second round focused on SQL. I faced some challenges in the SQL round, and although I was not selected, the experience helped me identify areas for improvement, especially in advanced SQL concepts