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, Process, and Tips
Top EXL Service Business Analyst Interview Questions and Answers
- Q1. If I have 333 digits to number pages of a book, How many pages can I number ?
- Q2. 9 coins you have, one of the coin has lesser weight, you have a weighing balance, how many times you will have to use that to pick out the lesser weighted coin?
- Q3. Explain about ERP, it's advantages(a software which I worked upon during my internship)
EXL Service Business Analyst Interview Experiences
67 interviews found
Anonymous
Selected
I applied via LinkedIn and was interviewed before Feb 2023. There was 1 interview round.
(3 Questions)
- Q1. SQL questions fetching date from two tables
- Q2. Questions on how to tackle tough stakeholders
- Q3. Meaning of success for you
Interview Preparation Tips
Selected
I applied via campus placement at Indian Institute of Technology (IIT), Indore and was interviewed before Mar 2023. There were 3 interview rounds.
Aptitude test was not very difficult. There were questions on data analysis, mostly on aptitude.
(1 Question)
- Q1. Explain logistic regression.
- Ans.
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 fields ...
(1 Question)
- Q1. Arey you comfortable with working in high pressure environment?
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed before Jul 2023. There were 2 interview rounds.
(1 Question)
- Q1. Tell us about yourelf
Basic SQL codes and excel questions about lookup and pivots
What people are saying about EXL Service
I applied via campus placement at Motilal Nehru Institute National Institute of Technology (NIT), Allahabad and was interviewed before Dec 2021. There were 4 interview rounds.
Basic to medium level aptitude questions not too tough
(1 Question)
- Q1. >Project based questions on ur resume >Coding questions based on the language in ur resume very basic. >Guesstimates >No of active credit cards user in india >Puzzles:from GFG >Standard Sql questions like ...
(1 Question)
- Q1. What is your future aspirations >Standard questions from statistics >Central tendency >Standard deviations >How much will you rate yourself out of 10
- Ans.
My future aspiration is to become a successful business analyst and contribute to the growth of the company.
I aim to enhance my skills in data analysis and problem-solving.
I want to work on diverse projects and gain experience in different industries.
I plan to take up leadership roles and mentor junior analysts.
I aspire to be a valuable asset to the organization and help achieve its goals.
Interview Preparation Tips
Good knowledge of SQL
Keep everything clear about your resume
EXL Service interview questions for designations
Selected
I applied via Campus Placement and was interviewed before Sep 2022. There were 3 interview rounds.
Medium level aptitude questions were asked
(2 Questions)
- Q1. All about skills on resume and sql
- Q2. Puzzles and guesstimates and about project
(2 Questions)
- Q1. All about resume and behaviour questions asked
- Q2. Wy do you want to join tis company
Get interview-ready with Top EXL Service Interview Questions
I was interviewed in Aug 2021.
(2 Questions)
Round duration - 45 minutes
Round difficulty - Medium
This was a technical round.
- Q1. What is the difference between Inner Join and Left Join in DBMS?
- Ans.
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
Example...
- Q2. What is the Group By function in SQL?
- Ans.
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;
Interview Preparation Tips
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : If you know sql, tableau and have good practice of case study question, you will have good chances to convert
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Skills evaluated in this interview
I was interviewed in Oct 2021.
(1 Question)
- Q1. About your project and ML concepts
(1 Question)
- Q1. Most questions were based on ML concepts, few sql queries and a puzzle
(1 Question)
- Q1. Discussed about the salary expectation
Interview Preparation Tips
- Data Science
- SQL
Rohit Kumar
I applied via campus placement at Jadavpur University and was interviewed in Nov 2021. There were 2 interview rounds.
Basic aptitude questions with DILR, QA and Varc
(2 Questions)
- Q1. Describe your college project
- Ans.
Developed a web-based inventory management system for a retail company
Used HTML, CSS, and JavaScript to create the user interface
Implemented a database using MySQL to store product information
Designed and implemented various features such as product search, order management, and reporting
Conducted user testing and incorporated feedback to improve the system
Collaborated with a team of developers and stakeholders to ensu
- Q2. One Guesstimate question
Interview Preparation Tips
I applied via campus placement at National Institute of Technology (NIT), Rourkela and was interviewed in Aug 2021. There was 1 interview round.
Interview Questionnaire
5 Questions
- Q1. Guesstimate: if a company want to get into umbrella business in your city , number of umbrella it should manufacture?
- Q2. What is group by fucation in sql?
- Ans.
GROUP BY is a SQL clause used to group rows based on a column and perform aggregate functions on them.
Used to group rows based on a column
Aggregate functions can be performed on the grouped rows
Used with SELECT statement
Commonly used with COUNT, SUM, AVG functions
Helps in data analysis and reporting
- Q3. Differences between inner join and left join?
- Ans.
Inner join returns only matching rows from both tables while left join returns all rows from left table and matching rows from right table.
Inner join is used to retrieve data that exists in both tables based on a common column.
Left join is used to retrieve all data from the left table and matching data from the right table.
Inner join excludes non-matching rows from both tables while left join includes all rows from the...
- Q4. Tell me about your project in internship? (Question on that will be asked)
- Q5. Why into business Analysts not in your core-branch company?
Interview Preparation Tips
Don't make stupid answer when you don't know
If you know sql, tableau and have good practice of case study question, you will have good chances to convert
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed before Oct 2022. There were 3 interview rounds.
(1 Question)
- Q1. Sql basic ,where ,groupby having partition ,join
(1 Question)
- Q1. Discussion on projects undertaken at college level,skill,
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
EXL Service Business Analyst Interview Process
based on 41 interviews
4 Interview rounds
- Resume Shortlist Round
- Technical Round - 1
- Technical Round - 2
- HR Round
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
EXL Service Business Analyst Reviews and Ratings
based on 165 reviews
Rating in categories
|
Senior Executive
4.3k
salaries
|  ₹0.9 L/yr - ₹7.1 L/yr |
|
Assistant Manager
2.9k
salaries
| ₹4 L/yr - ₹14.5 L/yr |
|
Senior Associate
2.4k
salaries
| ₹1.2 L/yr - ₹8 L/yr |
|
Lead Assistant Manager
1.9k
salaries
| ₹6.5 L/yr - ₹22.4 L/yr |
|
Executive
1.8k
salaries
| ₹1 L/yr - ₹5.5 L/yr |
Genpact
WNS
TCS
Infosys
- Home >
- Interviews >
- EXL Service Interview Questions >
- EXL Service Business Analyst Interview Questions
