AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Angel One
Compare
Filter interviews by
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
Interview questions from similar companies
I appeared for an interview in Mar 2017.
Interview Questionnaire
4 Questions
- Q1. Tell us something about yourself.
- Ans.
I am a detail-oriented business analyst with experience in data analysis and project management.
Experienced in data analysis and project management
Detail-oriented and analytical mindset
Strong communication and interpersonal skills
Proficient in various analytical tools such as Excel, SQL, and Tableau
- Q2. What do you about our company?
- Ans.
I am not familiar with your company.
I have not had the opportunity to research your company yet.
I would appreciate it if you could provide me with more information about your company.
I am open to learning more about your company and its goals.
- Q3. Why should we hire you?
- Ans.
I have the skills, experience, and passion to excel in this role and contribute to the success of the company.
I have a strong background in data analysis and problem-solving, which are essential skills for a business analyst.
I have experience working with various stakeholders, including clients, developers, and project managers, to ensure successful project delivery.
I am a quick learner and adaptable to new technologie...
- Q4. What are the marketing strategies according to you?
- Ans.
Marketing strategies are plans and tactics implemented by businesses to promote their products or services and reach their target audience.
Identifying target audience and market segmentation
Creating a unique value proposition
Developing a marketing mix (product, price, place, promotion)
Utilizing digital marketing channels (social media, email marketing, SEO)
Implementing content marketing and storytelling
Building brand a...
Interview Preparation Tips
Experience: The questions were very tough to complete.Highly based on technical questions.
Tips: Hard work is necessary to crack it.
Duration: 3 hours
Total Questions: 45
Round: HR Interview
Experience: It went on very smoothly and i was quite comfortable with the interviewer.
Tips: One just needs to answer all the questions asked by the interviewer in a proper manner or confident manner presenting valid points.
College Name: Kiit university
Rockey Maheshwari
Interview Preparation Tips
Experience: It was a test of moderate level.
20 ques in 20 min.
Basic focus was speed and accuracy.
Tested calculation speed.
Tips: Try to decide which ques to answer and which ones to leave.
Its very important not to get stuck in any 1 ques and waste time. MOVE ON!
Duration: 20 minutes
Total Questions: 20
Round: Technical Interview
Experience: Hi ! i dont remember the question but I do remember that they were easy.
The interviewers are there to test you not to embarrass you. or humiliate you.
They dont expect you to answer every ques so no need to get frustrated if you get a couple of them wrong.
Tips: Go easy...
If you dont know answer to a ques , dont panic,. They are willing to qive you points for your approach.
General Tips: Relax at all times
Skill Tips: Just practice. Whenever you are on facebook solve a couple of brain teasers.
Skills: Aptitude
College Name: DTU
Motivation: Good Future prospects!
I appeared for an interview in Feb 2025.
Sql and excel then tableu
(1 Question)
- Q1. Sql and excel and basic questions
(1 Question)
- Q1. Longterm aspiration
I applied via Campus Placement and was interviewed in Dec 2024. There were 2 interview rounds.
Quantitative aptitude, verbal ability, critical reasoning
(2 Questions)
- Q1. SQL: find store with highest AOV
- Ans.
Use SQL query to find store with highest Average Order Value (AOV).
Use GROUP BY clause to group by store
Calculate AOV by dividing total revenue by total orders
Use ORDER BY and LIMIT to find store with highest AOV
- Q2. Generic behavioural questions
Selected
I applied via Naukri.com and was interviewed before May 2022. There were 3 interview rounds.
New market launch strategy
SQL intermediate level
Selected
I applied via Naukri.com and was interviewed in Aug 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Tell me about your self. Tell about past background. About education and past employment.
- Q2. Advance Excel questions.
Interview Preparation Tips
I applied via Referral and was interviewed before Oct 2022. There were 3 interview rounds.
(1 Question)
- Q1. Basic analytical question
(2 Questions)
- Q1. Why do we hire you ?
- Q2. How can you be helpful to organisation?
- Ans.
I can be helpful to the organization by analyzing data, identifying trends, and providing insights to support decision-making.
Conduct thorough data analysis to identify patterns and trends
Generate reports and presentations to communicate findings to stakeholders
Collaborate with cross-functional teams to provide insights and recommendations
Utilize tools such as Excel, SQL, and Tableau to analyze and visualize data
Interview Preparation Tips
Angel One Interview FAQs
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
344
salaries
|  ₹1.5 L/yr - ₹5 L/yr |
|
Relationship Manager
315
salaries
| ₹1.4 L/yr - ₹4.5 L/yr |
|
Assistant Manager
267
salaries
| ₹2.1 L/yr - ₹7.5 L/yr |
|
Equity Dealer
208
salaries
| ₹0.9 L/yr - ₹4.5 L/yr |
|
Deputy Manager
173
salaries
| ₹3 L/yr - ₹10 L/yr |
Paytm
HighRadius
AGS Transact Technologies
Rupeek
- Home >
- Interviews >
- Angel One Interview Questions >
- Angel One Business Analyst Interview Questions
