Upload Button Icon Add office photos
Engaged Employer

i

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

Tech Mahindra Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Tech Mahindra Data Engineer Interview Questions, Process, and Tips

Updated 27 Feb 2025

Top Tech Mahindra Data Engineer Interview Questions and Answers

  • Q1. how to remove duplicate rows from bigquery? find the month of a given date in bigquery.
  • Q2. what operator is used in composer to move data from gcs to bq
  • Q3. What is the SQL query to calculate the average sales over a period of 7 days?
View all 13 questions

Tech Mahindra Data Engineer Interview Experiences

15 interviews found

Data Engineer Interview Questions & Answers

user image Rishu Gupta

posted on 12 Mar 2024

Interview experience
5
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

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 12 Oct 2023

Interview experience
4
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
  • Q2. Window functions
  • 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
  • Q4. Query optimization
Round 3 - Technical 

(1 Question)

  • Q1. Deep into sql and coding

Skills evaluated in this interview

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 17 Jun 2023

Interview experience
5
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
Round 4 - HR 

(1 Question)

  • Q1. Relocation, salary discussion

Data Engineer Interview Questions & Answers

user image Raj Thakur

posted on 12 Oct 2023

Interview experience
3
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

Skills evaluated in this interview

Tech Mahindra interview questions for designations

 Big Data Engineer

 (1)

 Senior Data Engineer

 (1)

 Data Architect

 (1)

 Azure Data Engineer

 (6)

 Data Engineer 1

 (2)

 Gcp Data Engineer

 (2)

 AWS Data Engineer

 (1)

 Associate Data Engineer

 (1)

Data Engineer Interview Questions & Answers

user image 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
  • 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
Round 3 - Technical 

(1 Question)

  • Q1. Clusters,persistancy in pyspark,triggers in adf

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

Contribute & help others!
anonymous
You can choose to be anonymous

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 -

  1. how to remove duplicate rows from bigquery? find the month of a given date in b...read more
  2. what operator is used in composer to move data from gcs to...read more
  3. 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.

Recently Viewed

INTERVIEWS

Cognizant

No Interviews

INTERVIEWS

Cognizant

No Interviews

INTERVIEWS

Global Newborn Solutions

No Interviews

INTERVIEWS

DXC Technology

No Interviews

REVIEWS

HGS

No Reviews

INTERVIEWS

Tech Mahindra

No Interviews

INTERVIEWS

Tech Mahindra

No Interviews

DESIGNATION

DESIGNATION

DESIGNATION

Tell us how to improve this page.

Tech Mahindra Data Engineer Interview Process

based on 14 interviews

3 Interview rounds

  • Technical Round - 1
  • Technical Round - 2
  • Technical Round - 3
View more

Data Engineer Interview Questions from Similar Companies

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

Tech Mahindra Data Engineer Reviews and Ratings

based on 35 reviews

3.4/5

Rating in categories

3.5

Skill development

3.2

Work-life balance

2.6

Salary

3.2

Job security

3.0

Company culture

2.5

Promotions

3.1

Work satisfaction

Explore 35 Reviews and Ratings
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

1-5 Yrs

Not Disclosed

Explore more jobs
Software Engineer
26.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
21.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
11.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
5.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Tech Mahindra with

Infosys

3.6
Compare

Cognizant

3.7
Compare

Accenture

3.8
Compare

Wipro

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