AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Tech Mahindra
Compare
Filter interviews by
Clear (1)
Tech Mahindra Azure Data Engineer Interview Questions, Process, and Tips
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 methods do you use to transfer data from on-premises storage to Azure Data Lake Storage Gen2?
Tech Mahindra Azure Data Engineer Interview Experiences
6 interviews found
Anonymous
Selected
I was interviewed in Jan 2025.
(2 Questions)
- Q1. SQL medium questions to be done in Pyspark parallely.
- Q2. Datafactory and other azure resources scenario based
(1 Question)
- Q1. Project discussion with the team lead and manager
(1 Question)
- Q1. Technical and general discussion
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
Niranjan Reddy
Selected
I was interviewed in Dec 2024.
(2 Questions)
- Q1. What are the optimization techniques used in Spark?
- Q2. What methods do you use to transfer data from on-premises storage to Azure Data Lake Storage Gen2?
(1 Question)
- Q1. Types of joins and spark queries
(1 Question)
- Q1. What is your willingness to work in a firm office environment?
What people are saying about Tech Mahindra
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
(5 Questions)
- Q1. Project Architecture, spark transformations used?
- Ans.
The project architecture includes Spark transformations for processing large volumes of data.
Spark transformations are used to manipulate data in distributed computing environments.
Examples of Spark transformations include map, filter, reduceByKey, join, etc.
- Q2. Advanced SQL questions - highest sales from each city
- Ans.
Use window functions like ROW_NUMBER() to find highest sales from each city in SQL.
Use PARTITION BY clause in ROW_NUMBER() to partition data by city
Order the data by sales in descending order
Filter the results to only include rows with row number 1
- Q3. Data modelling - Star schema, Snowflake schema, Dimension and Fact tables
- Q4. Databricks - how to mount?
- Ans.
Databricks can be mounted using the Databricks CLI or the Databricks REST API.
Use the Databricks CLI command 'databricks fs mount' to mount a storage account to a Databricks workspace.
Alternatively, you can use the Databricks REST API to programmatically mount storage.
- Q5. Questions on ADF - pipeline used in the project
(1 Question)
- Q1. Questions on Databricks - optimizations, history, autoloader, liquid clustering, autoscaling
Skills evaluated in this interview
Tech Mahindra interview questions for designations
It was a SQL-related question that required you to solve the problem.
Interview Preparation Tips
Get interview-ready with Top Tech Mahindra Interview Questions
Kumar Gaurav
(1 Question)
- Q1. What is incremental load. What is partition and bucketing. Spark archtecture
- Ans.
Incremental load is the process of loading only new or updated data into a data warehouse, rather than reloading all data each time.
Incremental load helps in reducing the time and resources required for data processing.
It involves identifying new or updated data since the last load and merging it with the existing data.
Common techniques for incremental load include using timestamps or change data capture (CDC) mechanis...
(1 Question)
- Q1. Scenario based question on spark performance optimization.
Skills evaluated in this interview
Azure Data Engineer Jobs at Tech Mahindra
Interview questions from similar companies
I applied via Company Website and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. SCD type 1 and SCD type 2 in databircks
- Q2. How to pass parameters form ADF to ADB
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(5 Questions)
- Q1. Tell me about yourself
- Ans. Tell about your background and current project work
- Q2. What is azure data factory
- Ans.
Azure Data Factory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
Azure Data Factory is used to move and transform data from various sources to destinations.
It supports data integration and orchestration of workflows.
You can monitor and manage data pipelines using Azure Data Factory.
It provides a visual interface for designing and monitoring data pipelines.
Azure...
- Q3. What is Azure data lake
- Ans.
Azure Data Lake is a scalable data storage and analytics service provided by Microsoft Azure.
Azure Data Lake Store is a secure data repository that allows you to store and analyze petabytes of data.
Azure Data Lake Analytics is a distributed analytics service that can process big data using Apache Hadoop and Apache Spark.
It is designed for big data processing and analytics tasks, providing high performance and scalabili
- Q4. 2nd highest salary from employee table
- Q5. What is index in table
- Ans.
An index in a table is a data structure that improves the speed of data retrieval operations on a database table.
Indexes are used to quickly locate data without having to search every row in a table.
They can be created on one or more columns in a table.
Examples of indexes include primary keys, unique constraints, and non-unique indexes.
Interview Preparation Tips
- Adf
Skills evaluated in this interview
Selected
I applied via Naukri.com
(4 Questions)
- Q1. Based on my previous company projects
- Q2. SQL based questions are asked
- Q3. ADF based questions are asked
- Q4. Azure related questions are asked
(1 Question)
- Q1. Reg salary discussion
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There was 1 interview round.
(4 Questions)
- Q1. How are you connecting your onPerm from Azure?
- Ans.
I connect onPrem to Azure using Azure ExpressRoute or VPN Gateway.
Use Azure ExpressRoute for private connection through a dedicated connection.
Set up a VPN Gateway for secure connection over the internet.
Ensure proper network configurations and security settings.
Use Azure Virtual Network Gateway to establish the connection.
Consider using Azure Site-to-Site VPN for connecting onPremises network to Azure Virtual Network.
- Q2. What is Autoloader in Databricks?
- Ans.
Autoloader in Databricks is a feature that automatically loads new data files as they arrive in a specified directory.
Autoloader monitors a specified directory for new data files and loads them into a Databricks table.
It supports various file formats such as CSV, JSON, Parquet, Avro, and ORC.
Autoloader simplifies the process of ingesting streaming data into Databricks without the need for manual intervention.
It can be ...
- Q3. How do you normalize your Json data
- Ans.
Json data normalization involves structuring data to eliminate redundancy and improve efficiency.
Identify repeating groups of data
Create separate tables for each group
Establish relationships between tables using foreign keys
Eliminate redundant data by referencing shared values
- Q4. How do you read from Kafka?
Interview Preparation Tips
Skills evaluated in this interview
Tech Mahindra Interview FAQs
Some of the top questions asked at the Tech Mahindra Azure Data Engineer interview -
Recently Viewed
DESIGNATION
Pyspark Developer
25 interviews
REVIEWS
HGS
No Reviews
INTERVIEWS
Tech Mahindra
No Interviews
INTERVIEWS
Cognizant
No Interviews
INTERVIEWS
Cognizant
No Interviews
INTERVIEWS
Cognizant
No Interviews
INTERVIEWS
Tech Mahindra
No Interviews
INTERVIEWS
Tech Mahindra
No Interviews
INTERVIEWS
Cognizant
No Interviews
INTERVIEWS
Tech Mahindra
No Interviews
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 Support Associate Interview Questions
- Tech Mahindra Customer Service Executive 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
based on 7 interviews
2 Interview rounds
- Technical Round - 1
- Technical Round - 2
HCLTech
Find your spark at a global tech company that values your every skill
Azure Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Tech Mahindra Azure Data Engineer Reviews and Ratings
based on 12 reviews
Rating in categories
|
Software Engineer
26.4k
salaries
|  ₹2 L/yr - ₹9.2 L/yr |
|
Senior Software Engineer
21.4k
salaries
| ₹5.5 L/yr - ₹23 L/yr |
|
Technical Lead
11.7k
salaries
| ₹9.5 L/yr - ₹38 L/yr |
|
Associate Software Engineer
5.5k
salaries
| ₹1.8 L/yr - ₹8.2 L/yr |
|
Team Lead
5k
salaries
| ₹5.2 L/yr - ₹17 L/yr |
Infosys
Cognizant
Accenture
Wipro
- Home >
- Interviews >
- Tech Mahindra Interview Questions >
- Tech Mahindra Azure Data Engineer Interview Questions
