Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by EXL Service Team. If you also belong to the team, you can get access from here

EXL Service Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

EXL Service Business Analyst Interview Questions and Answers for Freshers

Updated 8 May 2025

11 Interview questions

A Business Analyst was asked
Q. Write SQL queries to fetch data from two tables.
Ans. 

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...

A Business Analyst was asked
Q. How do you handle difficult stakeholders?
Ans. 

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 ...

Business Analyst Interview Questions Asked at Other Companies for Fresher

Q1. There are 100 people standing in a circle, the first person has a ... read more
asked in EXL Service
Q2. Doors numbered 1 to 100 are initially closed. In the first step, ... read more
asked in EXL Service
Q3. If you have 333 digits to number the pages of a book, how many pa ... read more
asked in Flipkart
Q4. If you have 100 unbiased coins and one of them is defective, and ... read more
asked in TCS
Q5. If you were the product manager and needed to sell a product, wha ... read more
A Business Analyst was asked
Q. Explain DML, DDL, and TCL (terms used in SQL).
Ans. 

DML, DDL, and TCL are terms used in SQL for manipulating and managing data.

  • DML (Data Manipulation Language) is used for inserting, updating, and deleting data in a database.

  • DDL (Data Definition Language) is used for creating, altering, and dropping database objects such as tables, indexes, and views.

  • TCL (Transaction Control Language) is used for managing transactions in a database, including committing or rolling ...

A Business Analyst was asked
Q. Write an algorithm to optimize the EXL interview process.
Ans. 

Algorithm to optimize EXL interview process

  • Identify key performance indicators (KPIs) for the interview process

  • Use data analytics to track and analyze the KPIs

  • Implement automation and AI to streamline the process

  • Incorporate feedback from candidates and interviewers to continuously improve the process

What people are saying about EXL Service

View All
a software engineer ii
2w
Can Cognizant move up my start date?
Got freed up from my current project sooner than expected. Now I have 25 days before joining Cognizant. HR isn't really responding. Anyone know if they can adjust the joining date if I ask? Any help is appreciated!
Got a question about EXL Service?
Ask anonymously on communities.
A Business Analyst was asked
Q. Explain ERP and its advantages, based on your experience during your internship.
Ans. 

ERP is a software that integrates various business processes and functions into a single system.

  • ERP stands for Enterprise Resource Planning.

  • It helps organizations streamline their operations and improve efficiency.

  • Advantages of ERP include centralized data management, improved collaboration, and better decision-making.

  • It automates processes like inventory management, financials, human resources, and customer relat...

A Business Analyst was asked
Q. What is big data?
Ans. 

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

A Business Analyst was asked
Q. If you have 333 digits to number the pages of a book, how many pages can you number?
Ans. 

333 digits can number 166 pages of a book.

  • Each page number takes up 2 digits.

  • The first page is numbered 01.

  • The last page that can be numbered is 166.

  • The remaining 2 digits are used for the cover page or other information.

Are these interview questions helpful?
A Business Analyst was asked
Q. If you have to sell a new, costly phone to a customer, how would you approach them?
Ans. 

To approach a customer for selling a costly new phone, I would focus on highlighting the unique features, benefits, and value it offers.

  • Understand the customer's needs and preferences

  • Highlight the unique features and benefits of the phone

  • Emphasize the value and long-term benefits of investing in a high-quality phone

  • Offer flexible payment options or financing plans

  • Provide comparisons with other phones to showcase t...

A Business Analyst was asked
Q. Doors numbered 1 to 100 are initially closed. In the first step, all doors are opened. In the second step, doors with numbers that are multiples of 2 are toggled (opened if closed, closed if open). In the t...
Ans. 

After opening and closing doors with multiples of their numbers, which doors are open?

  • Doors with odd number factors will be open after 100th time

  • Doors with even number factors will be closed after 100th time

  • Example: Door 16 will be closed after 100th time as it has factors 2, 4, 8, 16

A Business Analyst was asked
Q. Why analytics ? Why EXL? 1 elaborated GUESTIMATE 5 years plan Biggest achievements in life (professional and personal)
Ans. 

Analytics is crucial for informed decision-making and driving business growth. EXL's expertise and innovative solutions make them the ideal choice.

  • Analytics provides valuable insights into customer behavior, market trends, and business performance.

  • Data-driven decision-making is essential for staying competitive in today's fast-paced business environment.

  • EXL's advanced analytics capabilities and industry expertise ...

EXL Service Business Analyst Interview Experiences for Freshers

16 interviews found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Oct 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions

Round 2 - Technical 

(2 Questions)

  • Q1. About the projects and SQL queries
  • Q2. Puzzles and guesstimates
Round 3 - HR 

(2 Questions)

  • Q1. Family background
  • Q2. Some technical questions were also asked

Business Analyst Interview Questions & Answers

user image Ankit Srivastava

posted on 16 Oct 2023

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

DATA interpretation , reasoning and some data analysis question MCQ type.

Round 3 - Technical 

(1 Question)

  • Q1. General python questions.
Round 4 - Technical 

(1 Question)

  • Q1. Question was related to my projects
Round 5 - HR 

(1 Question)

  • Q1. General HR question , weakness , where do you see yourself in EXL in long run.

Interview Preparation Tips

Interview preparation tips for other job seekers - just focus on your branch basics
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Aug 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Basic aptitude questions - comprehensions, basic mathematics and reasoning questions

Round 3 - Technical 

(1 Question)

  • Q1. Questions about resume first Prior Internship Details Basic Questions about coding languages- sql, c++ and oops Writing a querry in sql Basic questions about my core branch (Electronics) 2 brief Guesti...
Round 4 - HR 

(1 Question)

  • Q1. Why analytics ? Why EXL? 1 elaborated GUESTIMATE 5 years plan Biggest achievements in life (professional and personal)
  • Ans. 

    Analytics is crucial for informed decision-making and driving business growth. EXL's expertise and innovative solutions make them the ideal choice.

    • Analytics provides valuable insights into customer behavior, market trends, and business performance.

    • Data-driven decision-making is essential for staying competitive in today's fast-paced business environment.

    • EXL's advanced analytics capabilities and industry expertise enabl...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be calm and confident
Enhance your coding skills in any language possible
Efficiency in SQL would definitely help
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic questions on aptitude

Round 2 - Technical 

(1 Question)

  • Q1. Case studies and sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare case studies and aptitude
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. General screening
Round 2 - Technical 

(1 Question)

  • Q1. Sql and tableau basic questions
Round 3 - Technical 

(1 Question)

  • Q1. Business and technical both more on sql and tableau experience
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. SQL questions fetching date from two tables
  • Ans. 

    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 orders...

  • Answered by AI
  • Q2. Questions on how to tackle tough stakeholders
  • Ans. 

    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 proac...

  • Answered by AI
  • Q3. Meaning of success for you

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep trying it works

I applied via Campus Placement and was interviewed before Dec 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Basic to medium level aptitude questions not too tough

Round 3 - Technical 

(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 ...
Round 4 - HR 

(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.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good knowledge of any of the coding language
Good knowledge of SQL
Keep everything clear about your resume
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jan 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

The first round usually contains aptitude, data interpretation and verbal.
Need to be quick because we hardly get 90sec for a question.

Round 3 - Technical 

(1 Question)

  • Q1. Technical Round would be from the skills mentioned on your resume. Since I had ML written on my resume he started asking about ML algorithms. Some of the questions were- what is a loss function? How do yo...
Round 4 - Technical 

(1 Question)

  • Q1. In this round the interviewer gave a problem and asked me to solve using python. This time he asked about my projects mentioned on the resume. He asked some of interests and he explained the working cultur...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be clear on the skills you mention on your resume.

I applied via Campus Placement and was interviewed in Nov 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions related to cv

Interview Preparation Tips

Interview preparation tips for other job seekers - Average interview experience. Be technically prepared. Nothing much to be stressed for. Be cool during the interview

Interview Questionnaire 

2 Questions

  • Q1. Where do you see yourself in 5 years
  • Q2. What are your strengths

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for such question as a fresher as you don't have much in your resume

EXL Service Interview FAQs

How many rounds are there in EXL Service Business Analyst interview for freshers?
EXL Service interview process for freshers usually has 3-4 rounds. The most common rounds in the EXL Service interview process for freshers are Technical, Aptitude Test and HR.
How to prepare for EXL Service Business Analyst interview for freshers?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at EXL Service. The most common topics and skills that interviewers at EXL Service expect are Business Analysis, Requirement Gathering, SQL, Accounting and Analytics.
What are the top questions asked in EXL Service Business Analyst interview for freshers?

Some of the top questions asked at the EXL Service Business Analyst interview for freshers -

  1. Doors were numbered from 1-100 and first time I close all doors next I open doo...read more
  2. If I have 333 digits to number pages of a book, How many pages can I numbe...read more
  3. Explain about ERP, it's advantages(a software which I worked upon during my int...read more
What are the most common questions asked in EXL Service Business Analyst HR round for freshers?

The most common HR questions asked in EXL Service Business Analyst interview are for freshers -

  1. Where do you see yourself in 5 yea...read more
  2. Why should we hire y...read more
How long is the EXL Service Business Analyst interview process?

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.

Overall Interview Experience Rating

4.7/5

based on 7 interview experiences

Difficulty level

Easy 17%
Moderate 83%

Duration

Less than 2 weeks 100%
View more
EXL Service Business Analyst Salary
based on 1.2k salaries
₹7.8 L/yr - ₹15 L/yr
12% more than the average Business Analyst Salary in India
View more details

EXL Service Business Analyst Reviews and Ratings

based on 171 reviews

3.3/5

Rating in categories

3.0

Skill development

3.4

Work-life balance

2.8

Salary

3.6

Job security

3.2

Company culture

2.6

Promotions

3.0

Work satisfaction

Explore 171 Reviews and Ratings
Business Analyst

Bangalore / Bengaluru,

Delhi/Ncr

3-8 Yrs

₹ 5-15 LPA

Explore more jobs
Senior Executive
4.5k salaries
unlock blur

₹2.5 L/yr - ₹7.5 L/yr

Assistant Manager
3.3k salaries
unlock blur

₹6 L/yr - ₹14 L/yr

Senior Associate
2.6k salaries
unlock blur

₹2.3 L/yr - ₹7 L/yr

Lead Assistant Manager
2k salaries
unlock blur

₹10.6 L/yr - ₹18.1 L/yr

Executive
2k salaries
unlock blur

₹1.7 L/yr - ₹5 L/yr

Explore more salaries
Compare EXL Service with

Genpact

3.7
Compare

DXC Technology

3.6
Compare

Mphasis

3.4
Compare

Sutherland Global Services

3.5
Compare
write
Share an Interview