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 Data Analyst Interview Questions and Answers

Updated 28 Mar 2024

Angel One Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 3 Feb 2024

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

I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself and the current projects you are working on.
Round 2 - Technical 

(1 Question)

  • Q1. Sql Questions on regex, json , window functions were there.
Round 3 - Technical 

(1 Question)

  • Q1. Questions on current project, Tableau related question were there.

Interview questions from similar companies

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

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

Interview preparation tips for other job seekers - I were beast for edelweiss good in
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
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
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
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 experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Introduction , knowledge about capital market
Round 2 - Case Study 

Nothing as such just basic

Interview Preparation Tips

Interview preparation tips for other job seekers - Uat Testing

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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - You must know about Agile methodology.
NISM certification will add value.
How to write Business requirement documents.
You must know about SQL.
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
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Feb 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Hackerrank test medium difficulty

Round 3 - Case Study 

Presenting the case study which was given as a take-home assignment

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for all the basic concepts in Statistics, Database related. Most of the questions will be easy

Angel One Interview FAQs

How many rounds are there in Angel One Data Analyst interview?
Angel One interview process usually has 3 rounds. The most common rounds in the Angel One interview process are Technical and One-on-one Round.
How to prepare for Angel One Data 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 Angel One. The most common topics and skills that interviewers at Angel One expect are Data Analysis, Tableau, Data Analytics, Data Extraction and Data Mining.
What are the top questions asked in Angel One Data Analyst interview?

Some of the top questions asked at the Angel One Data Analyst interview -

  1. Sql Questions on regex, json , window functions were the...read more
  2. Questions on current project, Tableau related question were the...read more

Tell us how to improve this page.

Angel One Data Analyst Interview Process

based on 2 interviews

Interview experience

5
  
Excellent
View more

Data Analyst Interview Questions from Similar Companies

View all
Angel One Data Analyst Salary
based on 12 salaries
₹7 L/yr - ₹18.6 L/yr
112% more than the average Data Analyst Salary in India
View more details

Angel One Data Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

-

Skill development

-

Work-life balance

-

Salary

-

Job security

-

Company culture

-

Promotions

-

Work satisfaction

Explore 1 Review and Rating
Senior Executive
341 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Relationship Manager
319 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
268 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Equity Dealer
212 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Deputy Manager
157 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Angel One with

Zerodha

4.1
Compare

Upstox

3.7
Compare

Groww

3.7
Compare

5paisa Capital Ltd.

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