i
Tech Mahindra
Filter interviews by
I appeared for an interview in Jan 2025.
I applied via Recruitment Consulltant and was interviewed in Aug 2024. There were 3 interview rounds.
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.
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
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
I appeared for an interview in Dec 2024.
Optimization techniques in Spark improve performance and efficiency of data processing.
Partitioning data to distribute workload evenly
Caching frequently accessed data in memory
Using broadcast variables for small lookup tables
Avoiding shuffling operations whenever possible
Tuning configuration settings like memory allocation and parallelism
Methods to transfer data from on-premises storage to Azure Data Lake Storage Gen2
Use Azure Data Factory to create pipelines for data transfer
Utilize Azure Data Box for offline data transfer
Leverage Azure Storage Explorer for manual data transfer
Implement Azure Data Migration Service for large-scale data migration
Types of joins include inner, outer, left, right, and full joins in Spark queries.
Inner join: Returns rows that have matching values in both tables
Outer join: Returns all rows when there is a match in one of the tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
Full join: Returns rows w
I am willing to work in a firm office environment.
I am comfortable working in a structured office setting
I value collaboration and communication with colleagues
I am adaptable to different office environments and cultures
What people are saying about Tech Mahindra
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
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.
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
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.
Tech Mahindra interview questions for designations
It was a SQL-related question that required you to solve the problem.
Get interview-ready with Top Tech Mahindra Interview Questions
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...
I applied via Naukri.com and was interviewed before Oct 2020. There were 4 interview rounds.
I applied via Referral and was interviewed in Dec 2020. There were 3 interview rounds.
Some of the top questions asked at the Tech Mahindra Azure Data Engineer interview -
based on 7 interviews
2 Interview rounds
based on 12 reviews
Rating in categories
Software Engineer
26.4k
salaries
| ₹2 L/yr - ₹9.3 L/yr |
Senior Software Engineer
21.5k
salaries
| ₹5.5 L/yr - ₹23 L/yr |
Technical Lead
11.8k
salaries
| ₹9.5 L/yr - ₹38 L/yr |
Associate Software Engineer
5.6k
salaries
| ₹1.8 L/yr - ₹5.8 L/yr |
Team Lead
5k
salaries
| ₹5.3 L/yr - ₹17.3 L/yr |
Infosys
Cognizant
Accenture
Wipro