Get AmbitionBox App
Faster and better experience!
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
7 Interview questions
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...
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 ...
What people are saying about EXL Service
Big data refers to large and complex data sets that cannot be processed using traditional data processing methods.
Big data involves the collection, storage, and analysis of massive amounts of data
It requires advanced technologies and tools to process and make sense of the data
Examples of big data include social media data, sensor data, and financial market data
Group By function in SQL is used to group rows that have the same values into summary rows.
Group By function is used with aggregate functions like COUNT, SUM, AVG, etc.
It is used to summarize data by grouping rows based on specified columns.
For example, SELECT department, COUNT(*) FROM employees GROUP BY department;
Inner Join returns only the matching rows between two tables, while Left Join returns all rows from the left table and the matching rows from the right table.
Inner Join only includes rows that have matching values in both tables
Left Join includes all rows from the left table, even if there are no matching rows in the right table
Example: Inner Join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Ex...
EXL Service Business Analyst Interview Experiences
69 interviews found
Anonymous
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...
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
- 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.
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
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
Business Analyst Interview Questions from Similar Companies
EXL Service Business Analyst Reviews and Ratings
based on 172 reviews
Rating in categories
|
Senior Executive
4.4k
salaries
|  ₹1.4 L/yr - ₹7.3 L/yr |
|
Assistant Manager
3.2k
salaries
| ₹4.2 L/yr - ₹15.8 L/yr |
|
Senior Associate
2.6k
salaries
| ₹1 L/yr - ₹8.5 L/yr |
|
Lead Assistant Manager
2k
salaries
| ₹6.5 L/yr - ₹24 L/yr |
|
Executive
1.9k
salaries
| ₹1 L/yr - ₹5.7 L/yr |
Genpact
DXC Technology
Mphasis
Optum Global Solutions
- Home >
- Interviews >
- EXL Service Interview Questions >
- EXL Service Business Analyst Interview Questions
