EXL Service Analyst Interview Questions and Answers

Q1. Tell me something about yourself.
Ans. 
I am a detail-oriented analyst with a passion for data-driven decision-making and a background in finance and market research.
• Strong analytical skills: I have experience using tools like Excel and SQL to analyze large datasets.

• Project experience: I worked on a market research project that helped a client identify new growth opportunities.

• Team collaboration: I enjoy working in teams and have successfully collaborated wi...read more
Answered by AI
Add your answer
Q2. What are your hobbies
Add your answer

Basic aptitude round of 45 minutes, questions were easy, but speed was a necessity.

Q1. Easy leetcode questions were asked. Questions related to project, and some oops questions.
Add your answer

Q1. This was my last round by a AVP. Case study, hr questions, puzzles, everything was asked.
Add your answer

Q1. Top 3 Salaries in each department using SQL
Ans. 
Retrieve the top 3 salaries from each department using SQL with ranking functions.
• Use the ROW_NUMBER() function to assign a unique rank to each salary within its department.

• Partition the results by department to ensure ranking is done within each department.

• Filter the results to include only the top 3 salaries per department using a common table expression (CTE) or subquery.
Answered by AI
Add your answer
Q2. Difference between rank & dense rank and related questions
Add your answer

Case studies related to marketing and guesstimates were asked

Q1. Basic SQL N PYSPARK TEST
Add your answer
Q2. General scenario based question
Add your answer

Q1. Advance SQL question n pyspark concepts
Add your answer

1 hour excel test and typing

General Assessment question

Q1. About experiance
Add your answer

Q1. Ask about geography. TC areas , Fare rules, Fare construction ladder.
Add your answer
Q2. Capital of Australia. About per fare component penalty situation.
Add your answer
Q3. Why did you left your last organisation?
Ans. 
I was seeking new challenges and opportunities for growth.
• I felt that I had reached a plateau in my career and wanted to explore new avenues.

• I was looking for a company that aligned better with my values and career goals.

• I wanted to work in a more dynamic and innovative environment.

• I had completed the projects assigned to me and was ready for a new challenge.

• I wanted to learn new skills and take on more responsibilitie...read more
Answered by AI
Add your answer
Q4. Why you want to join EXL ?
Ans. 
I am excited to join EXL because of its reputation for innovation and growth in the industry.
• I am impressed by EXL's track record of delivering cutting-edge solutions to clients.

• I am excited about the opportunity to work with a talented team of professionals.

• I believe that EXL's focus on innovation and growth aligns with my own career goals.

• I am confident that EXL will provide me with the resources and support I need t...read more
Answered by AI
Add your answer