Register Now


Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.


Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

EXL Senior Consultant Interview Questions | Day 8

Topic – EXL Senior Consultant Interview Questions
Company – EXL Services
Designation – Senior Consultant
Salary – 35 to 45 LPA (depending upon current CTC, no stocks)
Experience – 5+ years of analytics experience
Number of Rounds – 3
EXL Senior Consultant Interview Questions

EXL Senior Consultant Interview Questions
EXL Senior Consultant Interview Questions

Interview at EXL

I was interviewed at EXL services for the Gurgaon location, the overall process was very smooth.
There were 3 rounds,
Round 1 – Technical where questions from SQL and Python were asked,
Round 2 – Case Study as well as a project discussion in detail.
Round 3 – Project discussion, experience in project development, documentation and leadership qualities

Round 1 – Technical Round

Since the designation was Senior Consultant, the SQL questions were not that hard, it was mostly moderate-level problems spread across ranking, window function, group by, and the explosion of data(unnesting).
Some of the questions that were asked are given below:-
– What is the difference between where and having?
– When will you use row_number(), rank(), and dense_rank() ?
– What are Presto and hive?
– Define the big data infrastructure of your organization.
– What is unnesting?
– How to convert from one data type to another?
– Define the complete software development life cycle.

You can find the answer to all these questions in our e-books (mentioned below). There was a brief discussion on the roles and responsibilities shared in the current organization.

Round 2 – Case Study and Project Discussion

The second round was mostly around Project discussion, I was asked to elaborate on any of the projects done in the current organization and one in the previous organization.
My project was on Time Series Forecasting and NLP, so questions were asked on statistics as well as R (language used in the project).
The following are the questions asked in the interview:-
– Define ARIMA
– How do you check the value of p,d,q in ARIMA model?
– Why did you choose ARIMA?
– What is Linear Regression? Why did you not try it in your project?
– What is the p-value?
– What is correlation?
– What is multicollinearity?

NLP questions

NLP questions were mostly around word correlation and cleaning of data in R.
– What is tf-idf?
– Why do we need to use idf?
– What is bi-gram?
– What is word correlation? How did it help in your project?
– What challenges did you face in cleaning the data?

Most of the questions were descriptive in nature and you would get a good amount of time to answer these. Make sure to keep sharing your thoughts and logic in the way of answering the question

Round 3 – Project Discussion and Leadership values

This round was taken by the AVP of EXL and it was mostly around your leadership values, how you deal with project management, how you interact with your juniors, and your experience with creating RFP(Request for proposal), and documentation.
In my previous experience, I had a good amount of experience on working on RFPs and creating documentation, taking learning hours, etc. So, this was an easy round. I was again asked to elucidate a project in brief.

Result – The selection was confirmed in a couple of days, the complete recruitment process took somewhere around 7 working days.

We have included the above-mentioned questions in our bundle booked below. You can comment your answer or read/learn from the 23 e-book bundle

The Data Monk Interview Books – Don’t Miss

Now we are also available on our website where you can directly download the PDF of the topic you are interested in. On Amazon, each book costs ~299, on our website we have put it at a 60-80% discount. There are ~4000 solved interview questions prepared for you.

10 e-book bundle with 1400 interview questions spread across SQL, Python, Statistics, Case Studies, and Machine Learning AlgorithmsIdeal for 0-3 years experienced candidates

23 E-book with ~2000 interview questions spread across AWS, SQL, Python, 10+ ML algorithms, MS Excel, and Case StudiesComplete Package for someone between 0 to 8 years of experience (The above 10 e-book bundle has a completely different set of e-books)

12 E-books for 12 Machine Learning algorithms with 1000+ interview questionsFor those candidates who want to include any Machine Learning Algorithm in their resume and to learn/revise the important concepts. These 12 e-books are a part of the 23 e-book package

Individual 50+ e-books on separate topics

Important Resources to crack interviews (Mostly Free)

There are a few things that might be very useful for your preparation

The Data Monk Youtube channel – Here you will get only those videos that are asked in interviews with Data Analysts, Data Scientists, Machine Learning Engineers, Business Intelligence Engineers, Analytics managers, etc.

Go through the watchlist which makes you uncomfortable:-

All the list of 200 videos

Complete Python Playlist for Data Science

Company-wise Data Science Interview Questions – Must Watch

All important Machine Learning Algorithm with code in Python

Complete Python Numpy Playlist

Complete Python Pandas Playlist

SQL Complete Playlist

Case Study and Guesstimates Complete Playlist

Complete Playlist of Statistics

Keep Learning !!


About TheDataMonkGrand Master

I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)

Follow Me