Angel One Interview Questions, Process, and Tips

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.

Write code for advance surrying in js

Implement custom hook for api call

Q1. Basic questions arounf my previous work
Add your answer
Q2. Technical questions around performance and code optimization
Add your answer

Q1. Introduction and about work Experience.
Add your answer
Q2. About your work experiences.
Add your answer

Q1. Introduction and about work Experience
Add your answer
Q2. Technical questions related work process
Add your answer

Q1. How well do you know about your previous company, and what do you know about the company of your interviewer?
Add your answer

Q1. How important is it to work on your voice tone, English proficiency, and understanding of your job profile?
Add your answer

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...read more
Answered by AI
Add your answer

Q1. Personal details introduction
Add your answer
Q2. Detailed Experience about current designation
Ans. 
I have been working as a Senior Process Trainer for the past 5 years, leading training sessions and developing training materials.
• Led training sessions for new hires and existing employees on various processes and systems

• Developed training materials such as manuals, presentations, and online modules

• Conducted assessments and evaluations to measure training effectiveness

• Collaborated with stakeholders to identify training...read more
Answered by AI
Add your answer
Q3. Over experience in Bpo
Add your answer

Q1. Self introducing
Add your answer
Q2. Past Experience in training
Add your answer