NTT DATA, Inc. Business Analyst Interview Questions and Answers

Q1. How many joins are in SQL?
Ans. 
The number of joins in SQL can vary depending on the complexity of the query.
• The number of joins in SQL can range from 0 (no joins) to multiple joins in a single query.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Joins are used to combine rows from two or more tables based on a related column between them.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
Answered by AI
Add your answer
Q2. Explain about difference left and inner join? And scenarios questions
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. Tell more about your project
Add your answer

They start with sequel then slide you move to python

Start with aptitude test and asking to detail regarding the study case

Basic questions related to aptitude

Case study for documentation

Q1. Questions related to project
Add your answer
Q2. What is your current role?
Add your answer
Q3. How to write user story
Ans. 
User stories are concise descriptions of a feature told from the perspective of the end user.
• Start with 'As a [type of user], I want [some goal] so that [some reason]'

• Focus on the user's needs and goals

• Keep it simple and specific

• Include acceptance criteria for clear understanding
Answered by AI
Add your answer
Q4. Scenarios based questions
Add your answer

Q1. Introduce yourself
Add your answer
Q2. Carrier background and work experience
Add your answer

Q1. About Business Analyst
Add your answer
Q2. Explain in breif and adding real experience stories how to solve problems.
Ans. 
Problem-solving involves identifying, analyzing, and resolving issues to achieve desired outcomes.
• Define the problem and gather information

• Brainstorm potential solutions

• Evaluate and select the best solution

• Implement the solution and monitor its effectiveness

• Adjust the solution as needed

• Real experience story: During a project, we faced a challenge with a vendor who was not meeting our expectations. We defined the proble...read more
Answered by AI
Add your answer

Q1. About personality and experience
Add your answer
Q2. Depth knowledge about BA
Add your answer

Q1. About salary discussion
Add your answer
Q2. Basic details with notice period negotiation.
Add your answer

Algorithms, blood relations and basic math and aptitude question

Q1. Explain more details on previous project
Add your answer

Q1. Asked about previous experience related to the BA, tools which i know or used, asked about Jira experience and difference between epic and userstory
Add your answer

Q1. Almost like round 1 about previous experiences, given some real time challenging questions
Add your answer

Q1. Package discussion
Add your answer