Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by EXL Service Team. If you also belong to the team, you can get access from here

EXL Service Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

EXL Service ETL Developer Interview Questions, Process, and Tips

Updated 4 Jun 2021

EXL Service ETL Developer Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. 1) Explain about your project
  • Q2. 2) for each loop container
  • Ans. 

    For Each Loop Container is used to iterate through a set of objects or files in SSIS packages.

    • Used to perform repetitive tasks on a set of objects or files

    • Can be used to loop through files in a directory or rows in a table

    • Requires a data source and a variable to store the current object or file

    • Can be configured to run in parallel or sequentially

  • Answered by AI
  • Q3. 3) SCD Type 2 dimension used in your old project
  • Ans. 

    SCD Type 2 is used to maintain historical data in a dimension table.

    • SCD Type 2 is used to track changes in dimension attributes over time.

    • It creates a new record for each change and maintains a history of all changes.

    • It includes additional columns like start date, end date, and version number.

    • Example: Employee table with changes in job title, salary, and department over time.

    • It helps in analyzing trends and making info

  • Answered by AI
  • Q4. 4) joins in SQL
  • Ans. 

    Joins are used in SQL to combine data from two or more tables based on a related column.

    • Joins are used to retrieve data from multiple tables.

    • Common types of joins are inner join, left join, right join, and full outer join.

    • Joins are performed using the JOIN keyword and specifying the tables to join and the columns to join on.

    • Joins can be used to filter data based on a related column.

    • Joins can also be used to combine dat

  • Answered by AI
  • Q5. 5) different between truncate, delete and drop
  • Ans. 

    Difference between truncate, delete and drop

    • Truncate removes all data from a table but keeps the structure

    • Delete removes specific rows from a table

    • Drop removes the entire table and its structure

    • Truncate and drop cannot be rolled back, but delete can be

    • Truncate is faster than delete as it does not log individual row deletions

  • Answered by AI
  • Q6. 6) what is Normalization
  • Ans. 

    Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalization involves breaking down a table into smaller tables to reduce redundancy.

    • It helps to avoid data inconsistencies and anomalies.

    • Normalization is achieved through a series of normal forms, such as first normal form (1NF), second normal form (2NF), and so on.

    • Each normal form has specific rules that mus...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared at SQL, SSIS basics and project flow

Skills evaluated in this interview

Interview questions from similar companies

I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Simple basic matha

Round 2 - HR 

(6 Questions)

  • Q1. What are your salary expectations?
  • Ans. 

    I am open to discussing salary based on the responsibilities and expectations of the role.

    • Focus on the value you can bring to the company rather than a specific number

    • Research the average salary range for similar positions in the industry and location

    • Consider your experience, skills, and qualifications when determining your salary expectations

    • Be prepared to negotiate and discuss other benefits besides salary

  • Answered by AI
  • Q2. Share details of your previous job.
  • Ans. 

    I worked as a Sales Associate at XYZ Company.

    • Responsible for assisting customers in finding and purchasing products.

    • Managed inventory and restocked shelves to ensure product availability.

    • Provided excellent customer service and resolved any issues or complaints.

    • Achieved sales targets by upselling and cross-selling products.

    • Collaborated with team members to create attractive product displays.

    • Utilized POS system to proces...

  • Answered by AI
  • Q3. Why should we hire you?
  • Ans. 

    I have the necessary skills, experience, and passion to excel in this role.

    • I have a strong educational background and relevant work experience.

    • I am a quick learner and have a proven track record of adapting to new environments.

    • I am highly motivated and dedicated to delivering high-quality work.

    • I possess excellent communication and teamwork skills.

    • I am passionate about the industry and committed to continuous learning a

  • Answered by AI
  • Q4. Where do you see yourself in 5 years?
  • Ans. 

    In 5 years, I see myself as a Senior Associate, leading a team and contributing to the growth and success of the company.

    • Advancing to a Senior Associate role

    • Leading a team and mentoring junior associates

    • Contributing to the growth and success of the company

    • Continuing to develop my skills and knowledge in the field

  • Answered by AI
  • Q5. What are your strengths and weaknesses?
  • Ans. 

    My strengths include strong communication skills, attention to detail, and ability to work well in a team. My weaknesses include being overly critical of my own work and sometimes struggling with time management.

    • Strength: Strong communication skills

    • Strength: Attention to detail

    • Strength: Ability to work well in a team

    • Weakness: Being overly critical of my own work

    • Weakness: Struggling with time management

  • Answered by AI
  • Q6. Tell me about yourself.
  • Ans. 

    I am a highly motivated and experienced professional with a strong background in the field.

    • I have a Bachelor's degree in Business Administration.

    • I have worked as an Associate at XYZ Company for the past 3 years.

    • I am skilled in data analysis and problem-solving.

    • I have successfully managed multiple projects and achieved significant results.

    • I am a team player and have excellent communication skills.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Startup in Kolkata. Work life balance is good. Average job security.

I applied via Campus Placement and was interviewed before Feb 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Financial statements analysis, valuation principles and ratios
Round 2 - One-on-one 

(1 Question)

  • Q1. Ratios, Economy and capital markets

Interview Preparation Tips

Interview preparation tips for other job seekers - Incase of freshers they test on your financial accounting fundamentals, valuation concepts (DCF, EV, WACC etc.). Good understanding about capital markets and know how on current affairs would do help.

Interview Questionnaire 

1 Question

  • Q1. About your self,knowledge of excel,

Interview Preparation Tips

Interview preparation tips for other job seekers - Give a answer confidently and don't take a more time to give answer

I applied via Naukri.com and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. They asked me about digital marketing and e commerce

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep calm and try to comfortable

I applied via Referral and was interviewed before Feb 2021. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What is EV and its formulae
  • Ans. 

    EV stands for Enterprise Value, which is the total value of a company's equity and debt.

    • EV = Market Capitalization + Total Debt - Cash and Cash Equivalents

    • It is used to determine the total value of a company, including its debt

    • EV/EBITDA is a common valuation metric that compares a company's EV to its EBITDA

    • EV/Sales is another common valuation metric that compares a company's EV to its annual sales

    • EV can be used to comp...

  • Answered by AI
  • Q2. Format of income statement
  • Ans. 

    The income statement shows a company's revenues and expenses over a specific period of time.

    • The income statement is also known as the profit and loss statement.

    • It includes revenues, cost of goods sold, gross profit, operating expenses, and net income.

    • Revenues are the money a company earns from selling its products or services.

    • Cost of goods sold is the cost of producing or purchasing the products or services sold.

    • Gross ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - general finance related questions

I applied via Naukri.com and was interviewed before May 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 
Round 3 - Aptitude Test 

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview process at Acuity Knowledge partners.

I applied via LinkedIn and was interviewed before May 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. What is esg? What is annual report
  • Ans. 

    ESG stands for Environmental, Social, and Governance. Annual report is a document that provides information about a company's financial performance and operations over the past year.

    • ESG refers to the three central factors in measuring the sustainability and ethical impact of an investment in a company or business.

    • Environmental factors include a company's impact on the environment, such as carbon emissions and waste man...

  • Answered by AI
  • Q2. How do you see yourself in 5 years?

Interview Preparation Tips

Interview preparation tips for other job seekers - Very bad. Ask about our education. Passed the interview, but didn't called back

I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Tell me about your self.
  • Q2. Find percentage of a number (I did not remember the exact number)
  • Ans. 

    To find the percentage of a number, multiply the number by the percentage and divide by 100.

    • To find 25% of 80, multiply 80 by 25 and divide by 100: (80 x 25) / 100 = 20

    • To find 75% of 120, multiply 120 by 75 and divide by 100: (120 x 75) / 100 = 90

  • Answered by AI
  • Q3. Situational base questions

Interview Preparation Tips

Interview preparation tips for other job seekers - According to me l really like the company, my experience was very good. If I'm talking about the interview that was easy they wanted to check my communication skill.

I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About yourself, previous company job role, qualifications, my dreams, hobbies.

Interview Preparation Tips

Interview preparation tips for other job seekers - Speak Confidently and keep your answers on point.

EXL Service Interview FAQs

How to prepare for EXL Service ETL Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at EXL Service. The most common topics and skills that interviewers at EXL Service expect are ETL, AWS, Python, SQL and Algorithms.
What are the top questions asked in EXL Service ETL Developer interview?

Some of the top questions asked at the EXL Service ETL Developer interview -

  1. 3) SCD Type 2 dimension used in your old proj...read more
  2. 5) different between truncate, delete and d...read more
  3. 6) what is Normalizat...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

S&P Global Interview Questions
4.1
 • 279 Interviews
Mu Sigma Interview Questions
2.6
 • 233 Interviews
Access Healthcare Interview Questions
3.9
 • 214 Interviews
Straive Interview Questions
3.4
 • 181 Interviews
AGS Health Interview Questions
4.0
 • 161 Interviews
Nielsen Interview Questions
3.6
 • 117 Interviews
Kantar Interview Questions
3.5
 • 98 Interviews
Netscribes Interview Questions
2.8
 • 84 Interviews
View all
EXL Service ETL Developer Salary
based on 7 salaries
₹7.5 L/yr - ₹15 L/yr
47% more than the average ETL Developer Salary in India
View more details
Senior Executive
4.4k salaries
unlock blur

₹0.9 L/yr - ₹7.2 L/yr

Assistant Manager
3.1k salaries
unlock blur

₹4.2 L/yr - ₹15 L/yr

Senior Associate
2.4k salaries
unlock blur

₹1.2 L/yr - ₹8 L/yr

Lead Assistant Manager
1.9k salaries
unlock blur

₹6.5 L/yr - ₹23 L/yr

Executive
1.8k salaries
unlock blur

₹1 L/yr - ₹5.5 L/yr

Explore more salaries
Compare EXL Service with

Genpact

3.8
Compare

Access Healthcare

3.9
Compare

S&P Global

4.1
Compare

AGS Health

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview