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 Associate Data Engineer Interview Questions and Answers
Updated
22 Mar 2021
1 interview found
Sort by:
Popular
Anonymous
I applied via Recruitment Consultant and was interviewed in Feb 2021.
4 Interview Rounds
Interview Questions
- Q1. #3 interviews were there 1. Basic Telephonic all basic questions were there then 2. zoom video for detaled code and sql queries 3. advanced for algo designing a...read more
Add Answer
- Q2. Basic question and coding is answered as per knowledge and experience. Advance questions is totally based on aptitude . reasonng and decision making skills
Add Answer
- Q3. Why TechMahindra guys conduct interviews if after selecting all technical round they dnt have any offer to give. And make it as hold.
Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Please discuss frankly to HR after selecting in all interview round will i get the offer with expected salary or just it will hold to infinite time.
Interview questions from similar companies
Interview experience
Excellent
Difficulty level
Easy
Duration
2-4 weeks
Result
Selected
I applied via campus placement at RC Patel College of Education, Shirpur and was interviewed in Oct 2024.
3 Interview Rounds
1
Aptitude Test Round
There are some general aptitude questions.
2
Coding Test Round
There were two simple codes from which we need to pass the test case for at least one code
3
HR Round (3 Questions)
- Q1. Tell me about your project Add Answer
- Q2. What was the difficut subject in college View Answers (1)
- Q3. Tell me about yourself View Answers (1)
Interview Questions
- Q1. How to find 3rd Highest salary in Sql.
View Answers (4)
- Q2. How to delete duplicate rows in Sql
View Answers (4)
- Q3. Datastge - How will you remove Header and trailer from Sequential data file
View Answers (2)
- Q4. How would you kill any job in Datastage
View Answers (1)
- Q5. How to find process id in linux
View Answers (3)
Skills evaluated in this interview
Interview Questions
- Q1. How would you recommend customer to migrate on cloud
View Answers (2)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2024.
2 Interview Rounds
1
HR Round (2 Questions)
- Q1. Can you provide an overview of your background, including your past experiences and daily activities, as well as the tools you use in your routine? Add Answer
- Q2. What are the concepts of advanced Excel and Power BI projects, and how are they utilized within a company or for clients? Add Answer
2
One-on-one Round (2 Questions)
- Q1. Can you explain your project experience related to Advanced Excel and Power BI? Add Answer
- Q2. What are the concepts of credit and operations, particularly in relation to Know Your Customer (KYC) procedures and the privacy of client data? Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - If your resume is shortlisted, then there is a higher chance that you will be selected.
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
Interview experience
Good
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (6 Questions)
- Q1. Can you introduce yourself and describe your current project experience? View Answers (1)
- Q2. Decorators in python View Answers (1)
- Q3. What is the SQL query to group by employee ID in order to combine the first name and last name with a space? View Answers (1)
- Q4. What are constructors in Python? View Answers (1)
- Q5. Indexing in sql View Answers (1)
- Q6. Why spark works well with parquet files? View Answers (1)
Skills evaluated in this interview
Sashikanta Parida
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (3 Questions)
- Q1. What are different type of joins available in Databricks? View Answers (1)
- Q2. How do you make your data pipeline fault tolerant? View Answers (1)
- Q3. What is AutoLoader? View Answers (1)
2
Technical Round (2 Questions)
- Q1. How do you connect to different services in Azure? View Answers (1)
- Q2. What are linked Services? View Answers (1)
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Aug 2024.
2 Interview Rounds
1
Technical Round (12 Questions)
- Q1. Tell me about yourself and Project View Answers (1)
- Q2. What was you day-to-day job in your project View Answers (1)
- Q3. Spark Architecture Add Answer
- Q4. How DAG handle Fault tolerance? View Answers (1)
- Q5. What is shuffling? How to Handle Shuffling? View Answers (1)
- Q6. What is the difference between repartition and Coelsce? View Answers (1)
- Q7. How do you handle Incremental data? View Answers (1)
- Q8. What is SCD ?? View Answers (1)
- Q9. Scenerio based questions related to Spark ? Add Answer
- Q10. Two SQL Codes and Two Python codes like reverse a string ? View Answers (1)
- Q11. Find top 5 countries with highest population in Spark and SQL View Answers (1)
- Q12. Using two tables find the different records for different joins View Answers (1)
2
One-on-one Round (7 Questions)
- Q1. What is a catalyst optimiser? How it works? View Answers (1)
- Q2. Tell me about the optimization you used in your project. View Answers (1)
- Q3. Pyspark question related to merging two schemas? Add Answer
- Q4. What is the best approach to finding whether the data frame is empty or not? View Answers (1)
- Q5. Spark Architecture Add Answer
- Q6. How do you decide on cores and worker nodes? View Answers (1)
- Q7. What happens when we enforce schema ? View Answers (1)
Interview Preparation Tips
Topics to prepare for Persistent Systems Senior Data Engineer interview:
- SQL
- Pyspark
- Python
- Spark
- Database
Skills evaluated in this interview
I applied via Company Website
4 Interview Rounds
1
Aptitude Test Round
Prepare verval, LRDI, Quant moderate like using RS agarwal best book for prepare aptitude
2
Coding Test Round
Practice pseudo code minmum 100 pseudo code and for coding using code chef platform best for preparation
3
Technical Round (1 Question)
- Q1. 1.What programing language i know rate yourself ? 2.Oops concept and explaine . 3.Which project i had completed in my final year ? 4.What my responsibility in p...read more Add Answer
4
HR Round (1 Question)
- Q1. How to manage tram conflict ? View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - 1.Firstly focus on aptitude test and prepare hardly 2 months for varc,lrdi,quant after that focus on coding and interview round .
2. Learn any one language according to which one easy for you .
3. Go throw youtube videos interviews questions what type of questions interviewer ask.
2. Learn any one language according to which one easy for you .
3. Go throw youtube videos interviews questions what type of questions interviewer ask.
Tech Mahindra Interview FAQs
What are the top questions asked in Tech Mahindra Associate Data Engineer interview?
Some of the top questions asked at the Tech Mahindra Associate Data Engineer interview -
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
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Scientist Interview Questions
- Associate Data Analyst Interview Questions
- Data Associate Interview Questions
- Senior Data Engineer Interview Questions
- Show more
People are getting interviews through
based on 1 Tech Mahindra interview
Recruitment Consultant
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Interview Questions from Similar Companies
Fast track your campus placements
39%
less
than the average Associate Data Engineer Salary in India
View more details
|
Software Engineer
26.3k
salaries
|  ₹2 L/yr - ₹9 L/yr |
|
Senior Software Engineer
21.2k
salaries
| ₹5.4 L/yr - ₹22.5 L/yr |
|
Technical Lead
11.4k
salaries
| ₹9.1 L/yr - ₹37 L/yr |
|
Associate Software Engineer
5.2k
salaries
| ₹1.8 L/yr - ₹6 L/yr |
|
Team Lead
4.9k
salaries
| ₹5.1 L/yr - ₹16.5 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 Associate Data Engineer Interview Questions
Share an Interview