State Street Corporation Lead Business Analyst Interview Questions and Answers

Q1. Could you provide details about your experience?
Add your answer

Q1. 1) Difference between Inner join and outer join. Explain it to a non technical person
Ans. 
Inner join combines only matching rows from two tables, while outer join includes all rows from one table and only matching rows from the other.
• Inner join only includes rows that have matching values in both tables

• Outer join includes all rows from one table and only matching rows from the other

• Example: Inner join would return only customers who have made a purchase, while outer join would return all customers with thei
Answered by AI
Add your answer

Q1. What are the effective strategies for selling insurance?
Add your answer
Q2. What is your approach to recruiting a team?
Add your answer

Q1. Why should I hire you?
Add your answer
Q2. What is the volume of business you have conducted in the past six months?
Add your answer

Q1. SQL joins and cte
Add your answer
Q2. Jira software operation
Ans. 
Jira software is a project management tool used for tracking issues and managing tasks.
• Jira allows users to create and track issues, assign tasks, and prioritize work.

• Users can customize workflows, create dashboards, and generate reports.

• Integration with other tools like Confluence and Bitbucket is possible.

• Example: Creating a new issue, assigning it to a team member, and tracking its progress.
Answered by AI
Add your answer

Q1. How many years exp
Add your answer
Q2. What domain have you worked? Did you work in finance project?
Add your answer

Q1. Normal work did in past
Ans. 
Performed data analysis, requirement gathering, process improvement, and documentation in past roles.
• Conducted data analysis to identify trends and insights

• Gathered requirements from stakeholders to understand business needs

• Improved processes by identifying inefficiencies and proposing solutions

• Documented findings, requirements, and processes for reference
Answered by AI
Add your answer
Q2. And what are my aspirations
Add your answer

Q1. Basic BA question
Add your answer
Q2. Situation based analytical questions
Add your answer

Project management case study for process transition

Q1. Case Study on increasing attrition rate
Add your answer
Q2. How did you create value for your client
Add your answer