Guidehouse Senior Lead Analyst Interview Questions and Answers

Q1. How do you assess if a user story is complete or not. Have you heard about INVEST.
Ans. 
Assessing completeness of user stories using INVEST criteria.
• INVEST stands for Independent, Negotiable, Valuable, Estimable, Small, and Testable.

• A user story is complete if it meets all the criteria of INVEST.

• Independence: User story should be self-contained and not dependent on other stories.

• Negotiable: Details of the story can be negotiated between the team and stakeholders.

• Valuable: Story should deliver value to the...read more
Answered by AI
Add your answer
Q2. Are you aware of RACI matrix.
Ans. 
Yes, RACI matrix is a tool used to clarify roles and responsibilities in a project or process.
• RACI stands for Responsible, Accountable, Consulted, and Informed.

• It helps in defining who is responsible for what tasks, who is accountable for the overall success, who needs to be consulted before decisions are made, and who needs to be kept informed.

• For example, in a software development project, the Business Analyst might ...read more
Answered by AI
Add your answer
Q3. If there are multiple stakeholders and one of the stakeholder is old school and against the new requirement, how do you handle such stakeholder.
Ans. 
Address the concerns of the old school stakeholder by understanding their perspective, communicating effectively, and finding common ground.
• Listen to the stakeholder's concerns and try to understand their perspective.

• Communicate the benefits of the new requirement in a way that resonates with the stakeholder's values and priorities.

• Find common ground by highlighting areas where the new requirement aligns with the stake...read more
Answered by AI
Add your answer

Q1. What is the difference between requirement gathering and requirement elicitation.
Ans. 
Requirement gathering is the process of collecting and documenting requirements from stakeholders, while requirement elicitation is the process of discovering and extracting requirements from stakeholders.
• Requirement gathering involves documenting known requirements, while requirement elicitation involves uncovering hidden or unspoken requirements.

• Requirement gathering typically involves interviews, surveys, and docume...read more
Answered by AI
Add your answer
Q2. What are the 3Cs of a user story.
Ans. 
The 3Cs of a user story are Card, Conversation, and Confirmation.
• Card: A user story is typically written on a physical or digital card to capture the essence of the requirement.

• Conversation: The user story should spark a conversation between the stakeholders to gather more details and clarify any doubts.

• Confirmation: The user story should have acceptance criteria that define when the story is considered complete.
Answered by AI
Add your answer
Q3. Traceability matrix
Add your answer

Q1. What is Derivatives
Add your answer
Q2. What is financial Markets
Add your answer
Q3. V Lookup, X Lookup, H lookup
Add your answer
Q4. Experience in SQL And Power bi
Add your answer
Q5. Internship Experience
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why you want to join kpmg?
Add your answer
Q3. What you understand about the job?
Add your answer
Q4. What is your work experience?
Add your answer
Q5. How will you see yourself within 5 years?
Add your answer

Set of questions on english , aptitude , all are at easy level

Sql basics and some query questions

Q1. Why do u want to join zs ; what do u know about zs; where do u see urself after 5 years ; question on real life scenarios ;
Add your answer
Q2. Question on real life scenarios
Add your answer

Q1. Salary expectation
Add your answer
Q2. When can u join
Add your answer

The aptitude test was interesting, Had a bunch of fun puzzles

Q1. Tell me about yourself
Ans. 
I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.
• Experienced in gathering and analyzing business requirements

• Skilled in creating data models and visualizations

• Proficient in using tools like SQL, Excel, and Tableau

• Strong communication and presentation skills

• Certified in business analysis (e.g. CBAP)
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years
Add your answer

Q1. How to measure risk & returns
Add your answer
Q2. Investment due diligence and performance calculation
Add your answer
Q3. Why we should hire you
Add your answer
Q4. Why you want to switch job
Add your answer
Q5. Fixed income valuation methods
Add your answer

Q1. Explain all types of joins
Ans. 
Different types of joins in SQL are inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a 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 outer join: Returns rows when there is a match in either table
Answered by AI
Add your answer
Q2. Difference between having and where
Ans. 
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.
• HAVING is used with GROUP BY to filter groups based on aggregate functions results

• WHERE is used to filter rows based on conditions

• HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROU...read more
Answered by AI
Add your answer

It was a 1 hour test. It consists of two sections (i) 8 ques were of Business case studies (ii) 12 ques were of quantitative aptitude.

Q1. What is the difference between where and having clause ?
Ans. 
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition.

• Having clause is used with GROUP BY statement to filter groups based on a condition.

• Where clause is applied before grouping, while having clause is applied after grouping.

• Example: SELECT * FROM table_name WHERE co...read more
Answered by AI
Add your answer
Q2. One ques was a guesstimate problem.
Add your answer

Q1. Self Introduction.
Add your answer
Q2. Business case problem which was to be solved in 15 minutes.
Add your answer