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 Azure Data Engineer Interview Questions, Process, and Tips
Updated
7 Sep 2024
Top Tech Mahindra Azure Data Engineer Interview Questions and Answers
- Q1. Lets say you have table 1 with values 1,2,3,5,null,null,0 and table 2 has null,2,4,7,3,5 What would be the output after inner join?
- Q2. How do you design an effective ADF pipeline and what all metrics and considerations you should keep in mind while designing?
- Q3. What is incremental load. What is partition and bucketing. Spark archtecture
3 Tech Mahindra Azure Data Engineer Interview Experiences
18 questions found
Sort by:
Popular
Anonymous
Interview experience
Good
Difficulty level
Easy
Duration
Less than 2 weeks
Result
-
I applied via Naukri.com and was interviewed in May 2024.
2 Interview Rounds
1
One-on-one Round (5 Questions)
- Q1. Project Architecture, spark transformations used? View Answers (1)
- Q2. Advanced SQL questions - highest sales from each city View Answers (1)
- Q3. Data modelling - Star schema, Snowflake schema, Dimension and Fact tables Add Answer
- Q4. Databricks - how to mount? View Answers (1)
- Q5. Questions on ADF - pipeline used in the project Add Answer
2
One-on-one Round (1 Question)
- Q1. Questions on Databricks - optimizations, history, autoloader, liquid clustering, autoscaling Add Answer
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed in Aug 2024.
3 Interview Rounds
1
Technical Round (4 Questions)
- Q1. Lets say you have table 1 with values 1,2,3,5,null,null,0 and table 2 has null,2,4,7,3,5 What would be the output after inner join? View Answers (1)
- Q2. Lets say you have customers table with customerID and customer name, Orders table with OrderId and CustomerID. write a query to find the customer name who place...read more Add Answer
- Q3. Spark Architecture, Optimisation techniques Add Answer
- Q4. Some personal questions. Add Answer
2
Technical Round (5 Questions)
- Q1. Explain the entire architecture of a recent project you are working on in your organisation. View Answers (1)
- Q2. How do you design an effective ADF pipeline and what all metrics and considerations you should keep in mind while designing? View Answers (1)
- Q3. Lets say you have a very huge data volume and in terms of performance how would you slice and dice the data in such a way that you can boost the performance? Add Answer
- Q4. Lets say you have to reconstruct a table and we have to preserve the historical data ? ( i couldnt answer that but please refer to SCD) Add Answer
- Q5. We have adf and databricks both, i can achieve transformation , fetching the data and loading the dimension layer using adf also but why do we use databricks if...read more Add Answer
3
HR Round (1 Question)
- Q1. Basic HR questions Add Answer
Interview Preparation Tips
Topics to prepare for Tech Mahindra Azure Data Engineer interview:
- SQL
- Databricks
- Azure Data Factory
- Pyspark
- Spark
Skills evaluated in this interview
Get interview-ready with top interview questions
Kumar Gaurav
Interview experience
Excellent
Difficulty level
Moderate
Duration
-
Result
Not Selected
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. What is incremental load.
What is partition and bucketing.
Spark archtecture View Answers (1)
2
Technical Round (1 Question)
- Q1. Scenario based question on spark performance optimization. Add Answer
Skills evaluated in this interview
What people are saying about Tech Mahindra
View All
a junior engineer - quality assurance
1w (edited)
Offered Salary & Open Scopes at Tech Mahindra Ahmedabad
Recently I was affected by the layoff and looking for a Quality Assurance role. After 2.6 years experience I'm being offered 5.5 LPA at Ahmedabad location in Tech Mahindra.
What's the best I can get in the current situation?
Got a question about Tech Mahindra?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Activities used in ADF View Answers (1)
- Q2. Dataframes in pyspark View Answers (1)
2
HR Round (2 Questions)
- Q1. Managerial Questions Add Answer
- Q2. About project roles and resposibilities Add Answer
Skills evaluated in this interview
Interview experience
Good
Difficulty level
-
Duration
-
Result
Selected
I applied via Naukri.com
2 Interview Rounds
1
Technical Round (4 Questions)
- Q1. Based on my previous company projects View Answers (1)
- Q2. SQL based questions are asked Add Answer
- Q3. ADF based questions are asked Add Answer
- Q4. Azure related questions are asked Add Answer
2
HR Round (1 Question)
- Q1. Reg salary discussion Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - NA
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Technical Round (1 Question)
- Q1. Spark Architecture Add Answer
2
Technical Round (2 Questions)
- Q1. Explain your project Add Answer
- Q2. Remove duplicates View Answers (1)
3
HR Round (1 Question)
- Q1. Salary expectations Add Answer
Skills evaluated in this interview
Interview experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Recruitment Consulltant and was interviewed in Mar 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. How are you connecting your onPerm from Azure? View Answers (1)
- Q2. What is Autoloader in Databricks? View Answers (1)
- Q3. How do you normalize your Json data View Answers (1)
- Q4. How do you read from Kafka? Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Focus on core technical
Skills evaluated in this interview
Interview experience
Bad
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Company Website and was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Challenges faced in production deployment View Answers (1)
- Q2. Tell me about your project View Answers (1)
Skills evaluated in this interview
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Approached by Company and was interviewed in Mar 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Basics of adf adb Add Answer
- Q2. What is IR in adf pipe line View Answers (1)
Skills evaluated in this interview
Nishanth VK
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
Selected
3 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
Technical Round (1 Question)
- Q1. Brief about your projects
Be much prompt with your roles and responsibilities.
Good to know SQL better Add Answer
3
HR Round (1 Question)
- Q1. Salary negotiation and about relocation Add Answer
Tech Mahindra Interview FAQs
How many rounds are there in Tech Mahindra Azure Data Engineer interview?
Tech Mahindra interview process usually has 2-3 rounds. The most common rounds in the Tech Mahindra interview process are Technical, One-on-one Round and HR.
How to prepare for Tech Mahindra Azure 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 SQL, Python, Azure, Spark and Data Warehousing.
What are the top questions asked in Tech Mahindra Azure Data Engineer interview?
Some of the top questions asked at the Tech Mahindra Azure 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
- Azure DevOps Engineer Interview Questions
- Azure Administrator Interview Questions
- Azure Developer Interview Questions
- Azure Cloud Engineer Interview Questions
- Azure Cloud Administrator Interview Questions
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Show more
Interview Process at Tech Mahindra Azure Data Engineer
based on 3 interviews in last 1 year
Interview experience
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
Azure Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
19%
less
than the average Azure Data Engineer Salary in India
View more details
Tech Mahindra Azure Data Engineer Reviews and Ratings
based on 9 reviews
Rating in categories
|
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 Azure Data Engineer Interview Questions
Share an Interview