AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
EXL Service
Compare
Filter interviews by
Clear (1)
EXL Service Senior Consultant Interview Questions, Process, and Tips
Top EXL Service Senior Consultant Interview Questions and Answers
- Q1. What is the process in SAS to find the date difference and remove spaces from a string?
- Q2. What are the differences between a revolver and a transactor?
- Q3. How to get the last row of any SAS dataset
EXL Service Senior Consultant Interview Experiences
11 interviews found
Anonymous
Selected
(1 Question)
- Q1. How to get the last row of any SAS dataset
- Ans.
Use the OBS option in a SET statement to read the last observation of a SAS dataset.
Use the OBS option in a SET statement followed by the keyword 'END' to read the last observation of a SAS dataset.
For example, to read the last observation of a dataset named 'mydata', use the following code: data lastobs; set mydata(obs=last end=last); run;
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Aug 2023. There was 1 interview round.
(2 Questions)
- Q1. KPI's for CLI and CLD
- Ans.
Key Performance Indicators (KPIs) for Customer Lifetime Income (CLI) and Customer Lifetime Duration (CLD)
CLI KPIs could include average revenue per customer, customer retention rate, customer lifetime value
CLD KPIs could include average customer lifespan, customer churn rate, customer engagement metrics
Tracking CLI and CLD KPIs can help measure the financial impact and longevity of customer relationships
- Q2. Credit score variables and impact on strategy
- Ans.
Credit score variables impact strategy by influencing lending decisions and interest rates.
Credit score variables include payment history, credit utilization, length of credit history, types of credit used, and new credit accounts.
Higher credit scores typically result in lower interest rates and more favorable lending terms.
Lenders use credit scores to assess risk and determine the likelihood of repayment.
Strategies ma...
Selected
I applied via Campus Placement and was interviewed before Nov 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Questions related to my work experience
- Q2. A case study on how to improve sales using website analytics management and email marketing
(2 Questions)
- Q1. Questions about past projects
- Q2. Case on use of analytics in a retail sector. How would you as a consultant, structure the whole process (as the job was for an assistant project manager)
Interview Preparation Tips
2. Clear thought process and ability to demonstrate learning nature is a good tool to have
What people are saying about EXL Service
Selected
I was interviewed before Feb 2024.
(2 Questions)
- Q1. What is the process in SAS to find the date difference and remove spaces from a string?
- Ans.
To find date difference in SAS, use INTCK function. To remove spaces from a string, use COMPRESS function.
To find date difference, use INTCK function with appropriate interval (e.g. 'day', 'week', 'month')
Example: date_diff = INTCK('day', start_date, end_date);
To remove spaces from a string, use COMPRESS function with 'k' modifier
Example: clean_string = COMPRESS(original_string, 'k');
- Q2. What are the differences between a revolver and a transactor?
- Ans.
Revolver and transactor are terms used in finance to describe different types of credit card users.
Revolver is someone who carries a balance on their credit card and pays interest on it, while a transactor pays off their balance in full each month.
Revolver users typically incur more interest charges over time, while transactors avoid paying interest by paying off their balance.
Revolver users may benefit from rewards pr...
EXL Service interview questions for designations
Selected
I applied via Naukri.com and was interviewed before Nov 2023. There were 3 interview rounds.
Basic SQL join and Python data wrangling questions.
(1 Question)
- Q1. Metrics that can be useful in a defined dataset.
- Ans.
Metrics such as mean, median, mode, standard deviation, and range can be useful in analyzing a defined dataset.
Mean: average value of the dataset
Median: middle value of the dataset when arranged in ascending order
Mode: most frequently occurring value in the dataset
Standard deviation: measure of the amount of variation or dispersion of a set of values
Range: the difference between the maximum and minimum values in the da
(1 Question)
- Q1. Salary discussion
Get interview-ready with Top EXL Service Interview Questions
Selected
I applied via Company Website and was interviewed before Sep 2023. There was 1 interview round.
(2 Questions)
- Q1. What are your biggest strengths and weaknesses?
- Ans.
My biggest strengths include strong analytical skills and effective communication. My weaknesses are sometimes being too detail-oriented and struggling with delegation.
Strengths: strong analytical skills
Strengths: effective communication
Weaknesses: being too detail-oriented
Weaknesses: struggling with delegation
- Q2. Have you led a team before?
- Ans.
Yes, I have led multiple teams in previous roles.
Led a team of 5 consultants in a project for a major client
Managed a team of analysts in developing a new data analytics tool
Coordinated a team of developers in implementing a software upgrade
(1 Question)
- Q1. All questions according to cv.
(1 Question)
- Q1. Managerial and technical
(1 Question)
- Q1. Behavioural question
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
(2 Questions)
- Q1. Rank vs dense rank
- Ans.
Rank assigns unique ranks to each distinct row, while dense rank assigns consecutive ranks to rows with the same values.
Rank function is used to assign a unique rank to each distinct row based on the specified column(s).
Dense rank function is used to assign consecutive ranks to rows with the same values, without any gaps.
For example, if we have scores of 90, 85, 85, 80, then rank would assign ranks as 1, 2, 2, 4 while
- Q2. Row level security
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Oct 2022. There were 3 interview rounds.
(1 Question)
- Q1. Technical question
(1 Question)
- Q1. Medium technical question
Selected
I was interviewed before May 2022.
(1 Question)
- Q1. Puzzle and Basic SQL AND Python Questions
(1 Question)
- Q1. Experience based questions
Interview Preparation Tips
EXL Service Interview FAQs
The duration of EXL Service Senior Consultant interview process can vary, but typically it takes about less than 2 weeks to complete.
Recently Viewed
DESIGNATION
INTERVIEWS
Trellix
No Interviews
INTERVIEWS
HSBC Group
No Interviews
DESIGNATION
INTERVIEWS
SPRINKLR
No Interviews
INTERVIEWS
Samsung
No Interviews
INTERVIEWS
Oracle
No Interviews
INTERVIEWS
Pon Pure Chemical
No Interviews
DESIGNATION
DESIGNATION
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 Senior Consultant Interview Process
based on 13 interviews
2 Interview rounds
- One-on-one Round - 1
- One-on-one Round - 2
Senior Consultant Interview Questions from Similar Companies
Fast track your campus placements
EXL Service Senior Consultant Reviews and Ratings
based on 91 reviews
Rating in categories
|
Senior Executive
4.3k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
3k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
2.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Lead Assistant Manager
1.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Executive
1.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Genpact
WNS
TCS
Infosys
- Home >
- Interviews >
- EXL Service Interview Questions >
- EXL Service Senior Consultant Interview Questions
