EXL Service Business Analyst Interview Questions, Process, and Tips

Q1. Asked questions on basic SAS, SQL and Power BI.
Add your answer
Q2. What is proc report?
Ans. 
proc report is a SAS procedure used for creating tabular reports.
• proc report is used to summarize and present data in a tabular format.

• It allows users to define the structure and appearance of the report.

• Users can specify variables, statistics, and formatting options.

• It supports grouping, sorting, and summarizing data.

• Output can be generated in various formats like HTML, PDF, and RTF.

• Example: proc report data=sales; co
Answered by AI
Add your answer
Q3. How can you remove duplicates?
Ans. 
To remove duplicates from an array of strings, use a hash set or sort the array and iterate to remove duplicates.
• Create a hash set and iterate through the array, adding each element to the set. If the element already exists in the set, remove it from the array.

• Sort the array using a sorting algorithm like quicksort or mergesort. Then iterate through the sorted array and remove any duplicates by comparing adjacent eleme
Answered by AI
Add your answer

Q1. Technical discussion round focused on SAS and SQL as well as your work experience on Data Analyst profile.
Add your answer
Q2. Sql query and joins
Add your answer

Q1. Salary negotiation and offer
Add your answer

Basic Aptitude, time and distance, time and work, basic class 10 maths

Q1. Guesstimate - detergent used in hospital in a day
Add your answer
Q2. Position of responsibility
Ans. 
I have held multiple positions of responsibility in my previous roles, including leading project teams and managing client relationships.
• Led a project team to successfully implement a new software system

• Managed client relationships and ensured customer satisfaction

• Served as a mentor to junior team members and provided guidance on complex projects
Answered by AI
Add your answer

Q1. Guestimate - flights in mumbai airport in a day
Add your answer
Q2. What is that makes you a suitable candidate and why EXL
Ans. 
I am a suitable candidate for the Business analyst role at EXL due to my strong analytical skills, experience in data analysis, and ability to drive business insights.
• I have a strong background in data analysis and have successfully implemented data-driven strategies in my previous roles.

• I possess excellent analytical skills which enable me to interpret complex data and provide valuable insights for decision-making.

• I h...read more
Answered by AI
Add your answer

Q1. About scrum, product backlog, requirement handling
Add your answer
Q2. Some scenario based questions- if manager is planning the sprint and there is no scrum master in organization, how do you as BA make sure that product quality is not compromised.
Add your answer

Apti and maths and English mcq

Puzzles of geeksforgeeks

Q1. SQL join types and difference
Ans. 
SQL join types include inner join, left join, right join, and full outer join.
• Inner join returns rows when there is at least one match in both tables.

• Left join returns all rows from the left table and the matched rows from the right table.

• Right join returns all rows from the right table and the matched rows from the left table.

• Full outer join returns all rows when there is a match in either table.
Answered by AI
Add your answer

Aptitude test consists of 35 mins in 40 mins

Q1. The interviewer is quite good and asked about SQL and projects in the resume.and he asks about the case study and that's it and I have shortlisted for second and final round but there i was failed
Add your answer

Q1. This was tough the interviewer was not good she asked many difficult questions in the case study and puzzles
Add your answer

Basic aptitude questions

Q1. About the projects and SQL queries
Add your answer
Q2. Puzzles and guesstimates
Add your answer

Q1. Family background
Add your answer
Q2. Some technical questions were also asked
Add your answer