EXL Service Business Analyst Interview Questions, Process, and Tips

Medium level aptitude questions were asked

Q1. All about skills on resume and sql
Add your answer
Q2. Puzzles and guesstimates and about project
Add your answer

Q1. All about resume and behaviour questions asked
Add your answer
Q2. Wy do you want to join tis company
Add your answer

Round duration - 45 minutes
Round difficulty - Medium

This was a technical round.

Q1. What is the difference between Inner Join and Left Join in DBMS?
Ans. 
Inner Join returns only the matching rows between two tables, while Left Join returns all rows from the left table and the matching rows from the right table.
• Inner Join only includes rows that have matching values in both tables

• Left Join includes all rows from the left table, even if there are no matching rows in the right table

• Example: Inner Join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

• Example...read more
Answered by AI
Add your answer
Q2. What is the Group By function in SQL?
Ans. 
Group By function in SQL is used to group rows that have the same values into summary rows.
• Group By function is used with aggregate functions like COUNT, SUM, AVG, etc.

• It is used to summarize data by grouping rows based on specified columns.

• For example, SELECT department, COUNT(*) FROM employees GROUP BY department;
Answered by AI
Add your answer

Basic aptitude questions with DILR, QA and Varc

Q1. Describe your college project
Ans. 
Developed a web-based inventory management system for a retail company
• Used HTML, CSS, and JavaScript to create the user interface

• Implemented a database using MySQL to store product information

• Designed and implemented various features such as product search, order management, and reporting

• Conducted user testing and incorporated feedback to improve the system

• Collaborated with a team of developers and stakeholders to ensu
Answered by AI
Add your answer
Q2. One Guesstimate question
Add your answer

Q1. About your project and ML concepts
Add your answer

Q1. Most questions were based on ML concepts, few sql queries and a puzzle
Add your answer

Q1. Discussed about the salary expectation
Add your answer

Q1. Sql basic ,where ,groupby having partition ,join
Add your answer

Q1. Discussion on projects undertaken at college level,skill,
Add your answer