Upload Button Icon Add office photos

Filter interviews by

Groww Business Analyst Interview Questions and Answers

Updated 14 Oct 2024

Groww Business Analyst Interview Experiences

5 interviews found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Questions based on the understanding of joins in sql
  • Q2. Convert row to columns using sql
  • Ans. 

    Use SQL pivot function to convert rows to columns

    • Use the PIVOT function in SQL to convert rows into columns

    • Specify the columns you want to pivot on and the values you want to display in the new columns

    • Example: SELECT * FROM table_name PIVOT (MAX(value_column) FOR pivot_column IN (column1, column2, column3)) AS alias_name

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Result of different sql joins
  • Ans. 

    SQL joins combine data from two or more tables based on a related column between them.

    • Inner join returns rows that have matching values 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 all rows when there is a match in either left or right table

  • Answered by AI

Skills evaluated in this interview

Business Analyst Interview Questions Asked at Other Companies

asked in Evalueserve
Q1. You have 10 boxes of balls (each ball weighing exactly10 gm) with ... read more
asked in Infosys
Q2. What is your strong point in terms of technical knowledge? Like J ... read more
Q3. There are 100 people standing in a circle, the first person has a ... read more
asked in Paytm
Q4. Sum of Squares of First N Natural Numbers Problem Statement You a ... read more
asked in EXL Service
Q5. If I have 333 digits to number pages of a book, How many pages ca ... read more
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Joins, case when
  • Ans. 

    Joins are used to combine rows from two or more tables based on a related column between them. Case when is a conditional statement used to perform different actions based on different conditions.

    • Joins are used to retrieve data from multiple tables based on a related column

    • Case when is used to perform different actions based on different conditions in SQL queries

    • Example: SELECT * FROM table1 JOIN table2 ON table1.id = ...

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Joins, SQL query execution
  • Q2. Simple Sals Question - SQL

Groww interview questions for designations

 Senior Business Analyst

 (1)

 Business Associate

 (1)

 Data Analyst

 (2)

 Senior Lead Analyst

 (1)

 Associate Data Analyst

 (1)

 Customer Support Executive

 (3)

 Customer Care Executive

 (2)

 Operations Executive

 (1)

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Aptitude Test 

Aptitude tests + 3 Rounds

Interview Preparation Tips

Interview preparation tips for other job seekers - There Were three rounds over the aptitude round.
1. The First Round was a basic guesstimate round.
2. The Second Round was a feature Discussion round about the Netflix search bar.
3. The final round was a mix of a Case Breakdown + HR + Questions about Groww.

Interview questions from similar companies

I applied via Other and was interviewed before Dec 2020. There were 6 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Mainly technical ques, use case scenarios and a couple of assignments to complete..

Interview Preparation Tips

Interview preparation tips for other job seekers - Read the JD, prepare for it, think of the real life scenarios if you have worked with something that is mentioned in JD.
HR interview might be a tricky one.... So be general.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Write me a query to get the last month's data and it only runs 1st of everymonth
  • Ans. 

    Query to retrieve last month's data on the 1st of every month

    • Use the DATEADD function to subtract a month from the current date

    • Filter the results to only include data from the 1st of the month

    • Example: SELECT * FROM table_name WHERE date_column = DATEADD(month, -1, DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0))

  • Answered by AI

Skills evaluated in this interview

I applied via Referral and was interviewed in Nov 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good.. You will get a good knowing of work they will provide.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. About yourself and your experience
Round 2 - Technical 

(1 Question)

  • Q1. Financial data for baking companies and other industries
  • Ans. 

    Financial data for baking companies and other industries

    • Financial statements like income statement, balance sheet, and cash flow statement are key for analyzing baking companies and other industries

    • Key financial ratios like profitability ratios, liquidity ratios, and solvency ratios can provide insights into the financial health of these companies

    • Comparing financial data of baking companies with industry benchmarks can...

  • Answered by AI

I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Everything related to Capital markets and Securities. and Since It was for Business analyst role so it went around Scrum and agile methodologies

Interview Preparation Tips

Interview preparation tips for other job seekers - A candidate should be well experienced in Agile or Scrum methodologies of business. And should have atleast awareness of Capital market and Securities financial terms.

Groww Interview FAQs

How many rounds are there in Groww Business Analyst interview?
Groww interview process usually has 1 rounds. The most common rounds in the Groww interview process are Technical and Aptitude Test.
How to prepare for Groww Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Groww. The most common topics and skills that interviewers at Groww expect are Business Analysis, Data Analysis, Product Management, Analytics and Data Visualization.
What are the top questions asked in Groww Business Analyst interview?

Some of the top questions asked at the Groww Business Analyst interview -

  1. convert row to columns using ...read more
  2. joins, case w...read more
  3. result of different sql jo...read more

Tell us how to improve this page.

Groww Business Analyst Interview Process

based on 5 interviews

1 Interview rounds

  • Technical Round
View more
Groww Business Analyst Salary
based on 32 salaries
₹8 L/yr - ₹25 L/yr
69% more than the average Business Analyst Salary in India
View more details

Groww Business Analyst Reviews and Ratings

based on 5 reviews

3.3/5

Rating in categories

3.3

Skill development

3.7

Work-life balance

3.0

Salary

3.9

Job security

4.2

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 5 Reviews and Ratings
Senior Executive
81 salaries
unlock blur

₹3.1 L/yr - ₹5 L/yr

Customer Support Executive
45 salaries
unlock blur

₹2.4 L/yr - ₹4.3 L/yr

Assistant Manager
42 salaries
unlock blur

₹5.8 L/yr - ₹14.8 L/yr

Software Engineer
41 salaries
unlock blur

₹14 L/yr - ₹37 L/yr

Customer Success Executive
41 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Explore more salaries
Compare Groww with

Zerodha

4.2
Compare

Sharekhan

3.8
Compare

SBI Cards & Payment Services

3.7
Compare

Axis Direct

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview