Infotech Business Analyst Interview Questions and Answers

Q1. Roles and responsibilities in previous organisations
Ans. 
In my previous roles, I have been responsible for analyzing business processes, gathering requirements, and creating solutions to improve efficiency.
• Analyzed current business processes to identify areas for improvement

• Gathered requirements from stakeholders to understand their needs

• Created solutions such as process improvements or new software implementations

• Collaborated with cross-functional teams to ensure successful
Answered by AI
Add your answer
Q2. Technologies you’ve worked on
Ans. 
I have experience working with a variety of technologies including SQL, Python, Tableau, and Jira.
• SQL

• Python

• Tableau

• Jira
Answered by AI
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. 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