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 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 Company Website and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Self introduction
Interview Preparation Tips
I appeared for an interview before Dec 2020.
(1 Question)
Round duration - 45 minutes
Round difficulty - Hard
All mcqs should answer with in time limit should have a lot of practice to solve in exam
- Q1.
Water Jug Problem Statement
You have two water jugs with capacities
XandYliters respectively, both initially empty. You also have an infinite water supply. The goal is to determine if it is possible to... - Ans.
The Water Jug Problem involves determining if a specific amount of water can be measured using two jugs of different capacities.
Start by considering the constraints and limitations of the problem.
Think about how the operations allowed can be used to reach the target measurement.
Consider different scenarios and test cases to come up with a solution.
Implement a function that takes the capacities of the jugs and the targe...
(1 Question)
Round duration - 60 minutes
Round difficulty - Easy
Easy and just basic questions very easy round
- Q1.
Matrix Multiplication Task
Given two sparse matrices
MAT1andMAT2of integers with dimensions 'N' x 'M' and 'M' x 'P' respectively, the goal is to determine the resulting matrix produced by their multipl... - Ans.
Implement a function to multiply two sparse matrices and return the resulting matrix.
Create a function that takes two sparse matrices as input and returns the resulting matrix after multiplication.
Iterate through the non-zero elements of the matrices to perform the multiplication efficiently.
Ensure to handle the sparse nature of the matrices to optimize the multiplication process.
Consider the constraints provided to en...
Interview Preparation Tips
Tip 1 : preapre core subjects
Tip 2 : be confident and answer clearly
Tip 3 : be strong with projects
Tip 1 : good projects in ml and ai
Tip 2 : practical experience
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. What is flexbox
- Ans.
Flexbox is a CSS layout module that allows for flexible and responsive web design.
Flexbox allows for easy alignment and positioning of elements within a container.
It uses a set of properties to define the layout, such as display: flex and flex-direction.
Flexbox is particularly useful for creating responsive designs that adapt to different screen sizes.
It can also be used in combination with other CSS layout modules, su...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Aug 2020. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. What is a bit
- Q2. What us the size of a bit
- Ans.
A bit is the smallest unit of digital information. It can have a value of either 0 or 1.
A bit is a binary digit, represented as either 0 or 1.
It is the basic unit of information used in computing and digital communications.
A group of 8 bits is called a byte.
The size of a bit is dependent on the architecture of the computer system.
- Q3. How many bits are there in C
- Ans.
C is a programming language and does not have a fixed number of bits.
C is a high-level programming language that can be compiled to run on different architectures with varying bit sizes.
The number of bits in C depends on the hardware architecture it is compiled for.
For example, C code compiled for a 32-bit architecture will have 32-bit integers, while code compiled for a 64-bit architecture will have 64-bit integers.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Nov 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Basic question on testing, selenium, java, sql, agile, topics from resume
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Networking
Interview Questionnaire
4 Questions
- Q1. Oops concept,
- Q2. Heritance
- Q3. Polyorphis
- Q4. Thread
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Aptitude, coding
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 Customer Support Associate Interview Questions
- Tech Mahindra Associate Software Engineer 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
- 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
Tech Mahindra Data Engineer 1 Interview Process
based on 2 interviews
Interview experience
Data Engineer 1 Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
26.4k
salaries
|  ₹2 L/yr - ₹9.4 L/yr |
|
Senior Software Engineer
21.6k
salaries
| ₹5.5 L/yr - ₹23.4 L/yr |
|
Technical Lead
11.9k
salaries
| ₹9.6 L/yr - ₹38 L/yr |
|
Associate Software Engineer
5.7k
salaries
| ₹1.8 L/yr - ₹5.9 L/yr |
|
Team Lead
5k
salaries
| ₹5.3 L/yr - ₹17.5 L/yr |
Infosys
Cognizant
Accenture
Wipro
- Home >
- Interviews >
- Tech Mahindra Interview Questions >
- Tech Mahindra Data Engineer 1 Interview Questions
