AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Tech Mahindra
Compare
Filter interviews by
Tech Mahindra Azure Data Engineer Interview Questions and Answers for Freshers
Tech Mahindra Azure Data Engineer Interview Experiences for Freshers
1 interview found
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed in Aug 2024. There were 3 interview rounds.
(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?
- Ans.
The output after inner join of table 1 and table 2 will be 2,3,5.
Inner join only includes rows that have matching values in both tables.
Values 2, 3, and 5 are present in both tables, so they will be included in the output.
Null values are not considered as matching values in inner join.
- 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 placed the maximum orders. if more than one person...
- Q3. Spark Architecture, Optimisation techniques
- Q4. Some personal questions.
(5 Questions)
- Q1. Explain the entire architecture of a recent project you are working on in your organisation.
- Ans.
The project involves building a data pipeline to ingest, process, and analyze large volumes of data from various sources in Azure.
Utilizing Azure Data Factory for data ingestion and orchestration
Implementing Azure Databricks for data processing and transformation
Storing processed data in Azure Data Lake Storage
Using Azure Synapse Analytics for data warehousing and analytics
Leveraging Azure DevOps for CI/CD pipeline aut
- Q2. How do you design an effective ADF pipeline and what all metrics and considerations you should keep in mind while designing?
- Ans.
Designing an effective ADF pipeline involves considering various metrics and factors.
Understand the data sources and destinations
Identify the dependencies between activities
Optimize data movement and processing for performance
Monitor and track pipeline execution for troubleshooting
Consider security and compliance requirements
Use parameterization and dynamic content for flexibility
Implement error handling and retries fo
- 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?
- 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)
- 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 both have the similar functionality for few ...
(1 Question)
- Q1. Basic HR questions
Interview Preparation Tips
- SQL
- Databricks
- Azure Data Factory
- Pyspark
- Spark
Skills evaluated in this interview
Azure Data Engineer Jobs at Tech Mahindra
Interview questions from similar companies
Interview Questionnaire
1 Question
- Q1. A-Z in MySQL, programming languages(only concepts)
I applied via Campus Placement and was interviewed before Mar 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Basics about .Net and SQl server
- Q2. What are triggers
- Ans.
Triggers are database objects that automatically execute in response to certain events or changes in data.
Triggers are used to enforce business rules or data integrity.
They can be used to audit changes to data.
Triggers can be set to execute before or after an event, such as an insert, update, or delete operation.
They can be defined on tables, views, or schemas.
Examples of triggers include sending an email notification ...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Java Basic questions and Git
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Aug 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Interfaces
- Q2. Oop concepts
Interview Preparation Tips
I applied via Walk-in and was interviewed in Aug 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. They ask only basics of programming languages which are mentioned in resume
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Sep 2021. There were 4 interview rounds.
Prepare normal for aptitude - maths, quant, analytic
My GD topic was Is internet good for students or not
I didn't attempt this as I was noob back in third year Engg
(1 Question)
- Q1. Basic questions can you relocate, tell me about ur GD and composition
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. General and logical
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Drupal data migration
I applied via Naukri.com and was interviewed before Feb 2021. There were 5 interview rounds.
(1 Question)
- Q1. They asked some technical questions.
(1 Question)
- Q1. They have asked some management questions because this was the managerial round.
(4 Questions)
- Q1. What are your salary expectations?
- Q2. What is your family background?
- Q3. Share details of your previous job.
- Q4. Tell me about yourself.
Interview Preparation Tips
Tech Mahindra Interview FAQs
Some of the top questions asked at the Tech Mahindra Azure Data Engineer interview for freshers -
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 Customer Support Associate Interview Questions
- Tech Mahindra Customer Service Executive Interview Questions
- Tech Mahindra Associate Software Engineer 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
Tech Mahindra Azure Data Engineer Interview Process for Freshers
based on 1 interview
Interview experience
Azure Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Tech Mahindra Azure Data Engineer Reviews and Ratings
based on 15 reviews
Rating in categories
|
Software Engineer
26.4k
salaries
|  ₹2 L/yr - ₹9.5 L/yr |
|
Senior Software Engineer
21.6k
salaries
| ₹5.5 L/yr - ₹23.5 L/yr |
|
Technical Lead
11.9k
salaries
| ₹9.6 L/yr - ₹38.5 L/yr |
|
Associate Software Engineer
5.7k
salaries
| ₹1.8 L/yr - ₹5.9 L/yr |
|
Team Lead
5.1k
salaries
| ₹5.3 L/yr - ₹17.5 L/yr |
Infosys
Cognizant
Accenture
Wipro
- Home >
- Interviews >
- Tech Mahindra Interview Questions >
- Tech Mahindra Azure Data Engineer Interview Questions for Fresher
