Add office photos
i
TCS
Compare
Filter interviews by
TCS ETL Developer Interview Questions and Answers
TCS ETL Developer Interview Experiences
7 interviews found
Anonymous
Selected
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
(4 Questions)
- Q1. Lookup ,router,joiner
- Q2. Different types of caches
- Q3. Scd1 and scd2 implementation
- Q4. Fact and dimensions tables and different data modelling
(1 Question)
- Q1. Salary discuss and location discussion
Vikash Kumar
Selected
I applied via campus placement at Anna University and was interviewed before Oct 2023. There was 1 interview round.
(2 Questions)
- Q1. Lookup transformation
- Q2. Joiner transformation
Selected
I applied via Campus Placement and was interviewed before Mar 2023. There was 1 interview round.
(1 Question)
- Q1. Informatica power centre transformation questions
I applied via Naukri.com and was interviewed in Mar 2022. There was 1 interview round.
(1 Question)
- Q1. Oracle DWH concept Informatica
Interview Preparation Tips
get a job you don't try
TCS interview questions for designations
I applied via Recruitment Consulltant and was interviewed in Nov 2021. There were 2 interview rounds.
(1 Question)
- Q1. Introduction, projects worked, technology stack, scenario based questions, challenges
(1 Question)
- Q1. Salary negotiation and general discussion
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Nov 2021. There were 2 interview rounds.
(1 Question)
- Q1. General, project overview, technology stack, scenario based questions, challenges and experiences
(1 Question)
- Q1. General, salary negotiation
Interview Preparation Tips
Selected
I applied via campus placement at SGGS College of Engineering & Technology, Nanded and was interviewed before Aug 2022. There were 3 interview rounds.
2 coding questions, 1 hr and Aptitude questions are also clubbed into other section.
(3 Questions)
- Q1. Are flexible with location
- Ans. Yes, I am flexible with location
- 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.
- Q3. Are you flexible with working hours
Interview Preparation Tips
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Explainyour job role
- Ans.
ETL Developers are responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into a data warehouse.
Designing ETL processes to extract data from multiple sources
Transforming data to meet business requirements
Loading data into a data warehouse or other target systems
Developing and maintaining ETL jobs using tools like Informatica, Talend, or SSIS
- Q2. Explain implementation of SCD 1 in IICS
- Ans.
SCD Type 1 in IICS involves overwriting existing data with new data without maintaining historical changes.
In IICS, use the Mapping Designer to create a mapping that loads data from source to target.
Use a Lookup transformation to check if the record already exists in the target table.
If the record exists, update the existing record with new data using an Update Strategy transformation.
If the record does not exist, inse...
Skills evaluated in this interview
(2 Questions)
- Q1. What is loads in informatica
- Ans.
Loads in Informatica refer to the process of moving data from source to target in a data warehouse.
Loads involve extracting data from source systems
Transforming the data as needed
Loading the data into the target data warehouse or database
Loads can be full, incremental, or delta depending on the requirements
Example: Loading customer data from a CRM system into a data warehouse for analysis
- Q2. Query to find duplicates in table
- Ans.
Use GROUP BY and HAVING clause to find duplicates in a table.
Use GROUP BY to group rows with same values together
Use HAVING COUNT(*) > 1 to filter out duplicates
Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Skills evaluated in this interview
(2 Questions)
- Q1. Introduce yourself
- Ans.
I am an experienced ETL Developer with a strong background in data integration and transformation.
Over 5 years of experience in ETL development
Proficient in using tools like Informatica, Talend, and SSIS
Strong SQL skills for data querying and manipulation
Experience in designing and implementing data warehouses
Familiar with data modeling and ETL best practices
- Q2. What is SCD type2
TCS Interview FAQs
Tell us how to improve this page.
TCS Interviews By Designations
- TCS System Engineer Interview Questions
- TCS Software Developer Interview Questions
- TCS Software Engineer Interview Questions
- TCS Assistant System Engineer Interview Questions
- TCS Assistant System Engineer Trainee Interview Questions
- TCS IT Analyst Interview Questions
- TCS Ninja Interview Questions
- TCS Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Informatica ETL Developer Interview Questions
- Senior ETL Developer Interview Questions
- Database Developer Interview Questions
- Informatica Developer Interview Questions
- ETL Lead Interview Questions
- SQL Server Developer Interview Questions
- Datastage Developer Interview Questions
- Software Developer Interview Questions
- Show more
TCS ETL Developer Interview Process
based on 3 interviews in last 1 year
1 Interview rounds
- Technical Round
People are getting interviews through
ETL Developer Interview Questions from Similar Companies
Fast track your campus placements
TCS ETL Developer Reviews and Ratings
based on 94 reviews
Rating in categories
|
System Engineer
1.1L
salaries
|  ₹1 L/yr - ₹9 L/yr |
|
IT Analyst
67.7k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
|
AST Consultant
51k
salaries
| ₹8 L/yr - ₹25 L/yr |
|
Assistant System Engineer
29.8k
salaries
| ₹2.2 L/yr - ₹5.6 L/yr |
|
Associate Consultant
28.6k
salaries
| ₹8.9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture
Calculate your in-hand salary
- Home >
- Interviews >
- TCS Interview Questions >
- TCS ETL Developer Interview Questions
