Sony India Software Center Business Analyst Interview Questions and Answers

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

Q1. Tell me about yourself
Add your answer

Q1. Brd frd use case user story
Ans. 
BRD, FRD, use case, and user story are all important documents and techniques used in business analysis.
• BRD (Business Requirements Document) is a formal document that describes the high-level business requirements for a project.

• FRD (Functional Requirements Document) is a detailed document that describes the functional requirements of a system or software.

• Use case is a technique used to capture and describe the interact...read more
Answered by AI
Add your answer

Q1. Future plans, career visison
Add your answer

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

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