Mphasis Assistant Manager Business Analyst Interview Questions and Answers

Q1. SQL queries different joins
Ans. 
SQL queries different joins
• There are different types of joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FULL JOIN returns rows when there is a match in one of t
Answered by AI
Add your answer
Q2. Insurance, P&C, stakeholder management
Add your answer

Good and got time to keep my point

Q1. What is your weakness
Add your answer
Q2. How well you know python
Ans. 
I have a strong understanding of Python and have used it extensively in my previous projects.
• Proficient in Python programming language

• Experience in using Python for data analysis and visualization

• Familiar with popular Python libraries such as Pandas, NumPy, and Matplotlib

• Have developed scripts and automation tools using Python
Answered by AI
Add your answer

Q1. Use cases - Precondition and postcondition
Add your answer
Q2. Jira tool and explain
Ans. 
Jira is a project management tool used for tracking and managing tasks, issues, and workflows.
• Jira is commonly used in software development teams to track bugs, tasks, and user stories.

• It allows for creating and assigning tasks, setting priorities, and tracking progress.

• Jira integrates with other tools like Confluence and Bitbucket for seamless project management.

• Users can create custom workflows, dashboards, and repor
Answered by AI
Add your answer

Q1. What is a user story and what all components make the user story complete.
Ans. 
A user story is a concise description of a feature told from the perspective of the end user.
• A user story typically follows the format: As a [type of user], I want [some goal] so that [some reason].

• User stories help capture the 'who', 'what', and 'why' of a feature in a simple and understandable way.

• Components of a user story include a title, narrative, acceptance criteria, and priority.

• Example: As a customer, I want t...read more
Answered by AI
Add your answer
Q2. Explain the difficult situation that you faced with stakeholders
Add your answer

Q1. As a business analyst how is your day-in and day-out responsibilities
Add your answer
Q2. How do validate ServiceNOw application ?
Ans. 
ServiceNow application can be validated through testing, documentation review, and user feedback.
• Perform functional testing to ensure all features work as expected

• Review documentation to confirm alignment with requirements

• Collect user feedback to identify any issues or improvements needed
Answered by AI
Add your answer

Q1. Not applicable. waiting for interview
Add your answer
Q2. Not applicable waiting for interview
Add your answer

Q1. Tell more about your project
Add your answer

Q1. Tell me about yourself.
Ans. 
Experienced business analyst with a background in data analysis and process improvement.
• Over 5 years of experience in analyzing business processes and identifying areas for improvement

• Skilled in data analysis tools such as Excel, SQL, and Tableau

• Strong communication and problem-solving skills

• Certified in Business Analysis Professional (CBAP)

• Previously worked on a project to streamline inventory management processes, re
Answered by AI
Add your answer
Q2. What are your BAU tasks as a Business Analyst
Ans. 
BAU tasks of a Business Analyst include gathering requirements, analyzing data, creating reports, and facilitating communication between stakeholders.
• Gathering and documenting business requirements from stakeholders

• Analyzing data to identify trends and insights

• Creating reports and presentations to communicate findings

• Facilitating communication between different teams and stakeholders

• Participating in meetings to discuss
Answered by AI
Add your answer
Q3. What is API in Business Analysis?
Ans. 
API in Business Analysis refers to Application Programming Interface, which allows different software systems to communicate with each other.
• APIs define the methods for accessing and interacting with software applications

• They enable data sharing and functionality between different systems

• APIs are commonly used in business analysis to integrate various software tools and systems

• Examples include using APIs to connect a C
Answered by AI
Add your answer
Q4. How much do you rate yourself in SQL knowledge?
Ans. 
I rate myself as proficient in SQL knowledge.
• I have extensive experience writing complex SQL queries for data analysis and reporting.

• I am comfortable working with joins, subqueries, and aggregations.

• I have optimized database performance by creating indexes and tuning queries.

• I have experience with stored procedures, triggers, and functions.

• I am familiar with database management systems like MySQL, SQL Server, and Oracl
Answered by AI
Add your answer
Q5. What are use cases?
Ans. 
Use cases are descriptions of how a system will be used by end users to achieve specific goals.
• Use cases describe interactions between users and a system

• They outline specific goals or tasks that users want to accomplish

• Use cases help in understanding system requirements and functionality

• Examples include 'User login', 'Place order', 'Generate report'
Answered by AI
Add your answer
Q6. How do you write User Stories?
Ans. 
User stories are written in a specific format to capture requirements from the perspective of an end user.
• Start with 'As a , I want so that '

• Keep user stories small, focused, and independent

• Include acceptance criteria to define when a user story is complete
Answered by AI
Add your answer
Q7. What are the Acceptance Criteria?
Ans. 
Acceptance criteria are conditions that a product must meet to be accepted by stakeholders.
• Acceptance criteria are defined during the requirements gathering phase.

• They are used to determine if a product or feature is working as expected.

• Acceptance criteria are usually written in a specific format such as 'Given-When-Then'.

• Example: 'Given a user is logged in, when they click on the submit button, then the form should be
Answered by AI
Add your answer