Amazon Development Centre India Business Analyst Interview Questions and Answers

Q1. SQL Questions on joins, union, window function
Add your answer
Q2. SQL question on joins
Add your answer

Q1. Sql Questions on joins, window functions
Add your answer

Business case studies

Q1. Explain advance sql functions used in your projects
Ans. 
I have used advanced SQL functions like window functions, CTEs, and stored procedures in my projects.
• Utilized window functions like ROW_NUMBER(), RANK(), and NTILE() for analytical queries

• Implemented Common Table Expressions (CTEs) for recursive queries and code readability

• Developed complex logic using stored procedures for data manipulation and business logic

• Used functions like LEAD(), LAG(), and OVER() for advanced d
Answered by AI
Add your answer

SQL questions, medium to hard

Evaluated on problems requiring intermediate to advanced SQL proficiency

Q1. Explain 2 or 3 projects in my resume in detail
Add your answer
Q2. Examples of stakeholder management, conflict management, program management
Ans. 
Stakeholder management involves identifying, analyzing, and engaging with stakeholders to ensure project success.
• Identify key stakeholders and their interests in the project

• Communicate regularly with stakeholders to keep them informed

• Address any concerns or conflicts that arise among stakeholders

• Engage stakeholders in decision-making processes to ensure buy-in

• Manage expectations and ensure stakeholders are satisfied wi
Answered by AI
Add your answer