EXL Service interview experience Real time questions & tips from candidates to crack your interview

Business Analyst

EXL Service

1 rounds | 3 Coding problems

Anonymous

Fresher | Aug 2021

Rejected

Interview preparation journey

Preparation

Duration: 5 months

Topics: SQL, DBMS, Tableu, Data Structures, Algorithms, Programming

Tip

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : If you know sql, tableau and have good practice of case study question, you will have good chances to convert

Application process

Where: Campus

Eligibility: Above 7 CGPA

Resume tip

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Interview rounds

Round

Medium

Video Call

Duration45 minutes

Interview date27 Aug 2021

Coding problem3

This was a technical round.

1. DBMS Question

Difference between Inner Join and Left join

Problem approach

INNER JOIN gets all records that are common between both tables based on the supplied ON clause.

LEFT JOIN gets all records from the LEFT linked and the related record from the right table ,but if you have selected some columns from the RIGHT table, if there is no related records, these columns will contain NULL.

2. DBMS Question

What is Group By function in SQL?

Problem approach

The GROUP BY statement groups rows that have the same values into summary rows. The GROUP BY statement is often used with aggregate functions (COUNT(), MAX(), MIN(), SUM(), AVG()) to group the result-set by one or more columns.

3. Guesstimate Question

If a company want to get into umbrella business in your city , number of umbrella it should manufacture?

Problem approach

Tip 1: Take a step back and think. Request the interviewers to give you some time, perhaps 30 seconds, if you can’t think in 5. Pausing for 5 without such a request is also acceptable. Create a mind map of the exhaustive list of parameters you can consider.

Tip 2: Clarify the Doubts. So you’ve thought of all the parameters that came to your mind. Now go on and clarify what has been asked. This helps the interviewer judge your ability to go beyond the obvious and look at the bigger picture.

Tip 3: Voice Your Thoughts. You’re considering the parameters in your head and are a complete pro at mental calculations but the interviewer can’t get into your head. The panel has to know how you think to give you the job. The numbers by themselves aren’t as important as the approach is. So speak it out loud, structured.