AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Angel One
Compare
Filter interviews by
Clear (1)
Angel One Business Analyst Interview Questions and Answers
Angel One Business Analyst Interview Experiences
3 interviews found
Anonymous
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.
(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
(1 Question)
- Q1. Questions on probability and puzzles
Interview Preparation Tips
Business Analyst Jobs at Angel One
Top trending discussions
Interview questions from similar companies
(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
I applied via Recruitment Consultant
Interview Questionnaire
6 Questions
- Q1. Were location me to company and
- Q2. Were location gone me location
- Q3. When you me take me constant
- Q4. Because me best for edelweiss
- Q5. Location give me I will best
- Q6. How give me Edelweiss
Interview Preparation Tips
Stargate home location B D work
Operation work and also CHM
Because edelweiss is my best company
So I will best for edelweiss
In all work me interested so beast future in edelweiss so
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
(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
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.
Selected
I applied via Campus Placement and was interviewed in Jan 2024. There were 2 interview rounds.
(1 Question)
- Q1. Introduction , knowledge about capital market
Nothing as such just basic
Interview Preparation Tips
I applied via Referral and was interviewed in Mar 2021. There were 5 interview rounds.
Interview Questionnaire
2 Questions
- Q1. About Capital Market Domain
- Q2. How you can add value to product.
- Ans.
I can add value to a product by identifying and analyzing customer needs, improving processes, and implementing innovative solutions.
Conduct market research to identify customer needs and preferences
Analyze data to identify areas for improvement in product design and functionality
Collaborate with cross-functional teams to develop and implement innovative solutions
Streamline processes to improve efficiency and reduce co...
Interview Preparation Tips
NISM certification will add value.
How to write Business requirement documents.
You must know about SQL.
Angel One Interview FAQs
Recently Viewed
SALARIES
Lakshmi Machine Works
INTERVIEWS
Rolls-Royce
No Interviews
INTERVIEWS
Rolls-Royce
10 top interview questions
DESIGNATION
SALARIES
Accelya Solutions India Limited
SALARIES
Accelya Solutions India Limited
INTERVIEWS
CleverTap
No Interviews
SALARIES
Honeywell Automation
INTERVIEWS
Nestaway
No Interviews
INTERVIEWS
Angel One
No Interviews
Tell us how to improve this page.
Angel One Interviews By Designations
- Angel One Relationship Manager Interview Questions
- Angel One Software Developer Interview Questions
- Angel One Customer Service Manager Interview Questions
- Angel One Customer Service Associate Interview Questions
- Angel One Assistant Manager Interview Questions
- Angel One Business Analyst Interview Questions
- Angel One Senior Executive Interview Questions
- Angel One Associate Product Manager 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
Angel One Business Analyst Interview Process
based on 3 interviews
Interview experience
Business Analyst Interview Questions from Similar Companies
Angel One Business Analyst Reviews and Ratings
based on 7 reviews
Rating in categories
8-15 Yrs
Not Disclosed
|
Senior Executive
343
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Relationship Manager
319
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
282
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Equity Dealer
212
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Deputy Manager
171
salaries
| ₹0 L/yr - ₹0 L/yr |
Zerodha
Upstox
Groww
5paisa Capital Ltd.
- Home >
- Interviews >
- Angel One Interview Questions >
- Angel One Business Analyst Interview Questions
