RSM US in India Senior Lead Business Analyst Interview Questions and Answers

First round was a 1 hr test compromising of logical and quant

Q1. I was examined for my communication skills
Add your answer

1 coding question
3 SQL queries
10 SQL mcq

Q1. 5 queries on joints and indexes
Add your answer
Q2. 1 logical scenario question
Add your answer
Q3. Fundamental CS questions
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

Hard level maths and reasoning

Q1. Guesstimate of total contribution of foreign traveller in Indian economy
Ans. 
Foreign travelers contribute significantly to the Indian economy through spending on accommodation, transportation, shopping, dining, and attractions.
• Foreign travelers contribute to the Indian economy through spending on accommodation, transportation, shopping, dining, and attractions.

• Tourism sector accounts for a significant portion of India's GDP and job creation.

• Foreign exchange earnings from tourism play a crucial ...read more
Answered by AI
Add your answer
Q2. Puzzle questions regarding no of doors open and some scenarios
Add your answer

Q1. Basics about yourself
Add your answer
Q2. Question around python sql joins etc
Add your answer
Q3. Scenario based questions
Add your answer

Q1. How many Netflix subsribers are there in India?
Ans. 
The exact number of Netflix subscribers in India is not publicly disclosed.
• Netflix does not publicly disclose the number of subscribers in specific countries.

• The total number of Netflix subscribers worldwide is over 200 million.

• India is one of the key markets for Netflix's expansion.
Answered by AI
Add your answer

Q1. How many Pepsi bottles are sold in Gurugram?
Ans. 
The exact number of Pepsi bottles sold in Gurugram is not publicly available.
• Sales data for specific products like Pepsi bottles is typically confidential

• The number of bottles sold can vary based on factors like seasonality, promotions, and consumer preferences

• One way to estimate sales is to look at market share data or industry reports
Answered by AI
Add your answer

Q1. Why do you want to Join Gartner?
Add your answer

It was good, detailed discussion

It ws good, detailed feedback session

Q1. BA skills - Your overall work experience
Ans. 
I have over 5 years of experience as a Business Analyst, with expertise in data analysis, requirements gathering, and process improvement.
• Strong analytical skills to interpret complex data and make strategic recommendations

• Experience in conducting stakeholder interviews to gather requirements

• Proficient in creating detailed documentation such as business requirements documents and process flows

• Skilled in identifying are...read more
Answered by AI
Add your answer
Q2. Case study discussions
Add your answer

Q1. Have you experienced failure at workplace?
Ans. 
Yes, I have experienced failure at the workplace.
• I made a mistake in a project deadline due to miscommunication with team members.

• I failed to meet a sales target due to lack of market research.

• I misinterpreted data which led to a wrong analysis in a report.
Answered by AI
Add your answer

Q1. Tell me about ba roles and responsibilities
Add your answer