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

Filter interviews by

TCS AWS Data Engineer Interview Questions, Process, and Tips

Updated 1 May 2024

Top TCS AWS Data Engineer Interview Questions and Answers

  • Q1. Explain use of * in both the args and kwargs. Expedition handling.use of pass function in python
  • Q2. Given two table explain joins created and total count
  • Q3. What AWS Glue Service and and It's Components
View all 6 questions

TCS AWS Data Engineer Interview Experiences

3 interviews found

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

I applied via Recruitment Consulltant and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Question based on resume, cloud databases, EMR, Athena, Ec2, Sql
  • Q2. Scenario based questions
Round 2 - One-on-one 

(1 Question)

  • Q1. Managerial questions

I applied via Approached by Company and was interviewed in Nov 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 tips
Round 2 - One-on-one 

(3 Questions)

  • Q1. Question on AWS services like Glue, Lambda, EMR, S3 Python and SQL
  • Q2. Python- List comprehension, function, various methods SQL -window function, rollback, commit, savepoint and it's diffrence Joins AWS- S3 lifecycle, it's use. Glue questions
  • Q3. Explain use of * in both the args and kwargs. Expedition handling.use of pass function in python
  • Ans. 

    The * symbol is used to pass variable number of arguments and keyword arguments in Python functions.

    • The * symbol before a parameter name in a function definition allows it to accept variable number of arguments as a tuple.

    • The ** symbol before a parameter name in a function definition allows it to accept variable number of keyword arguments as a dictionary.

    • The * symbol before an iterable object in a function call unpack...

  • Answered by AI
Round 3 - One-on-one 

(3 Questions)

  • Q1. Resume based questions Data modelling SQL
  • Q2. From SQL focus was on self join Data modelling question from existing project Explain projects and existing pipeline
  • Q3. Given two table explain joins created and total count
  • Ans. 

    Explaining joins and total count for two tables

    • Joins combine data from two or more tables based on a common column

    • Inner join returns only the matching rows from both tables

    • Left join returns all rows from the left table and matching rows from the right table

    • Right join returns all rows from the right table and matching rows from the left table

    • Full outer join returns all rows from both tables

    • Total count is the number of r

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Concentrate on SQL and Python most
Aws questions will be basic theory based.

Skills evaluated in this interview

AWS Data Engineer Interview Questions Asked at Other Companies

asked in Cognizant
Q1. libraries used in ur project and how do you import them
asked in TCS
Q2. Explain use of * in both the args and kwargs. Expedition handling ... read more
asked in LTIMindtree
Q3. Modify null salary with avg salary, find count of employees by jo ... read more
asked in HARMAN
Q4. Write a program to find the greatest from the list of elements wi ... read more
asked in EXL Service
Q5. what is the devops? how both python is used? what can be done for ... read more
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected

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

Round 1 - Technical 

(4 Questions)

  • Q1. What is AWS and its Architecture
  • Ans. 

    AWS is a cloud computing platform provided by Amazon with a scalable and flexible architecture.

    • AWS stands for Amazon Web Services

    • It offers a wide range of cloud services including computing power, storage, and databases

    • AWS architecture is designed to be scalable, secure, and cost-effective

    • Examples of AWS services include EC2 for virtual servers, S3 for storage, and RDS for databases

  • Answered by AI
  • Q2. What is Data Lake and Data warehouse
  • Ans. 

    Data Lake is a storage repository that holds a vast amount of raw data in its native format, while Data Warehouse is a structured repository for processed and analyzed data.

    • Data Lake stores raw, unstructured data in its original form for future processing and analysis.

    • Data Warehouse stores structured, processed data for querying and reporting.

    • Data Lake is ideal for big data analytics and machine learning applications.

    • D...

  • Answered by AI
  • Q3. What AWS Glue Service and and It's Components
  • Ans. 

    AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy to prepare and load data for analytics.

    • AWS Glue Data Catalog: A central metadata repository that stores metadata information about datasets and sources.

    • AWS Glue ETL: Allows you to create ETL jobs to transform data from various sources into a format that can be easily analyzed.

    • AWS Glue Crawler: Automatically discovers data in vario...

  • Answered by AI
  • Q4. When to use Lambda and Glue
  • Ans. 

    Lambda for event-driven processing, Glue for ETL jobs

    • Use Lambda for event-driven processing, such as real-time data processing or triggering actions based on events

    • Use Glue for ETL (Extract, Transform, Load) jobs, especially when dealing with large volumes of data or complex transformations

    • Lambda is serverless and scales automatically, while Glue provides managed ETL capabilities with built-in connectors to various dat...

  • Answered by AI
Round 2 - Case Study 

Create Architecture for Scalable AWS Data Pipeline

Round 3 - HR 

(3 Questions)

  • Q1. What is background and overall exp
  • Q2. Your Weakness and strength
  • Q3. Salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic concept and clear on what you know.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Jan 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. First question in hr interview is tell about yourself then the hr asked questions what I mentioned in my resume. So put the information in resume what you known well. My unique talent is I'm a stage spea...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold, be confident, don't put irrelevant information in your resume update yourself relating to your studies

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed before Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Description of project
  • Ans. 

    The project involved designing and implementing a new network infrastructure for a large corporation.

    • Conducted a thorough analysis of the existing network infrastructure

    • Designed a new network architecture that met the company's needs

    • Implemented the new network infrastructure with minimal disruption to business operations

    • Tested and optimized the new network to ensure optimal performance

    • Provided ongoing support and maint

  • Answered by AI
  • Q2. Your previous experince

Interview Preparation Tips

Interview preparation tips for other job seekers - Well prepare for your resume

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

Interview Questionnaire 

4 Questions

  • Q1. 1.Tell me about yourself.
  • Q2. 2. Some basic questions from DBMS, iot and cloud.
  • Q3. 3. Explain your project ( technology u have used and what is it).
  • Q4. 4. Are you willing to relocate.

Interview Preparation Tips

Interview preparation tips for other job seekers - HR was nice and friendly. Overall it was a NYC experience.
All the best guys.

I applied via Campus Placement and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Concepts of Oops

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare with basic concepts of OOPS.Explain final year project.
Be confident.

I appeared for an interview before Jun 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 180 minutes
Round difficulty - Easy

It was an mcq + coding round. There were aptitude and ouput based question in mcq. And coding questions were easy

  • Q1. 

    Find the Duplicate Number Problem Statement

    Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...

  • Ans. 

    Find the duplicate number in an array of integers from 0 to (N-2).

    • Iterate through the array and keep track of the frequency of each number using a hashmap.

    • Return the number with a frequency greater than 1 as the duplicate number.

    • Time complexity can be optimized to O(N) using Floyd's Tortoise and Hare algorithm.

  • Answered by AI
  • Q2. 

    Reverse String Operations Problem Statement

    You are provided with a string S and an array of integers A of size M. Your task is to perform M operations on the string as specified by the indices in array A...

  • Ans. 

    Given a string and an array of indices, reverse substrings based on the indices to obtain the final string.

    • Iterate through the array of indices and reverse the substrings accordingly

    • Ensure the range specified by each index is non-empty

    • Return the final string after all operations are completed

  • Answered by AI
Round 2 - Video Call 

Round duration - 60 Minutes
Round difficulty - Easy

It was technical + hr round. there were 2 people as interviewer. They stated from intro and asked some basic puzzles and hr questions. After that they asked about my projects, technologies and some ds algo and dbms questions.

Interview Preparation Tips

Eligibility criterianaAccenture interview preparation:Topics to prepare for the interview - Data Structures, Pointers, OOPS, System Design, Algorithms, Dynamic ProgrammingTime required to prepare for the interview - 6 MonthsInterview preparation tips for other job seekers

Tip 1 : Practice aptitude
Tip 2 : Focus on practicing coding
Tip 3 : Learn from mistakes

Application resume tips for other job seekers

Tip 1 : Mention some projects that you have done
Tip 2 : Try to have skills that are required for the role

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Aug 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 - Coding Test 

Easy DSA questions and some questions on resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join if you are a fresher and want to grow as a developer. I had resigned that time I am writing this review

TCS Interview FAQs

How many rounds are there in TCS AWS Data Engineer interview?
TCS interview process usually has 2-3 rounds. The most common rounds in the TCS interview process are One-on-one Round, Technical and Case Study.
How to prepare for TCS AWS Data Engineer 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 Python, AWS, EMR, AWS Glue and Pyspark.
What are the top questions asked in TCS AWS Data Engineer interview?

Some of the top questions asked at the TCS AWS Data Engineer interview -

  1. Explain use of * in both the args and kwargs. Expedition handling.use of pass f...read more
  2. Given two table explain joins created and total co...read more
  3. What AWS Glue Service and and It's Compone...read more

Tell us how to improve this page.

TCS AWS Data Engineer Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more
TCS AWS Data Engineer Salary
based on 110 salaries
₹3.9 L/yr - ₹11 L/yr
34% less than the average AWS Data Engineer Salary in India
View more details

TCS AWS Data Engineer Reviews and Ratings

based on 13 reviews

3.5/5

Rating in categories

3.5

Skill development

3.3

Work-life balance

2.6

Salary

4.8

Job security

3.6

Company culture

2.4

Promotions

2.8

Work satisfaction

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

₹1 L/yr - ₹9 L/yr

IT Analyst
66.1k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

AST Consultant
51.7k salaries
unlock blur

₹8 L/yr - ₹25.2 L/yr

Associate Consultant
29.9k salaries
unlock blur

₹9 L/yr - ₹32 L/yr

Assistant System Engineer
29.7k salaries
unlock blur

₹2.2 L/yr - ₹5.8 L/yr

Explore more salaries
Compare TCS with

Amazon

4.1
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

Accenture

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