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
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
Top skills recommended for Tech Mahindra Azure Data Engineer interview
Insights by AmbitionBox
- SQL
- Python
- Azure
- Spark
- Data Warehousing
- SQL Azure
- ETL
- PLSQL
Interview experience
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
Top skills recommended for Tech Mahindra Azure Data Engineer interview
Insights by AmbitionBox
- Cosmos
- SCALA
- Adf
- Big Data
- Devops
- GIT
- SSIS
- Stored Procedures
Get interview-ready with top interview questions
Kumar Gaurav
Interview experience
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
Top skills recommended for Tech Mahindra Azure Data Engineer interview
Insights by AmbitionBox
- Control - M
- Data Analytics
- Data Modeling
- ETL Testing
- ETL Tool
- MySQL
- NoSQL
- ODBC
Tech Mahindra interview questions for designations
Interview questions from similar companies
Interview experience
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
-
I applied via Approached by Company and was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (6 Questions)
- Q1. Difference between azure Iaas and Paas View Answers (1)
- Q2. About the project structure Add Answer
- Q3. About each layer in the Project Add Answer
- Q4. Scenario based questions for Azure ADF Add Answer
- Q5. Coalesce and Delta tables concepts Add Answer
- Q6. Sql query based on the input Add Answer
Top skills recommended for TCS Azure Data Engineer interview
Insights by AmbitionBox
- Python
- SQL Azure
- Azure
- SQL
- ETL
- Spark
- Big Data
- Power Bi
Interview experience
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Mar 2024.
1 Interview Round
1
Technical Round (5 Questions)
- Q1. Tell me about yourself View Answers (1)
- Q2. What is azure data factory View Answers (1)
- Q3. What is Azure data lake View Answers (1)
- Q4. 2nd highest salary from employee table Add Answer
- Q5. What is index in table View Answers (1)
Interview Preparation Tips
Topics to prepare for Accenture Azure Data Engineer interview:
- Adf
Interview experience
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
Top skills recommended for Wipro Azure Data Engineer interview
Insights by AmbitionBox
- Python
- Adf
- SQL
- SCALA
- Azure
- Cosmos
- Data Warehousing
- Spark
Interview experience
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
Top skills recommended for Cognizant Azure Data Engineer interview
Insights by AmbitionBox
- Azure
- SQL
- Adf
- Python
- Big Data
- SQL Azure
- Agile Process
- ETL
Interview experience
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)
Top skills recommended for Infosys Azure Data Engineer interview
Insights by AmbitionBox
- Azure
- Python
- ETL
- SQL Azure
- Data Management
- Agile
- Change Management
- Data Warehousing
Interview experience
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
Top skills recommended for Capgemini Azure Data Engineer interview
Insights by AmbitionBox
- Python
- SQL
- Spark
- Azure
- Cloud
- SCALA
- Adf
- Data Modeling
Nishanth VK
Interview experience
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 -
Tech Mahindra Interviews By Designations
- Tech Mahindra Software Engineer Interview Questions
- Tech Mahindra Senior Software Engineer Interview Questions
- Tech Mahindra Customer Support Associate Interview Questions
- Tech Mahindra Customer Service Associate Interview Questions
- Tech Mahindra Associate Software Engineer Interview Questions
- Tech Mahindra Customer Care Executive Interview Questions
- Tech Mahindra Customer Service Executive Interview Questions
- Tech Mahindra Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Azure Administrator Interview Questions
- Azure DevOps Engineer Interview Questions
- Azure Developer Interview Questions
- Azure Cloud Engineer Interview Questions
- Azure Cloud Administrator Interview Questions
- Microsoft Azure Administrator Interview Questions
- Senior Azure Administrator Interview Questions
- Azure Support Engineer Interview Questions
- Show more
Tell us how to improve this page.
Interview Process at Tech Mahindra Azure Data Engineer
based on 3 interviews in last 1 year
Interview experience
4.7People 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
Tech Mahindra Azure Data Engineer
Salary
based on 237 salaries
Average annual salary
₹
7
Lakhs
₹3.2 L/yr
- ₹10.8 L/yr
21%
less
than the average Azure Data Engineer Salary in India
View more details
Tech Mahindra Azure Data Engineer Reviews and Ratings
based on 8 reviews
Rating in categories
3.2
Skill development
3.1
Work-Life balance
2.7
Salary & Benefits
2.6
Job Security
3.2
Company culture
2.2
Promotions/Appraisal
2.5
Work Satisfaction
|
Software Engineer
27k
salaries
|
₹5.9
Lakhs
₹1.7 L/yr - ₹9.1 L/yr |
|
Senior Software Engineer
22k
salaries
|
₹13.5
Lakhs
₹5.5 L/yr - ₹23 L/yr |
|
Technical Lead
11.9k
salaries
|
₹21.1
Lakhs
₹9.3 L/yr - ₹31 L/yr |
|
Team Lead
5.1k
salaries
|
₹11.4
Lakhs
₹3.6 L/yr - ₹19 L/yr |
|
Associate Software Engineer
4.9k
salaries
|
₹4
Lakhs
₹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 Interview Advice