Guidehouse Analyst Interview Questions and Answers

Leetcode easy medium

Q1. About frameworks and core java
Add your answer
Q2. Technical ques related to JD
Add your answer

Q1. Coding round on java
Add your answer

Q1. Background & Screening round
Add your answer

Q1. Technical questions related to JD & past experience
Add your answer

Q1. Mostly from JD & discussion of the operations part for the role
Add your answer

In the aptitude round there were various sections such as quants, verbal and technical questions based on networking and cloud platforms and some pseudo codes . No coding questions were asked .

It was structured group discussion with one panel member and a case study was provided to us .

Q1. Tell me about yourself .
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics and have completed multiple data analysis projects during my studies.

• I am proficient in using statistical software such as R and Python to analyze data and generate insights.

• I have experience working with cross-functional teams to develop and implement data-driven strategie...read more
Answered by AI
Add your answer
Q2. Tell me about the projects that you have made .
Ans. 
I have worked on various projects including financial analysis, market research, and data visualization.
• Developed financial models to analyze company performance

• Conducted market research to identify growth opportunities

• Created interactive dashboards for data visualization

• Collaborated with cross-functional teams to implement project recommendations
Answered by AI
Add your answer
Q3. Puzzles questions
Add your answer
Q4. Coding question
Add your answer
Q5. Machine learning question
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

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

Normaa CAT level apti questions

Q1. It was all about how we can read a sentence
Add your answer

A normal case study of food delivery giant was given

Q1. What are your hobby
Add your answer
Q2. If you have given 10 crores in hand which food business will you start?
Add your answer