Amazon Interview Questions, Process, and Tips

Find the order of excecution in sql

Online assessment was given through Gmail. It had 4 sections

Q1. Why do you want to join the company
Ans. 
I am impressed by the company's innovative approach and strong reputation in the industry.
• Company's reputation for innovation

• Strong industry presence

• Opportunity for growth and development
Answered by AI
Add your answer
Q2. Tell me about your self
Ans. 
I am a dedicated and detail-oriented individual with a strong background in project management and team leadership.
• Experienced in leading cross-functional teams to successfully complete projects

• Skilled in developing and implementing project plans

• Strong communication and interpersonal skills

• Proven track record of meeting deadlines and exceeding goals
Answered by AI
Add your answer

It was a one hour DS Algo Round based on recursion and DP. I managed to get to the logic for the problem but couldn't execute compltely due to time constraints

60 questions 60 minutes

2 coding questions one is easy

Q1. Basic question of python and opps
Add your answer
Q2. Coding questions and logic
Add your answer

Q1. Introduction, about project what is your role
Add your answer
Q2. About company and personal details
Add your answer

Q1. Complex SQL query - using Window Function, Date and Time
Ans. 
Using Window Function, Date and Time in a complex SQL query
• Use ROW_NUMBER() to assign a unique number to each row within a partition

• Use PARTITION BY to divide the result set into partitions

• Use ORDER BY to specify the order of rows within each partition

• Utilize functions like LAG(), LEAD(), SUM(), AVG(), etc. within the window frame
Answered by AI
Add your answer
Q2. Work related projects to be explained using STAR methodology, based on the problem statement.
Add your answer