Add office photos
i
Tech Mahindra
Compare
Filter interviews by
Tech Mahindra Data Engineer 1 Interview Questions and Answers
Tech Mahindra Data Engineer 1 Interview Experiences
2 interviews found
Anonymous
(1 Question)
- Q1. Difference between Delete and Truncate
- Ans.
Delete removes specific rows from a table, while Truncate removes all rows from a table.
Delete is a DML operation, while Truncate is a DDL operation.
Delete can be rolled back, while Truncate cannot be rolled back.
Delete operation is slower compared to Truncate operation.
Delete operation maintains the integrity constraints, triggers, and indexes, while Truncate does not.
Skills evaluated in this interview
Selected
I applied via Walk-in and was interviewed before Jun 2023. There was 1 interview round.
(2 Questions)
- Q1. What are joins and types, number of cols after all types of joins...
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include inner join, outer join (left, right, full), and cross join.
Number of columns after join depends on the type of join and the columns being selected.
For example, an inner join will only include rows that have matching values in both tables, resulting in a combined table with columns from both tables.
A left...
- Q2. What are the window functions ...
- Ans.
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate cumulative sums, averages, ranks, and more.
They operate on a set of rows related to the current row, known as the window frame.
Examples include ROW_NUMBER(), RANK(), SUM() OVER(), and AVG() OVER().
Skills evaluated in this interview
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
(2 Questions)
- Q1. How many types of integration runtime is present
- Ans.
There are three types of integration runtime: Self-hosted, Azure, and SSIS
Self-hosted integration runtime is installed on a local machine or a virtual machine within an on-premises network
Azure integration runtime is managed by Azure Data Factory and runs in the Azure cloud
SSIS integration runtime is used to run SQL Server Integration Services packages in Azure Data Factory
- Q2. How many types of trigger are there in Adf
- Ans.
There are two types of triggers in Azure Data Factory: Schedule-based triggers and Event-based triggers.
Schedule-based triggers are based on a time schedule and can be set to run at specific intervals.
Event-based triggers are triggered by events such as the completion of a pipeline run or the arrival of new data.
Triggers can be used to automate the execution of pipelines in Azure Data Factory.
(2 Questions)
- Q1. About my experience of leading a team in my previous company
- Q2. Why I choose Accenture
- Ans.
I chose Accenture for its reputation, global presence, and opportunities for growth.
Accenture is a renowned company known for its innovative solutions and cutting-edge technology.
The global presence of Accenture provides opportunities to work on diverse projects and collaborate with experts from around the world.
Accenture offers ample opportunities for career growth and development through training programs and mentors...
Skills evaluated in this interview
(1 Question)
- Q1. They asked related to sql unix
Selected
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
(1 Question)
- Q1. What is use of python in your Projrct ?
- Ans.
Python is used in our project for data processing, analysis, and visualization.
Python is used for data cleaning and transformation tasks.
Python libraries like Pandas and NumPy are used for data manipulation.
Python is used for creating data visualizations using libraries like Matplotlib and Seaborn.
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed before Apr 2023. There were 2 interview rounds.
MCQ based technical questions they have asked. Covering most of the basic abinitio components
(1 Question)
- Q1. Technical questions like scd types ,rollup normalise join scenarios.
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed before May 2023. There was 1 interview round.
(1 Question)
- Q1. Basic Azure Data Engineer Questions, focused mainly on SQL
Selected
I applied via Campus Placement and was interviewed before Aug 2022. There were 5 interview rounds.
Aptitude Questions related to Basic Quanitative aptitue, psuedo code snippets,Computer Fundamental Questions, Related to Operating System
There are 3 coding question
1.Easy (Related to Arrays)
2.Medium(String related questions)
3.Medium(Stack related questions)
(1 Question)
- Q1. 1.Introduction 2.Discussion about my projects 3.Questions on some terms which was mentioned in my project 4.One easy level coding questions 5. Two sql questions related to Join Logic 6.Some questions relat...
(1 Question)
- Q1. Mainly for Document Verification
Interview Preparation Tips
Divya Shah
Selected
I applied via Company Website and was interviewed before Mar 2023. There were 2 interview rounds.
Basic question were asked, it was quite simple if you are from computer background you can pass easily
2 coding questions were there, if you are aware of concepts array, pointers, memory management it will be simple
Selected
I applied via Campus Placement and was interviewed before Jan 2023. There was 1 interview round.
(2 Questions)
- Q1. Are you ready to relocate
- Q2. What's your salary expectation
Interview Preparation Tips
Tech Mahindra Interview FAQs
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 Service Executive Interview Questions
- Tech Mahindra Customer Support Associate Interview Questions
- Tech Mahindra Customer Care Executive Interview Questions
- Tech Mahindra Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Engineer Interview Questions
- Data Analyst Interview Questions
- Senior Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Azure Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Show more
People are getting interviews through
Data Engineer 1 Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
26.3k
salaries
|  ₹2 L/yr - ₹10.7 L/yr |
|
Senior Software Engineer
21.3k
salaries
| ₹5.5 L/yr - ₹22.9 L/yr |
|
Technical Lead
11.6k
salaries
| ₹9.5 L/yr - ₹31.9 L/yr |
|
Associate Software Engineer
5.4k
salaries
| ₹1.8 L/yr - ₹6 L/yr |
|
Team Lead
4.9k
salaries
| ₹5.2 L/yr - ₹16.9 L/yr |
Infosys
Cognizant
Accenture
Wipro
Calculate your in-hand salary
- Home >
- Interviews >
- Tech Mahindra Interview Questions >
- Tech Mahindra Data Engineer 1 Interview Questions
