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 Data Engineer Interview Questions, Process, and Tips for Experienced
Top Tech Mahindra Data Engineer Interview Questions and Answers for Experienced
- Q1. What is the SQL query to calculate the average sales over a period of 7 days?
- Q2. transformations in pyspark rank,dense rank
- Q3. Explain Data bricks architecture?
Tech Mahindra Data Engineer Interview Experiences for Experienced
6 interviews found
Anonymous
I appeared for an interview in Dec 2024.
(2 Questions)
- Q1. They asked me regarding project
- Q2. Sql queries and data bricks related questions
(1 Question)
- Q1. Details explaination on project that I have worked and optimization techniques
Interview Preparation Tips
(2 Questions)
- Q1. What is the SQL query to calculate the average sales over a period of 7 days?
- Ans.
Calculate average sales over a 7-day period using SQL query.
Use the AVG() function to calculate the average sales.
Filter the data based on the date range of the 7-day period using WHERE clause.
Group the data by date to calculate the average sales for each day.
Join the tables if necessary to get the sales data.
- Q2. Explain Data bricks architecture?
- Ans.
Data bricks architecture is a cloud-based big data processing platform that combines Apache Spark and Delta Lake.
Data bricks architecture includes Apache Spark for processing big data in a distributed environment.
It also incorporates Delta Lake for reliable data lakes and data warehousing.
Data bricks provides a collaborative workspace for data engineers, data scientists, and analysts.
It offers automated cluster managem...
Selected
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(2 Questions)
- Q1. Sql scenarios based questions
- Q2. Azure data engineering questions
What people are saying about Tech Mahindra
(1 Question)
- Q1. Mostly on cloud tools
Tech Mahindra interview questions for designations
I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.
(4 Questions)
- Q1. Constraints, joins
- Q2. Window functions
- Q3. Delete and truncate difference
- Ans.
Delete removes rows from a table while truncate removes all rows from a table
Delete is a DML command while truncate is a DDL command
Delete can be rolled back while truncate cannot be rolled back
Delete fires triggers on each row deletion while truncate does not fire triggers
- Q4. Query optimization
(1 Question)
- Q1. Deep into sql and coding
Skills evaluated in this interview
(2 Questions)
- Q1. About pyspark,data factory annd azuure sql
- Q2. Transformations in pyspark rank,dense rank
- Ans.
Rank and Dense Rank are transformations in PySpark used to assign ranks to rows based on a specific column.
Rank assigns unique ranks to each row based on the order of values in a specific column.
Dense Rank assigns ranks to each row based on the order of values in a specific column, but with no gaps between ranks.
Both transformations can be used with the 'over' function to specify the column to order by.
Example: df.sele...
(1 Question)
- Q1. Clusters,persistancy in pyspark,triggers in adf
Interview Preparation Tips
Skills evaluated in this interview
Data Engineer Jobs at Tech Mahindra
Interview questions from similar companies
I applied via Campus Placement and was interviewed in Aug 2020. There were 4 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Best sorting although and its working they asked
- Q2. Write a program to replace the character with another character in java.
- Ans.
A program to replace a character with another character in Java.
Create a string variable with the original text
Use the replace() method to replace the character with another character
Print the new string with the replaced character
- Q3. SQL queries on order by, group by, and it's difference they asked.
- Q4. Project management experience they asked.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Oct 2020. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. What is second level cache?How to implement second level cache?How to optimize sql query?what are solid principles?
- Ans.
Second level cache is a caching mechanism used to improve performance by storing frequently accessed data in memory.
Second level cache is implemented at the application level and can be configured using frameworks like Hibernate.
To optimize SQL queries, one can use indexes, avoid using SELECT *, and use JOINs instead of subqueries.
SOLID principles are a set of design principles for writing maintainable and scalable cod...
- Q2. Mostly FAQ but somewhat in depth?
- Q3. How to deploy application in aws?
- Ans.
To deploy an application in AWS, you need to create an EC2 instance, configure security groups, install necessary software, and upload your application code.
Create an EC2 instance in the desired region and select the appropriate instance type
Configure security groups to allow traffic to and from the instance
Install necessary software and dependencies on the instance
Upload your application code to the instance
Start the ...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed before Aug 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. What is my longterm and short-term goals.
- Ans. My short-term is to become an expert in solving queries And long term is to become valuable employee in an organisation and managing a team, also helping new recruits to learn the work.
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Dec 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. THERE WERE 4 ROUNDS.1-APTITUDE 2-PSEUDO TEST 2-TECHNICAL INTERVIEW 4-HR ROUND
- Q2. 1ST ROUND WAS VERY SIMPLE 2ND WAS LITTLE COMPLEX 3RD&4TH ROUND WAS VERY SIMPLE
Interview Preparation Tips
Tech Mahindra Interview FAQs
The duration of Tech Mahindra Data Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
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
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Tech Mahindra Data Engineer Interview Process for Experienced
based on 5 interviews
1 Interview rounds
- Technical Round
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Tech Mahindra Data Engineer Reviews and Ratings
based on 36 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 Data Engineer Interview Questions for Experienced
