AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
EXL
Service
Compare
Filter interviews by
EXL Service Business Analyst Interview Questions and Answers for Freshers
10 Interview questions
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...
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 ...
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
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...
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 ...
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
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
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.
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 ...
Inner joins, outer joins, and left join are types of SQL joins used to combine data from multiple tables.
Inner join returns only the matching records from both tables.
Outer join returns all records from both tables, including non-matching records.
Left join returns all records from the left table and the matching records from the right table.
Example: INNER JOIN customers ON orders.customer_id = customers.customer_i...
EXL Service Business Analyst Interview Experiences for Freshers
16 interviews found
Anonymous
Selected
I applied via Campus Placement and was interviewed in Oct 2023. There were 3 interview rounds.
Basic aptitude questions
(2 Questions)
- Q1. About the projects and SQL queries
- Q2. Puzzles and guesstimates
(2 Questions)
- Q1. Family background
- Ans.
I come from a close-knit family that values education and hard work, with diverse backgrounds and strong support for each other.
My parents are both educators, which instilled a love for learning in me from a young age.
I have two siblings; we often collaborate on projects and support each other's career goals.
Family gatherings are frequent, where we share experiences and celebrate achievements.
My grandparents immigrated...
- Q2. Some technical questions were also asked
Ankit Srivastava
DATA interpretation , reasoning and some data analysis question MCQ type.
(1 Question)
- Q1. General python questions.
(1 Question)
- Q1. Question was related to my projects
(1 Question)
- Q1. General HR question , weakness , where do you see yourself in EXL in long run.
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed in Aug 2022. There were 4 interview rounds.
Basic aptitude questions - comprehensions, basic mathematics and reasoning questions
(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...
(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...
Interview Preparation Tips
Enhance your coding skills in any language possible
Efficiency in SQL would definitely help
Selected
I applied via Referral and was interviewed before Aug 2023. There were 2 interview rounds.
Basic questions on aptitude
(1 Question)
- Q1. Case studies and sql
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Mar 2023. There were 3 interview rounds.
(1 Question)
- Q1. General screening
(1 Question)
- Q1. Sql and tableau basic questions
(1 Question)
- Q1. Business and technical both more on sql and tableau experience
Selected
I applied via LinkedIn and was interviewed before Feb 2023. There was 1 interview round.
(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...
- 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...
- Q3. Meaning of success for you
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Dec 2021. There were 4 interview rounds.
Basic to medium level aptitude questions not too tough
(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 ...
(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.
Interview Preparation Tips
Good knowledge of SQL
Keep everything clear about your resume
Selected
I applied via Campus Placement and was interviewed before Jan 2022. There were 4 interview rounds.
The first round usually contains aptitude, data interpretation and verbal.
Need to be quick because we hardly get 90sec for a question.
(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...
(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
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 Questionnaire
2 Questions
- Q1. Where do you see yourself in 5 years
- Q2. What are your strengths
Interview Preparation Tips
Top trending discussions
EXL Service Interview FAQs
Some of the top questions asked at the EXL Service Business Analyst interview for freshers -
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.
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
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 7 interview experiences
Difficulty level
Duration
Business Analyst Interview Questions from Similar Companies
EXL Service Business Analyst Reviews and Ratings
based on 171 reviews
Rating in categories
|
Senior Executive
4.5k
salaries
|  ₹2.5 L/yr - ₹7.5 L/yr |
|
Assistant Manager
3.6k
salaries
| ₹6 L/yr - ₹12.6 L/yr |
|
Senior Associate
2.6k
salaries
| ₹2.3 L/yr - ₹6.8 L/yr |
|
Lead Assistant Manager
2k
salaries
| ₹10.5 L/yr - ₹18.2 L/yr |
|
Executive
1.9k
salaries
| ₹1.7 L/yr - ₹5 L/yr |
Genpact
DXC Technology
Mphasis
Optum Global Solutions
- Home >
- Interviews >
- EXL Service Interview Questions >
- EXL Service Interview Questions for Fresher
