10+ TCS ETL Developer Interview Questions & Answers | Complete Prep Guide 2025

TCS ETL Developer Interview Experiences

7 interviews found

ETL Developer Interview Questions & Answers

Anonymous

posted on 6 Dec 2024

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Technical

(4 Questions)

Q1. Lookup ,router,joiner

Add your answer

Q2. Different types of caches

Add your answer

Q3. Scd1 and scd2 implementation

Add your answer

Q4. Fact and dimensions tables and different data modelling

Add your answer

Round 2 - HR

(1 Question)

Q1. Salary discuss and location discussion

Add your answer

ETL Developer Interview Questions & Answers

Vikash Kumar

posted on 21 Oct 2024

Interview experience

Excellent

Difficulty level

Easy

Process Duration

Result

Selected

I applied via Campus Placement and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Technical

(2 Questions)

Q1. Lookup transformation

Add your answer

Q2. Joiner transformation

Add your answer

ETL Developer Interview Questions & Answers

Anonymous

posted on 29 Feb 2024

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Result

Selected

I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical

(1 Question)

Q1. Informatica power centre transformation questions

Add your answer

What people are saying about TCS

View All

I have got an offer of 34 LPA from TCS and Capgemini . I have 11 years of experience , Azure Developer. Can you please guide / suggest which company should I join . I am confused since both are offering the s... read more

Got a question about TCS?

Ask anonymously on communities.

ETL Developer Interview Questions & Answers

Anonymous

posted on 10 Apr 2022

I applied via Naukri.com and was interviewed in Mar 2022. There was 1 interview round.

Round 1 - Technical

(1 Question)

Q1. Oracle DWH concept Informatica

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Just apply .you may not be the best candidate or have all the require qulification ,but you 'll never
get a job you don't try

ETL Developer Interview Questions & Answers

Anonymous

posted on 27 May 2022

I applied via Recruitment Consulltant and was interviewed in Nov 2021. There were 2 interview rounds.

Round 1 - Technical

(1 Question)

Q1. General, project overview, technology stack, scenario based questions, challenges and experiences

Add your answer

Round 2 - HR

(1 Question)

Q1. General, salary negotiation

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be genuine and share your experiences

ETL Developer Interview Questions & Answers

Anonymous

posted on 27 May 2022

I applied via Recruitment Consulltant and was interviewed in Nov 2021. There were 2 interview rounds.

Round 1 - Technical

(1 Question)

Q1. Introduction, projects worked, technology stack, scenario based questions, challenges

Add your answer

Round 2 - HR

(1 Question)

Q1. Salary negotiation and general discussion

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay confident and be open with the answers.

ETL Developer Interview Questions & Answers

Anonymous

posted on 31 Aug 2023

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

Selected

I applied via Campus Placement and was interviewed before Aug 2022. 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 Resume tips

Round 2 - Coding Test

2 coding questions, 1 hr and Aptitude questions are also clubbed into other section.

Round 3 - HR

(3 Questions)

Q1. Are flexible with location

Ans. Yes, I am flexible with location

Answered Anonymously

Add your answer

Q2. Are you ok if we give you testing project

Ans.

Yes, I am open to taking on a testing project as part of my role as an ETL Developer.

I have experience with testing tools and methodologies in my previous roles.
I understand the importance of testing in ensuring data accuracy and quality.
Taking on a testing project will help me improve my skills and knowledge in ETL development.

Answered by AI

Add your answer

Q3. Are you flexible with working hours

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - You will get great experience in TCS. If you are 30+yrs age and want stability then join TCS.

Interview questions from similar companies

ETL Developer Interview Questions & Answers

HCLTech

Anonymous

posted on 11 Aug 2024

Interview experience

Poor

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

No response

I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - One-on-one

(1 Question)

Q1. Which version of talend you are using

Ans.

I am using Talend version 7.3.1 for ETL development.

I am currently using Talend version 7.3.1 for ETL development.
The specific version of Talend being used is 7.3.1.
Talend 7.3.1 offers various features and improvements for ETL processes.

Answered by AI

Add your answer

Skills evaluated in this interview

ETL Developer Interview Questions & Answers

Accenture

Anonymous

posted on 8 Sep 2021

Interview Questionnaire

4 Questions

Q1. Whats is mapping

Ans.

Mapping is the process of defining the relationship between source and target data in ETL.

Mapping involves identifying the source and target data structures.
It also involves defining the transformation rules to be applied to the source data.
Mappings can be simple or complex depending on the complexity of the data.
Mapping is a critical step in ETL as it determines the accuracy and completeness of the data in the target

Answered by AI

Add your answer

Q2. What is sesson

Ans.

Session refers to a period of time during which a user interacts with a computer system or application.

A session is created when a user logs into a system or application.
It is used to track user activity and maintain user-specific data.
Sessions can be terminated manually or automatically after a certain period of inactivity.
Session management is important for security purposes.
Examples of session management techniques

Answered by AI

Add your answer

Q3. Which role u did

Add your answer

Q4. Oracle sqi pl sqi

Add your answer

ETL Developer Interview Questions & Answers

Infosys

Anonymous

posted on 15 Jul 2022

Round 1 - Technical

(2 Questions)

Q1. About project worked on

Add your answer

Q2. Skill set questions based on what you are worked on

Add your answer

Round 2 - HR

(1 Question)

Q1. Compansation Discussion

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident for what you have on the skillset. Go through the concepts before going to interview with multiple sites.

TCS Interview FAQs

How many rounds are there in TCS ETL Developer interview?

TCS interview process usually has 1-2 rounds. The most common rounds in the TCS interview process are Technical, HR and Resume Shortlist.

How to prepare for TCS 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 TCS. The most common topics and skills that interviewers at TCS expect are ETL, Informatica, SQL, Python and Data Warehousing.

What are the top questions asked in TCS ETL Developer interview?

Some of the top questions asked at the TCS ETL Developer interview -

Are you ok if we give you testing proj...read more
Fact and dimensions tables and different data modell...read more
Are flexible with locat...read more

Tell us how to improve this page.

TCS Interviews By Designations

Interview Questions for Popular Designations

TCS ETL Developer Interview Process

based on 6 interviews

2 Interview rounds

Technical Round
HR Round

Infosys ETL Developer Interview Questions

3.6

• 5 Interviews

Cognizant ETL Developer Interview Questions

3.8

• 5 Interviews

Capgemini ETL Developer Interview Questions

3.7

• 3 Interviews

HCLTech ETL Developer Interview Questions

3.5

• 2 Interviews

Accenture ETL Developer Interview Questions

3.8

• 2 Interviews

HCL Group ETL Developer Interview Questions

3.6

• 2 Interviews

Tech Mahindra ETL Developer Interview Questions

3.5

• 1 Interview

LTIMindtree ETL Developer Interview Questions

3.8

• 1 Interview

Mphasis ETL Developer Interview Questions

3.4

• 1 Interview

NTT Data ETL Developer Interview Questions

3.9

• 1 Interview

View all

Vidyalankar Institute of Technology, Mumbai Placement Questions

81 Interviews

National Institute of Technology (NIT), Warangal Placement Questions

76 Interviews

Vellore Institute of Technology (VIT) Placement Questions

19 Interviews

SRM university (SRMU) Placement Questions

16 Interviews

Anna University Placement Questions

15 Interviews

Sastra University Placement Questions

15 Interviews

SRM Institute of Science & Technology, Chennai Placement Questions

12 Interviews

View all

TCS ETL Developer Salary

based on 1.4k salaries

₹2.4 L/yr - ₹9.2 L/yr

13% less than the average ETL Developer Salary in India

View more details

TCS Salaries in India

System Engineer 1.1L salaries	₹0 L/yr - ₹0 L/yr
IT Analyst 66.6k salaries	₹0 L/yr - ₹0 L/yr
AST Consultant 51.5k salaries	₹0 L/yr - ₹0 L/yr
Assistant System Engineer 29.8k salaries	₹0 L/yr - ₹0 L/yr
Associate Consultant 29.5k salaries	₹0 L/yr - ₹0 L/yr