AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Udaan
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Udaan Business Analyst Interview Questions and Answers
Udaan Business Analyst Interview Experiences
3 interviews found
Anonymous
Selected
I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Find 3rd highest salary using SQL
- Ans.
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.
Use SELECT statement to retrieve salary column
Use ORDER BY clause to sort salaries in descending order
Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary
- Q2. Queries on self join
(1 Question)
- Q1. Questions on Power B, DAX etc.,
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jan 2022. There were 2 interview rounds.
(2 Questions)
- Q1. What do I do in my existing job?
- Q2. Why do you want to leave your existing job?
(2 Questions)
- Q1. Tell me about yourself?
- Q2. Why would you like to join our organisation?
Interview Preparation Tips
I appeared for an interview in Nov 2020.
Interview Questionnaire
1 Question
- Q1. Mainly about sql, previous job role
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Sep 2020. There was 1 interview round.
Interview Questionnaire
6 Questions
- Q1. Tell me about your self
- Ans.
I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.
Experienced in conducting market research and competitor analysis
Proficient in using various data analysis tools such as Excel, SQL, and Tableau
Skilled in identifying business needs and translating them into functional requirements
Excellent communication and presentation skills
Ability to work colla...
- Q2. What do you want work here?
- Ans.
I want to work here because of the company's reputation, growth opportunities, and alignment with my skills and interests.
I am impressed by the company's reputation in the industry.
I see great potential for growth and advancement within the company.
The company's values and mission align with my own.
I believe my skills and experience would be a valuable asset to the company.
I am excited about the opportunity to contribu...
- Q3. What makes you unique?
- Ans.
I have a unique combination of technical skills and business acumen, allowing me to bridge the gap between IT and business stakeholders.
I have a strong background in both technology and business domains.
I can effectively communicate with both technical and non-technical stakeholders.
I have a track record of successfully translating business requirements into technical solutions.
I possess a deep understanding of various...
- Q4. What do you know about the company?
- Ans.
The company is a leading technology firm specializing in software development and consulting services.
The company was founded in 2005 and has since grown to have a global presence.
They offer a wide range of services including business analysis, software development, and project management.
Some of their notable clients include Fortune 500 companies in various industries.
They have a strong focus on innovation and staying...
- Q5. What are your key professional strengths?
- Ans.
My key professional strengths include analytical thinking, problem-solving, and effective communication.
Analytical thinking: I have a strong ability to analyze complex business problems and identify key insights.
Problem-solving: I am skilled at finding creative solutions to challenges and implementing them effectively.
Effective communication: I can communicate complex ideas and findings clearly and concisely to stakeho...
- Q6. What are your biggest weaknesses?
- Ans.
My biggest weaknesses include perfectionism, overthinking, and public speaking anxiety.
Perfectionism: I tend to spend too much time on tasks to ensure they are flawless.
Overthinking: I sometimes overanalyze situations, which can lead to indecisiveness.
Public speaking anxiety: I get nervous when presenting in front of large audiences.
Interview Preparation Tips
Practice, practice, practice.
I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed before Feb 2022. There were 2 interview rounds.
(2 Questions)
- Q1. All regarding resume and about work experience, culture and your background.
- Q2. Update as per above mentioned questions
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. How to improve csat
- Ans.
Improving CSAT involves understanding customer needs, providing excellent service, and gathering feedback.
Train team members to actively listen to customers and address their concerns
Provide personalized solutions and go above and beyond to exceed expectations
Regularly gather feedback through surveys and use it to make improvements
Implement a customer-centric culture throughout the organization
Ensure timely and effecti...
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Mar 2022. There were 5 interview rounds.
The test was based on SQL and the questions were similar to medium difficulty level questions in leetcode.
(3 Questions)
- Q1. Describe different types of joins
- Ans.
Different types of joins are used in database queries to combine data from multiple tables.
Inner join: Returns only the matching records from both tables.
Left join: Returns all records from the left table and the matching records from the right table.
Right join: Returns all records from the right table and the matching records from the left table.
Full outer join: Returns all records when there is a match in either the ...
- Q2. 2 tables were given and I was asked to tell the number of rows in output based on different types of joins.
- Q3. Calculated the rows based on joins and told the answer.
(4 Questions)
- Q1. Describe your previous experience
- Ans.
I have 3 years of experience as a Business Analyst in the IT industry.
Worked on gathering and analyzing business requirements
Created functional specifications and user stories
Conducted stakeholder interviews and facilitated meetings
Performed data analysis and created reports
Collaborated with cross-functional teams to implement solutions
Utilized tools like JIRA and Confluence for project management
Improved business proc
- Q2. Shared the details regarding my experience
- Q3. A SQL based puzzle based on window functions where I had to find 4 consecutive empty seats in a theater.
- Q4. Solved using lag function.
The interviewer asked about my previous experience along with a few situation based questions and then gave me a case study to find out possible reasons for a decrease in the cancellations between order dispatch and order delivery.
Interview Preparation Tips
- SQL
- Problem solving
Skills evaluated in this interview
(1 Question)
- Q1. About career and current org-related and project questions.
About programming languages.
Related to project and other project managment questions.
(1 Question)
- Q1. General questions related to carrer and job
Interview Preparation Tips
(1 Question)
- Q1. Guesstimates, SQL, MS-Excel related questions.
A case study, few HR questions.
Interview Preparation Tips
Udaan Interview FAQs
Tell us how to improve this page.
Udaan Interviews By Designations
- Udaan Business Development Executive Interview Questions
- Udaan Team Lead Interview Questions
- Udaan Operations Executive Interview Questions
- Udaan Field Executive Interview Questions
- Udaan HUB Manager Interview Questions
- Udaan Business Development Manager Interview Questions
- Udaan Processing Executive Interview Questions
- Udaan Sales Executive 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
Udaan Business Analyst Interview Process
based on 1 interview
Interview experience
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Udaan Business Analyst Reviews and Ratings
based on 17 reviews
Rating in categories
|
Business Development Executive
2.1k
salaries
|  ₹1.5 L/yr - ₹5.5 L/yr |
|
Team Lead
517
salaries
| ₹1.3 L/yr - ₹7.2 L/yr |
|
Operations Executive
445
salaries
| ₹1.6 L/yr - ₹4.2 L/yr |
|
MIS Executive
439
salaries
| ₹1.7 L/yr - ₹5.3 L/yr |
|
Sales Officer
336
salaries
| ₹2 L/yr - ₹6.6 L/yr |
Meesho
Swiggy
Lenskart
BlackBuck
- Home >
- Interviews >
- Udaan Interview Questions >
- Udaan Business Analyst Interview Questions
