AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
EXL
Service
Compare
Filter interviews by
EXL Service Business Analyst Interview Questions and Answers
32 Interview questions
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.
Impl...
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: ...
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...
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 devel...
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.
Logistic regression is a statistical model used to predict the probability of a binary outcome based on one or more predictor variables.
Logistic regression is used when the dependent variable is binary (e.g. 0 or 1, yes or no).
It estimates the probability that a given outcome is true using a logistic function.
The output of logistic regression is a probability score between 0 and 1.
It is commonly used in various fi...
SQL query to fetch dates from two tables, demonstrating joins and date filtering.
Use JOIN to combine data from two tables based on a common key.
Example: SELECT a.date, b.event FROM tableA a JOIN tableB b ON a.id = b.a_id WHERE a.date > '2023-01-01';
Consider using LEFT JOIN if you want to include all records from the first table.
Use WHERE clause to filter results based on date conditions.
Example: SELECT * FROM o...
Effectively managing tough stakeholders requires communication, empathy, and strategic negotiation skills.
Understand their perspective: Schedule one-on-one meetings to listen to their concerns and motivations.
Build rapport: Share common goals and demonstrate how your project aligns with their interests.
Communicate clearly: Use simple language and visuals to explain complex concepts, ensuring they feel informed.
Be ...
proc report is a SAS procedure used for creating tabular reports.
proc report is used to summarize and present data in a tabular format.
It allows users to define the structure and appearance of the report.
Users can specify variables, statistics, and formatting options.
It supports grouping, sorting, and summarizing data.
Output can be generated in various formats like HTML, PDF, and RTF.
Example: proc report data=sale...
To remove duplicates from an array of strings, use a hash set or sort the array and iterate to remove duplicates.
Create a hash set and iterate through the array, adding each element to the set. If the element already exists in the set, remove it from the array.
Sort the array using a sorting algorithm like quicksort or mergesort. Then iterate through the sorted array and remove any duplicates by comparing adjacent ...
EXL Service Business Analyst Interview Experiences
69 interviews found
Anonymous
Selected
I applied via Campus Placement
Basic Aptitude, time and distance, time and work, basic class 10 maths
(2 Questions)
- Q1. Guesstimate - detergent used in hospital in a day
- 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
(2 Questions)
- 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...
- 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...
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. About scrum, product backlog, requirement handling
- 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...
I appeared for an interview in Apr 2025, where I was asked the following questions.
- 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 ...
- 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...
Apti and maths and English mcq
Puzzles of geeksforgeeks
(1 Question)
- 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.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Jul 2024. There were 2 interview rounds.
(1 Question)
- Q1. Previous Projects
- Ans.
I have worked on various projects including data analysis, process improvement, and system implementation.
Led a team to analyze sales data and identify trends for a retail company
Implemented a new CRM system to streamline customer interactions for a tech company
Improved inventory management processes for a manufacturing company
(1 Question)
- Q1. No one from operation joined the meeting
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. Guestimates was aked based on banking domain
- Q2. Aptitude question was asked
Selected
I applied via Approached by Company and was interviewed in Aug 2024. There were 2 interview rounds.
Nothing as such general questions
Basic sql questions, prepare basics
Selected
I appeared for an interview in Oct 2024, where I was asked the following questions.
- Q1. Cat modelling questions related to RMS/AIR
- Q2. Advanced Excel, SQL
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Oct 2023. There were 4 interview rounds.
Online Aptitude test
(2 Questions)
- Q1. Puzzles from geeks4geeks
- Q2. Profitability case study
(2 Questions)
- Q1. Questions from resume
- Q2. Business case study
(1 Question)
- Q1. Questions from their presentation in pre placement talk
satheesh
I applied via Campus Placement and was interviewed in Sep 2023. There were 4 interview rounds.
Aptitude test consists of 35 mins in 40 mins
(1 Question)
- Q1. The interviewer is quite good and asked about SQL and projects in the resume.and he asks about the case study and that's it and I have shortlisted for second and final round but there i was failed
(1 Question)
- Q1. This was tough the interviewer was not good she asked many difficult questions in the case study and puzzles
Interview Preparation Tips
- SQL
- Python
Top trending discussions
EXL Service Interview FAQs
Some of the top questions asked at the EXL Service Business Analyst interview -
The duration of EXL Service Business Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
EXL Service Interviews By Designations
- EXL Service Business Analyst Interview Questions
- EXL Service Consultant Interview Questions
- EXL Service Executive Interview Questions
- EXL Service Assistant Manager Interview Questions
- EXL Service Senior Associate Interview Questions
- EXL Service Senior Executive Interview Questions
- EXL Service Data Analyst Interview Questions
- EXL Service Associate 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 Executive Interview Questions
- Business Development Interview Questions
- Business Manager Interview Questions
- Show more
Overall Interview Experience Rating
based on 43 interview experiences
Difficulty level
Duration
Business Analyst Interview Questions from Similar Companies
EXL Service Business Analyst Reviews and Ratings
based on 172 reviews
Rating in categories
|
Senior Executive
4.5k
salaries
|  ₹0.9 L/yr - ₹7.5 L/yr |
|
Assistant Manager
3.2k
salaries
| ₹4.2 L/yr - ₹16 L/yr |
|
Senior Associate
2.5k
salaries
| ₹1 L/yr - ₹8.5 L/yr |
|
Lead Assistant Manager
2k
salaries
| ₹6.5 L/yr - ₹24 L/yr |
|
Executive
2k
salaries
| ₹1 L/yr - ₹5.7 L/yr |
Genpact
DXC Technology
Mphasis
Sutherland Global Services
- Home >
- Interviews >
- EXL Service Interview Questions >
- EXL Service Business Analyst Interview Questions
