AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
Groww Business Analyst Interview Questions and Answers
Groww Business Analyst Interview Experiences
5 interviews found
Anonymous
(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
Skills evaluated in this interview
(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
Skills evaluated in this interview
(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 = ...
Skills evaluated in this interview
I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. Joins, SQL query execution
- Q2. Simple Sals Question - SQL
Groww interview questions for designations
Selected
I applied via Campus Placement and was interviewed before Apr 2023. There was 1 interview round.
Aptitude tests + 3 Rounds
Interview Preparation Tips
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.
Top trending discussions
Interview questions from similar companies
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
(1 Question)
- Q1. Questions on probability and puzzles
Interview Preparation Tips
(1 Question)
- Q1. Current CTC, Preferred location
- Ans.
Current CTC and preferred location are confidential information.
Current CTC and preferred location are personal and confidential details.
It is common practice not to disclose current CTC during interviews.
Preferred location may vary based on individual circumstances and preferences.
(1 Question)
- Q1. About yourself, projects worked, sql questions, Python questions
I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.
I had a very bad interview experience. The interviewer didn't start with any introduction and immediately jumped into asking case study. After giving a case, he would leave for a few minutes, which made it seem like he was not interested in the process.
Questions asked:
Q1: You are an Analyst at UBER. The gross cab cancellation rate daily is 5% whereas on a particular day, it goes up to 10%. What could be the factors affecting the same?
To analyze the same list down the tables required in the database along with all the columns and write the query using the same table name & columns to find the required metrics.
Q2: Assume you work for YouTube Music and the CEO wants you to create a Business Health Dashboard. List down all the metrics the CEO will be interested in looking at.
(2 Questions)
- Q1. What is agile methology?
- Ans.
Agile methodology is a project management approach that emphasizes flexibility, collaboration, and incremental progress.
Focus on delivering working software in short iterations
Embrace changing requirements
Encourage frequent collaboration between team members
Use feedback to continuously improve the product
Common frameworks include Scrum and Kanban
- Q2. Write a user story and edge cases
- Ans.
User story for a shopping website
As a user, I want to be able to add items to my cart
As a user, I want to be able to view my cart and update quantities
As a user, I want to be able to proceed to checkout and make a payment
Skills evaluated in this interview
Groww Interview FAQs
Recently Viewed
SALARIES
ZeroCodeHR
INTERVIEWS
Groww
No Interviews
INTERVIEWS
MTX Group
No Interviews
INTERVIEWS
ZeroCodeHR
No Interviews
INTERVIEWS
Hiver
No Interviews
SALARIES
Groww
SALARIES
Groww
INTERVIEWS
Groww
No Interviews
INTERVIEWS
Groww
40 top interview questions
LIST OF COMPANIES
ADF Data Science
Overview
Tell us how to improve this page.
Groww Interviews By Designations
- Groww Business Analyst Interview Questions
- Groww Senior Software Engineer Interview Questions
- Groww Software Developer Intern Interview Questions
- Groww Customer Support Executive Interview Questions
- Groww Customer Care Executive Interview Questions
- Groww Data Analyst Interview Questions
- Groww Software Developer Interview Questions
- Groww Senior Android Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
Groww Business Analyst Interview Process
based on 5 interviews
1 Interview rounds
- Technical Round
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Groww Business Analyst Reviews and Ratings
based on 5 reviews
Rating in categories
|
Senior Executive
81
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Customer Support Executive
45
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
42
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
41
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Customer Success Executive
39
salaries
| ₹0 L/yr - ₹0 L/yr |
Zerodha
Sharekhan
Paytm Money
ET Money
- Home >
- Interviews >
- Groww Interview Questions >
- Groww Business Analyst Interview Questions
