Upload Button Icon Add office photos
Engaged Employer

i

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

TCS Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 84k Reviews

Filter interviews by

TCS Senior Data Engineer Interview Questions and Answers for Experienced

Updated 29 May 2024

1 interview found

Sort by: Popular

Senior Data Engineer Interview Questions

user image Anonymous

posted on 29 May 2024

Interview experience
1
 Bad
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
 No response

I applied via Walk-in and was interviewed in Apr 2024.

2 Interview Rounds

1

Technical Round (3 Questions)

  • Q1. No questions just asked to write SQL query and Python script. Not sure what they expect from it.
  • Q2. Write a SQL query
  • Q3. Write a Python program
2

One-on-one Round (1 Question)

  • Q1. Self intro and questions based on previous experiance

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in Nov 2024.

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. All questions based on databricks and some pyspark , python , SQL only.
  • Q2. Learn windows function implementation in databricks note book.
2

HR Round (1 Question)

  • Q1. This round about your salary discussion around.

Interview Preparation Tips

Topics to prepare for Accenture Senior Data Engineer interview:
  • Python
  • Pyspark
  • SQL
  • Databricks
Interview preparation tips for other job seekers - Please prepare for pyspark, python , SQL , databricks for practice to switch your job to big data engineer
Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Approached by Company and was interviewed in Jun 2024.

2 Interview Rounds

1

Coding Test Round

Python coding question and couple of SQL questions

2

Technical Round (3 Questions)

  • Q1. Spark Optimization techniques
  • Q2. Current Project discussions
  • Q3. Difficulties I have faced during during ETL pipelines

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 -

I applied via LinkedIn and was interviewed in Feb 2024.

3 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. How to work with nested json using pyspark
  • Q2. How to implement scd2 step by step
2

Technical Round (2 Questions)

  • Q1. Write a SQL query to select data from table 2 where data exists in table 1
  • Q2. After performing joins how many records would be retrieved for inner, left, right and outer joins
3

HR Round (1 Question)

  • Q1. About previous company and reason for leaving

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't be afraid of giving interviews. Prepare well attend confidently if you clear it's an opportunity if you don't it's an experience!!

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Recruitment Consulltant and was interviewed in Mar 2024.

2 Interview Rounds

1

One-on-one Round (1 Question)

  • Q1. How the files will be read in AWS GLUE
2

Technical Round (2 Questions)

  • Q1. How to get duplicate records
  • Q2. How to get the second highest salary

Skills evaluated in this interview

Interview experience
3
 Average
Difficulty level
 Hard
Duration
 Less than 2 weeks
Result
 No response

I was interviewed in Jul 2023.

2 Interview Rounds

1

Resume Shortlist Round

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
2

One-on-one Round (7 Questions)

  • Q1. 1) Snowflake architecture in your current project.
  • Q2. 2) Database roles in Snowflake.
  • Q3. 3) Session Policy in Snowflake.
  • Q4. 4) Describe the SSO process between Snowflake and Azure Active Directory.
  • Q5. 5) Network Policy in Snowflake.
  • Q6. 6) Automatic data loading from pipes in to Snowflake.
  • Q7. 7) How does query acceleration speed up query processing?

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 4-6 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed before Jan 2023.

1 Interview Round

1

Technical Round (3 Questions)

  • Q1. Rank types in SQL
  • Q2. Row_Number in sql server
  • Q3. Performance Tuning in sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Please prepare basics before going for interview

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
Selected  Selected

1 Interview Round

1

Technical Round (1 Question)

  • Q1. What are joins Explain spark architecture

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in Oct 2022.

2 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2

Technical Round (2 Questions)

  • Q1. Big data Hadoop architecture and HDFS commands to copy and list files in hdfs spark architecture and Transformation and Action question what happen when we subm...read more
  • Q2. What happen when we submit spark program spark dataframe coding quesiton scala basic program on list git and github project related question agile related

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice spark related question and also do some practice on scala or python coding question

Skills evaluated in this interview

Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Introduction of urs
  • Q2. Basic structured query language
2

HR Round (1 Question)

  • Q1. Introduction of urs

TCS Interview FAQs

How many rounds are there in TCS Senior Data Engineer interview for experienced candidates?
TCS interview process for experienced candidates usually has 2 rounds. The most common rounds in the TCS interview process for experienced candidates are Technical and One-on-one Round.
How to prepare for TCS Senior Data Engineer interview for experienced candidates?
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, Hive, Python, Spark and Hadoop.
What are the top questions asked in TCS Senior Data Engineer interview for experienced candidates?

Some of the top questions asked at the TCS Senior Data Engineer interview for experienced candidates -

  1. Write a Python prog...read more
  2. Write a SQL qu...read more
  3. What is the difference between Tasks, and stages? About Spark ...read more
How long is the TCS Senior Data Engineer interview process?

The duration of TCS Senior Data Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

People are getting interviews through

based on 1 TCS interview
WalkIn
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
TCS Senior Data Engineer Salary
based on 329 salaries
₹7.5 L/yr - ₹30 L/yr
11% less than the average Senior Data Engineer Salary in India
View more details

TCS Senior Data Engineer Reviews and Ratings

based on 16 reviews

4.0/5

Rating in categories

3.6

Skill development

3.9

Work-Life balance

2.9

Salary & Benefits

4.9

Job Security

3.7

Company culture

2.5

Promotions/Appraisal

3.5

Work Satisfaction

Explore 16 Reviews and Ratings
System Engineer
1.1L salaries
unlock blur

₹1 L/yr - ₹9 L/yr

IT Analyst
71.2k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

AST Consultant
52.2k salaries
unlock blur

₹8 L/yr - ₹25 L/yr

Assistant System Engineer
31k salaries
unlock blur

₹2.1 L/yr - ₹5.6 L/yr

Associate Consultant
30k salaries
unlock blur

₹8.9 L/yr - ₹37 L/yr

Explore more salaries
Compare TCS with

Amazon

4.1
Compare

Wipro

3.7
Compare

Infosys

3.7
Compare

Accenture

3.9
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview