Add office photos
i
EXL Service
Compare
Filter interviews by
EXL Service Senior Business Analyst Interview Questions, Process, and Tips
Top EXL Service Senior Business Analyst Interview Questions and Answers
- Q1. Third highest salary insql
- Q2. Delete duplicate in sql
- Q3. Difference between totalytd and datesytd
EXL Service Senior Business Analyst Interview Experiences
14 interviews found
Anonymous
Selected
Relatively easy if you practice dsa
(1 Question)
- Q1. Basic DSA questions
(1 Question)
- Q1. Why do you want to join exl
- Ans.
I want to join EXL because of its reputation for innovation and excellence in the field of business analysis.
EXL has a strong reputation for innovation and excellence in the field of business analysis
I am impressed by EXL's track record of delivering high-quality solutions to clients
I believe that joining EXL will provide me with opportunities for professional growth and development
(1 Question)
- Q1. Salary expectations
(2 Questions)
- Q1. Difference between totalytd and datesytd
- Ans.
totalytd calculates the total year-to-date value, while datesytd calculates the year-to-date value based on specified dates.
totalytd sums up the values from the beginning of the year until the current date
datesytd calculates the sum of values within a specified date range for the year
totalytd is a predefined function in some programming languages like DAX in Power BI
datesytd requires specifying the start and end dates
- Q2. What is gateway
- Ans.
A gateway is a node on a network that serves as an entrance to another network.
Gateway acts as a bridge between different networks
It controls access to the network it is connected to
Examples include routers, switches, and firewalls
Skills evaluated in this interview
Good mcq on machine learning algo
(1 Question)
- Q1. SQL window function asked
paru dhingra
(2 Questions)
- Q1. Puzzle questions
- Q2. Statistics questions
It was fairly easy and out of 100 students, 40 were selected
(1 Question)
- Q1. Question around python, resume projects
Selected
I applied via Approached by Company and was interviewed before Dec 2023. There were 2 interview rounds.
(2 Questions)
- Q1. SQL windowing function
- Q2. Machine learning basic questions
(2 Questions)
- Q1. Hypothesis testing
- Q2. Sql
Selected
I applied via Naukri.com and was interviewed before May 2023. There were 4 interview rounds.
Advanced Sas question
(3 Questions)
- Q1. SAS MACROS, FIRST.ID AND LAST.ID, MERGE, SQL,PROCS, PROC UNIVARIATE
- Q2. Third highest salary insql
- Ans.
To find the third highest salary in SQL, you can use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' twice.
Use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' to find the highest salary.
Use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' and 'WHERE salary < (SELECT TOP 1 salary FROM table)' to find the second highest salary.
Use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' and 'WHE
- Q3. Delete duplicate in sql
- Ans.
Use the DISTINCT keyword in SQL to delete duplicates from a table.
Use the SELECT DISTINCT statement to retrieve unique rows from a table.
You can also use the GROUP BY clause with aggregate functions like COUNT() to remove duplicates.
Consider using the ROW_NUMBER() function to assign a unique number to each row and then filter out duplicates based on this number.
(1 Question)
- Q1. Marcos, procs in SAS
(1 Question)
- Q1. Salary expectation
Interview Preparation Tips
- Marcos, PROCS, SQL,
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Dec 2021. There were 5 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Discussion on salary and joining
- Q2. They were asked me scenario based questions for tableau and sql
- Q3. They were taking my technical round with tableau desktop and asked me to solved some questions
- Q4. Manager asked me some sql questions
Selected
I applied via campus placement at Indian Institute of Technology (IIT), Roorkee and was interviewed before Mar 2023. There were 3 interview rounds.
40 questions,45 minutes
(2 Questions)
- Q1. SQL, python, Excel
- Q2. Puzzles,guesstimates
(1 Question)
- Q1. Goal in life,why to join?, company related questions
I applied via Recruitment Consulltant and was interviewed before Sep 2021. There were 4 interview rounds.
(1 Question)
- Q1. Some basic questions about your old profile, skills u know
(2 Questions)
- Q1. Privious knowledge about the project, knowledge about your current skills, no need for syntax, they'll look how u approach
- Q2. 1. Pivot table queries and tableau related questions. Trend analysis
(1 Question)
- Q1. Final round with Project head or Sr. VP. They'll look into your perception about the process, your future aspirations.
Interview Preparation Tips
- Advanced Excel
- Macros
- VBA
- Tableau
- Power BI
- SQL
- MS Access
- Python
Top trending discussions
EXL Service Interview FAQs
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 Business Analyst Interview Process
based on 8 interviews
3 Interview rounds
- Aptitude Test Round
- Technical Round - 1
- Technical Round - 2
Senior Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
EXL Service Senior Business Analyst Reviews and Ratings
based on 78 reviews
Rating in categories
|
Senior Executive
4.3k
salaries
|  ₹0.9 L/yr - ₹7 L/yr |
|
Assistant Manager
2.9k
salaries
| ₹4.1 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.4 L/yr - ₹22 L/yr |
|
Executive
1.7k
salaries
| ₹1 L/yr - ₹5.5 L/yr |
Genpact
WNS
TCS
Infosys
- Home >
- Interviews >
- EXL Service Interview Questions >
- EXL Service Senior Business Analyst Interview Questions
