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
Compare
Filter interviews by
Tech Mahindra Data Engineer Interview Questions, Process, and Tips for Freshers
Updated
15 Dec 2024
Top Tech Mahindra Data Engineer Interview Questions and Answers for Freshers
- 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. write a code for this - input = [1,2,3,4] output = [1,4,9,16]
2 Tech Mahindra Data Engineer Interview Experiences for Freshers
9 questions found
Sort by:
Popular
Rutuja Bhagat
Interview experience
Good
Difficulty level
Easy
Duration
-
Result
-
I applied via Recruitment Consulltant and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (7 Questions)
- Q1. Difference between bigtable and bigquery. Add Answer
- Q2. How to remove duplicate rows from bigquery? find the month of a given date in bigquery. Add Answer
- Q3. What operator is used in composer to move data from gcs to bq Add Answer
- Q4. Write a code for this - input = [1,2,3,4]
output = [1,4,9,16] Add Answer
- Q5. Dataflow vs dataproc. Add Answer
- Q6. Architecture of bq. Query optimization techniques in bigquery. Add Answer
- Q7. RDD vs dataframe vs dataset in pyspark Add Answer
Anonymous
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in May 2023.
4 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
Aptitude Test Round
Ratio& proportion, number series, puzzle, encoder &decoder
3
Technical Round (1 Question)
- Q1. Java, python, Hadoop,git, spark,sql,xml Add Answer
4
HR Round (1 Question)
- Q1. Relocation, salary discussion Add Answer
Get interview-ready with top interview questions
Data Engineer Jobs at Tech Mahindra
Interview questions from similar companies
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Oct 2024.
2 Interview Rounds
1
Technical Round (7 Questions)
- Q1. How do you optimize SQL queries? View Answers (1)
- Q2. How do you do performance optimization in Spark. Tell how you did it in you project. View Answers (1)
- Q3. What is SparkContext and SparkSession? View Answers (1)
- Q4. When a spark job is submitted, what happens at backend. Explain the flow. View Answers (2)
- Q5. Calculate second highest salary using SQL as well as pyspark. View Answers (1)
- Q6. 2 types of modes for Spark architecture ? View Answers (1)
- Q7. If you want very less latency - which is better standalone or client mode? View Answers (1)
2
Technical Round (2 Questions)
- Q1. Scenario based. Write SQL and pyspark code for a dataset. Add Answer
- Q2. If you have to find latest record based on latest timestamp in a table for a particular customer(table is having history) , how will you do it. Self join and ne...read more Add Answer
Interview Preparation Tips
Topics to prepare for LTIMindtree Data Engineer interview:
- SQL
- pyspark
- ETL
Skills evaluated in this interview
Abhishek Paithankar
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Aptitude Test Round
Aptitude test involved with quantative aptitude, logical reasoning and reading comprehensions.
2
Technical Round (2 Questions)
- Q1. Tell me your introduction. Add Answer
- Q2. Tell me about your skills. View Answers (1)
3
HR Round (2 Questions)
- Q1. Are you ready relocate,? View Answers (1)
- Q2. Document verification Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - If you are fresher first prepare for aptitude, because once aptitude get cleared you will get selected from the large compitition and then focus on your technical knowledge and managerial skills about the company.
yashaswi raj
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Difference between select and withcolumn in pyspark View Answers (1)
- Q2. Difference between variables and parameters in ADF View Answers (1)
Skills evaluated in this interview
Interview experience
Average
Difficulty level
Easy
Duration
-
Result
Selected
I applied via Walk-in
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Spark architecture Add Answer
- Q2. Spark Optimisation techniques View Answers (1)
Skills evaluated in this interview
Atharva Bhangre
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Spark related questions Add Answer
- Q2. Hadoop architecture and ecosystem questions Add Answer
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (1 Question)
- Q1. 1. Write SQL code.for ranking based on salary
2. Pyspark code to remove duplicates
3. Power bi question to add filter Add Answer
Rajamanickam S
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. About the data structures Add Answer
Interview experience
Good
Difficulty level
Easy
Duration
2-4 weeks
Result
Selected
I applied via Campus Placement and was interviewed in Jul 2023.
3 Interview Rounds
1
Coding Test Round
Basic questions about the technology you'll be using.
2
Technical Round (1 Question)
- Q1. Easy problems in python. View Answers (2)
3
HR Round (1 Question)
- Q1. If you sit for HR round you're hired. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Clear basics and solve questions regularly DSA all the way
Skills evaluated in this interview
Tech Mahindra Interview FAQs
How many rounds are there in Tech Mahindra Data Engineer interview for freshers?
Tech Mahindra interview process for freshers usually has 4 rounds. The most common rounds in the Tech Mahindra interview process for freshers are Resume Shortlist, Aptitude Test and Technical.
How to prepare for Tech Mahindra Data Engineer interview for freshers?
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 for freshers?
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
- Tech Mahindra Software Engineer Interview Questions
- Tech Mahindra Senior Software Engineer Interview Questions
- Tech Mahindra Customer Service Associate Interview Questions
- Tech Mahindra Associate Software Engineer Interview Questions
- Tech Mahindra Customer Service Executive Interview Questions
- Tech Mahindra Customer Support Associate Interview Questions
- Tech Mahindra Customer Care Executive Interview Questions
- Tech Mahindra Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
People are getting interviews through
based on 2 Tech Mahindra interviews
Job Portal
50%
50% candidates got the interview through other sources.
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
21%
less
than the average Data Engineer Salary in India
View more details
Tech Mahindra Data Engineer Reviews and Ratings
based on 24 reviews
Rating in categories
Data Engineer VBA, POWER BI, SQL,FIORI
Applic, Macro- Hyderabad
Hyderabad / Secunderabad
5-10 Yrs
Not Disclosed
|
Software Engineer
26.8k
salaries
|  ₹2 L/yr - ₹9.3 L/yr |
|
Senior Software Engineer
21.9k
salaries
| ₹5.5 L/yr - ₹23 L/yr |
|
Technical Lead
12.1k
salaries
| ₹9.2 L/yr - ₹37 L/yr |
|
Team Lead
5.1k
salaries
| ₹5.5 L/yr - ₹18 L/yr |
|
Associate Software Engineer
5k
salaries
| ₹1.8 L/yr - ₹6 L/yr |
Explore more salaries
Compare Tech Mahindra with
Infosys
Compare
Cognizant
Compare
Accenture
Compare
Wipro
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
- Home >
- Interviews >
- Tech Mahindra Interview Questions >
- Tech Mahindra Data Engineer Interview Questions for Fresher
Share an Interview