Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Angel One Team. If you also belong to the team, you can get access from here

Angel One Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Angel One Associate Product Analyst Interview Questions and Answers

Updated 10 Sep 2024

Angel One Associate Product Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Number of records returned by doing different types of join
  • Ans. 

    The number of records returned by different types of joins can vary based on the relationship between the tables being joined.

    • Inner join returns only the records that have matching values in both tables

    • Left join returns all records from the left table and the matched records from the right table

    • Right join returns all records from the right table and the matched records from the left table

    • Full outer join returns all rec...

  • Answered by AI

Skills evaluated in this interview

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

  • Answered by AI
  • 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.

  • Answered by AI
  • 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...

  • Answered by AI
  • 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...

  • Answered by AI

Interview Preparation Tips

Round: Test
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

Business Analyst Interview Questions & Answers

Paytm user image Rockey Maheshwari

posted on 8 Sep 2015

Interview Preparation Tips

Round: Test
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 applied via Naukri.com and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. They ask about previous work experience
  • Q2. They ask related to analitics questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Read about job description and prepare accordingly
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Case Study 

Marketing campaign case study

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

General aptitude questions and excel questions

Round 2 - Technical 

(1 Question)

  • Q1. Knowledge of excel, guesstimate
Round 3 - HR 

(1 Question)

  • Q1. Cultural fitment
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Jun 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL Queries for JOINS
  • Ans. 

    SQL queries for JOINS

    • Use INNER JOIN to retrieve rows from both tables that have matching values

    • Use LEFT JOIN to retrieve all rows from the left table and the matched rows from the right table

    • Use RIGHT JOIN to retrieve all rows from the right table and the matched rows from the left table

    • Use FULL JOIN to retrieve rows when there is a match in either table

  • Answered by AI
  • Q2. QUERY FOR metrics given in the sheet
  • Ans. 

    The query is asking for metrics provided in a specific sheet.

    • Identify the specific sheet being referred to in the question

    • Review the metrics listed in the sheet

    • Analyze the relevance of each metric to the query

  • Answered by AI
Round 2 - Case Study 

This is a case study round revolve around a business problem in which we have to analyse data driven solutions.

Interview Preparation Tips

Topics to prepare for Rupeek Business Analyst interview:
  • SQL
  • Excel
Interview preparation tips for other job seekers - Be Cool, practice SQL, speak as much as edge cases in case study round and ask many questions.

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. A tough sql question
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. SQL, Python and Excel
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Case Study 

Case studies about Navi UPI

Round 2 - Assignment 

Case studies about Navi UPI App

Interview Preparation Tips

Interview preparation tips for other job seekers - Good experience

Angel One Interview FAQs

How many rounds are there in Angel One Associate Product Analyst interview?
Angel One interview process usually has 1 rounds. The most common rounds in the Angel One interview process are One-on-one Round.

Tell us how to improve this page.

Angel One Associate Product Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Paytm Interview Questions
3.3
 • 758 Interviews
HighRadius Interview Questions
2.8
 • 186 Interviews
Razorpay Interview Questions
3.6
 • 154 Interviews
Visa Interview Questions
3.5
 • 141 Interviews
Revolut Interview Questions
2.5
 • 100 Interviews
Rupeek Interview Questions
3.7
 • 61 Interviews
PayU Payments Interview Questions
3.5
 • 54 Interviews
BankBazaar Interview Questions
3.4
 • 53 Interviews
ACKO Interview Questions
3.7
 • 50 Interviews
View all
Senior Executive
344 salaries
unlock blur

₹1.5 L/yr - ₹5 L/yr

Relationship Manager
298 salaries
unlock blur

₹1.2 L/yr - ₹4.2 L/yr

Assistant Manager
283 salaries
unlock blur

₹2.1 L/yr - ₹7.6 L/yr

Equity Dealer
208 salaries
unlock blur

₹0.9 L/yr - ₹4.5 L/yr

Deputy Manager
162 salaries
unlock blur

₹3 L/yr - ₹10.6 L/yr

Explore more salaries
Compare Angel One with

Paytm

3.3
Compare

HighRadius

2.8
Compare

AGS Transact Technologies

3.0
Compare

Rupeek

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