EXL Service Business Analyst Interview Questions and Answers

Basic Aptitude, time and distance, time and work, basic class 10 maths

Q1. Guesstimate - detergent used in hospital in a day
Add your answer
Q2. Position of responsibility
Ans. 
I have held multiple positions of responsibility in my previous roles, including leading project teams and managing client relationships.
• Led a project team to successfully implement a new software system

• Managed client relationships and ensured customer satisfaction

• Served as a mentor to junior team members and provided guidance on complex projects
Answered by AI
Add your answer

Q1. Guestimate - flights in mumbai airport in a day
Ans. 
Estimating daily flights at Mumbai Airport involves analyzing passenger traffic, flight schedules, and operational capacity.
• Mumbai Airport (Chhatrapati Shivaji Maharaj International Airport) is one of the busiest in India.

• Assume an average of 40-50 flights per hour during peak times.

• If the airport operates for 24 hours, that could mean 960-1200 flights daily.

• Consider both domestic and international flights, with a high...read more
Answered by AI
Add your answer
Q2. What is that makes you a suitable candidate and why EXL
Ans. 
I am a suitable candidate for the Business analyst role at EXL due to my strong analytical skills, experience in data analysis, and ability to drive business insights.
• I have a strong background in data analysis and have successfully implemented data-driven strategies in my previous roles.

• I possess excellent analytical skills which enable me to interpret complex data and provide valuable insights for decision-making.

• I h...read more
Answered by AI
Add your answer

Q1. About scrum, product backlog, requirement handling
Add your answer
Q2. Some scenario based questions- if manager is planning the sprint and there is no scrum master in organization, how do you as BA make sure that product quality is not compromised.
Ans. 
As a BA, I would implement strategies to ensure product quality during sprint planning without a Scrum Master.
• Facilitate clear communication among team members to ensure everyone understands the sprint goals.

• Encourage the use of automated testing tools to maintain code quality and catch issues early.

• Implement regular check-ins or stand-up meetings to monitor progress and address any blockers.

• Collaborate with developers...read more
Answered by AI
Add your answer

Q1. Write a code in Python to find highest number from a list without using Max and loop function
Ans. 
Find the highest number in a list using Python without max() or loops by leveraging recursion or built-in functions.
• Recursion: Use a recursive function to compare elements and find the maximum value. Example: def find_max(lst): return lst[0] if len(lst) == 1 else max(lst[0], find_max(lst[1:]))

• Reduce Function: Utilize the functools.reduce() method to apply a function cumulatively to the items of the list. Example: from ...read more
Answered by AI
Add your answer
Q2. Write a code in Python to detect Outlier treatment for IQR method
Ans. 
The IQR method identifies outliers by calculating the interquartile range and determining thresholds for outlier detection.
• IQR Calculation: IQR is calculated as Q3 (75th percentile) - Q1 (25th percentile).

• Outlier Thresholds: Outliers are defined as values below Q1 - 1.5 * IQR or above Q3 + 1.5 * IQR.

• Example: For a dataset [1, 2, 3, 4, 5, 100], Q1 = 2, Q3 = 5, IQR = 3. Outliers are values < -2.5 or > 7.5.

• Implement...read more
Answered by AI
Add your answer

Apti and maths and English mcq

Puzzles of geeksforgeeks

Q1. SQL join types and difference
Ans. 
SQL join types include inner join, left join, right join, and full outer join.
• Inner join returns rows when there is at least one match 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 table.
Answered by AI
Add your answer