30+ Tech Mahindra Data Engineer Interview Questions & Answers | Complete Prep Guide 2025

Tech Mahindra Data Engineer Interview Experiences

15 interviews found

Data Engineer Interview Questions & Answers

Rishu Gupta

posted on 12 Mar 2024

Interview experience

Excellent

Difficulty level

Process Duration

Result

No response

Round 1 - Aptitude Test

Basic aptitude and reasoning online test

Round 2 - Technical

(1 Question)

Q1. SQL basic questions asked

Add your answer

Data Engineer Interview Questions & Answers

Anonymous

posted on 12 Oct 2023

Interview experience

Good

Difficulty level

Easy

Process Duration

Less than 2 weeks

Result

Not Selected

I applied via Naukri.com and was interviewed in Sep 2023. 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 - techincal skill in sql

(4 Questions)

Q1. Constraints, joins

Add your answer

Q2. Window functions

Add your answer

Q3. Delete and truncate difference

Ans.

Delete removes rows from a table while truncate removes all rows from a table

Delete is a DML command while truncate is a DDL command
Delete can be rolled back while truncate cannot be rolled back
Delete fires triggers on each row deletion while truncate does not fire triggers

Answered by AI

Add your answer

Q4. Query optimization

Add your answer

Round 3 - Technical

(1 Question)

Q1. Deep into sql and coding

Add your answer

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

Anonymous

posted on 17 Jun 2023

Interview experience

Excellent

Difficulty level

Easy

Process Duration

Less than 2 weeks

Result

Not Selected

I applied via Naukri.com and was interviewed in May 2023. There were 4 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 - Aptitude Test

Ratio& proportion, number series, puzzle, encoder &decoder

Round 3 - Technical

(1 Question)

Q1. Java, python, Hadoop,git, spark,sql,xml

Add your answer

Round 4 - HR

(1 Question)

Q1. Relocation, salary discussion

Add your answer

What people are saying about Tech Mahindra

View All

an associate software engineer

5d (edited)

Advice for freshers joining as ASE

Join here only if you want to stay on bench for a year and expect termination. Believe me, you will never get any projects. If you have some luck left, you will be allocated to ENS projects (neither growth nor job security). Forget of working in soft... read more

Got a question about Tech Mahindra?

Ask anonymously on communities.

Data Engineer Interview Questions & Answers

Raj Thakur

posted on 12 Oct 2023

Interview experience

Average

Difficulty level

Process Duration

Result

Round 1 - Coding Test

Was dought full and Landy

Round 2 - Technical

(1 Question)

Q1. What is cloud ? What is pyspark

Ans.

Cloud is a network of remote servers hosted on the internet to store, manage, and process data.

Cloud computing allows users to access data and applications from any device with an internet connection.
It provides scalability, flexibility, and cost-effectiveness for businesses.
Examples of cloud services include Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.

Answered by AI

Add your answer

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

Anonymous

posted on 15 Oct 2022

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 - Technical

(2 Questions)

Q1. About pyspark,data factory annd azuure sql

Add your answer

Q2. Transformations in pyspark rank,dense rank

Ans.

Rank and Dense Rank are transformations in PySpark used to assign ranks to rows based on a specific column.

Rank assigns unique ranks to each row based on the order of values in a specific column.
Dense Rank assigns ranks to each row based on the order of values in a specific column, but with no gaps between ranks.
Both transformations can be used with the 'over' function to specify the column to order by.
Example: df.sele...

Answered by AI

Add your answer

Round 3 - Technical

(1 Question)

Q1. Clusters,persistancy in pyspark,triggers in adf

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident on your work.Try to learn new things daily

Skills evaluated in this interview

Get interview-ready with Top Tech Mahindra Interview Questions

Tech Mahindra Interview FAQs

How many rounds are there in Tech Mahindra Data Engineer interview?

Tech Mahindra interview process usually has 1-2 rounds. The most common rounds in the Tech Mahindra interview process are Technical, Resume Shortlist and Coding Test.

How to prepare for Tech Mahindra 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 Tech Mahindra. The most common topics and skills that interviewers at Tech Mahindra expect are Python, SQL, Spark, ETL and AWS.

What are the top questions asked in Tech Mahindra Data Engineer interview?

Some of the top questions asked at the Tech Mahindra Data Engineer interview -

how to remove duplicate rows from bigquery? find the month of a given date in b...read more
what operator is used in composer to move data from gcs to...read more
What is the SQL query to calculate the average sales over a period of 7 da...read more

How long is the Tech Mahindra Data Engineer interview process?

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

Tell us how to improve this page.

Tech Mahindra Interviews By Designations

Interview Questions for Popular Designations

Tech Mahindra Data Engineer Interview Process

based on 14 interviews

3 Interview rounds

Technical Round - 1
Technical Round - 2
Technical Round - 3

TCS Data Engineer Interview Questions

3.7

• 89 Interviews

Accenture Data Engineer Interview Questions

3.8

• 78 Interviews

LTIMindtree Data Engineer Interview Questions

3.8

• 61 Interviews

IBM Data Engineer Interview Questions

4.0

• 41 Interviews

Capgemini Data Engineer Interview Questions

3.7

• 33 Interviews

Cognizant Data Engineer Interview Questions

3.8

• 30 Interviews

Infosys Data Engineer Interview Questions

3.6

• 24 Interviews

Wipro Data Engineer Interview Questions

3.7

• 24 Interviews

HCLTech Data Engineer Interview Questions

3.5

• 12 Interviews

Genpact Data Engineer Interview Questions

3.8

• 8 Interviews

View all

National Institute of Technology (NIT), Warangal Placement Questions

5 Interviews

Jawaharlal Nehru Technological University (JNTU) Placement Questions

3 Interviews

D Y Patil College of Engineering, Pune Placement Questions

2 Interviews

Symbiosis, Pune Placement Questions

1 Interview

MGM Jawaharlal Nehru Engineering College, Aurangabad Placement Questions

1 Interview

DKTE Society's Textile & Engineering Institute, Pune Placement Questions

1 Interview

Shri Vidyanikethan Engineering College, Tirupati Placement Questions

1 Interview

View all

Tech Mahindra Data Engineer Salary

based on 634 salaries

₹3.1 L/yr - ₹16.9 L/yr

11% less than the average Data Engineer Salary in India

View more details

Data Engineer Jobs at Tech Mahindra

Hiring For Data Engineer - Hyderabad & Bangalore Location

Hyderabad / Secunderabad,

Bangalore / Bengaluru

5-8 Yrs

Not Disclosed

Opening For Data Engineer

Bangalore / Bengaluru

5-10 Yrs

Not Disclosed

Data Engineer

Noida,

Gurgaon / Gurugram

1-5 Yrs

Not Disclosed

Explore more jobs

Tech Mahindra Salaries in India

Software Engineer 26.4k salaries	₹0 L/yr - ₹0 L/yr
Senior Software Engineer 21.4k salaries	₹0 L/yr - ₹0 L/yr
Technical Lead 11.7k salaries	₹0 L/yr - ₹0 L/yr
Associate Software Engineer 5.5k salaries	₹0 L/yr - ₹0 L/yr
Team Lead 5k salaries	₹0 L/yr - ₹0 L/yr