Add office photos
i
Tech Mahindra
Compare
Filter interviews by
Tech Mahindra Associate Data Engineer Interview Questions and Answers for Experienced
Tech Mahindra Associate Data Engineer Interview Experiences for Experienced
1 interview found
Anonymous
I applied via Recruitment Consultant and was interviewed in Feb 2021. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. #3 interviews were there 1. Basic Telephonic all basic questions were there then 2. zoom video for detaled code and sql queries 3. advanced for algo designing and case analysis questions.All related to had...
- Q2. Basic question and coding is answered as per knowledge and experience. Advance questions is totally based on aptitude . reasonng and decision making skills
- Q3. Why TechMahindra guys conduct interviews if after selecting all technical round they dnt have any offer to give. And make it as hold.
Interview Preparation Tips
Interview questions from similar companies
Selected
I applied via campus placement at RC Patel College of Education, Shirpur and was interviewed in Oct 2024. There were 3 interview rounds.
There are some general aptitude questions.
There were two simple codes from which we need to pass the test case for at least one code
(3 Questions)
- Q1. Tell me about your project
- Q2. What was the difficut subject in college
- Ans.
The most difficult subject in college was Advanced Calculus.
Advanced Calculus involved complex mathematical concepts and required a deep understanding of calculus principles.
The subject required a lot of practice and problem-solving skills to master the concepts.
Topics such as multivariable calculus, differential equations, and vector calculus were particularly challenging.
The abstract nature of the subject made it dif...
- Q3. Tell me about yourself
- Ans.
I am a recent graduate with a degree in Computer Science and a passion for data engineering.
Graduated with a degree in Computer Science
Strong interest in data engineering
Completed internships in data analysis and database management
Interview Questionnaire
5 Questions
- Q1. How to find 3rd Highest salary in Sql.
- Q2. How to delete duplicate rows in Sql
- Ans.
Deleting duplicate rows in SQL
Use the DISTINCT keyword in SELECT statement to retrieve unique rows
Use GROUP BY clause to group rows with same values and then use aggregate functions to select one row
Use the ROW_NUMBER() function to assign a unique number to each row and then delete the rows with duplicate numbers
- Q3. Datastge - How will you remove Header and trailer from Sequential data file
- Ans.
To remove header and trailer from a sequential data file in Datastage.
Use Sequential File stage in Datastage.
Set the 'Skip Rows' property to the number of header rows to be skipped.
Set the 'Trailer Rows' property to the number of trailer rows to be skipped.
Use a Transformer stage to remove any remaining header or trailer rows.
Use the 'Remove' function in the Transformer stage to remove the rows.
- Q4. How would you kill any job in Datastage
- Ans.
To kill a job in Datastage
Stop the job manually from the Director client
Terminate the job from the command line using the dsjob command
Kill the job process from the operating system level
Delete the job from the Datastage repository
- Q5. How to find process id in linux
- Ans.
To find process id in Linux, use the command 'ps -aux | grep
' Open the terminal
Type 'ps -aux' to list all running processes
Use 'grep
' to filter the process you are looking for The process id (PID) will be listed in the second column
Skills evaluated in this interview
Selected
I applied via Naukri.com
(2 Questions)
- Q1. Aws sevices you have worked on
- Ans.
I have worked on various AWS services including S3, EC2, Lambda, Glue, and Redshift.
S3 - Used for storing and retrieving data
EC2 - Used for running virtual servers
Lambda - Used for serverless computing
Glue - Used for ETL (Extract, Transform, Load) processes
Redshift - Used for data warehousing and analytics
- Q2. Question on python list and dictionary
(1 Question)
- Q1. Questions on project and skillset
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. Machine learning related questions and the theory of its operation
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell. me about youself
- Q2. Sql question , pyspark questions
Selected
I applied via Naukri.com and was interviewed in Aug 2023. There were 4 interview rounds.
I will do tha study for all company cases
I will give aptitude test
(7 Questions)
- Q1. I will try to solved all technical issue
- Q2. Asked tha questions to releted data entry operator
- Q3. I take my work time
- Q4. Slove tha query who give me dara
- Q5. Give any response to short time
- Ans.
Respond promptly with concise information
Provide relevant details quickly
Avoid unnecessary elaboration
Be clear and concise in communication
- Q6. Asked how to do group discussion.
- Q7. How can slove tha all data questions
Interview Preparation Tips
Daniyal Shaikh
(1 Question)
- Q1. Data Sceince related questions
Basic Questions on python related to strings
(2 Questions)
- Q1. What method to reduce time complexity
- Q2. Which technology will suit a particylar situation
- Ans.
Choosing the right technology depends on the specific requirements of the situation.
Consider the data size and complexity
Evaluate the processing speed and scalability
Assess the cost and availability of the technology
Take into account the skillset of the team
Examples: Hadoop for big data, Spark for real-time processing, AWS for cloud-based solutions
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Sep 2022. There were 2 interview rounds.
(2 Questions)
- Q1. This is any questions. Computer basic knowledge. Data entry Opreter.
- Q2. Advance excel knowledge.
Interview Preparation Tips
Tech Mahindra Interview FAQs
Some of the top questions asked at the Tech Mahindra Associate Data Engineer interview for experienced candidates -
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 Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Scientist Interview Questions
- Associate Data Analyst Interview Questions
- Data Associate Interview Questions
- Senior Data Engineer Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
26.3k
salaries
|  ₹2 L/yr - ₹9.1 L/yr |
|
Senior Software Engineer
21.2k
salaries
| ₹5.5 L/yr - ₹22.5 L/yr |
|
Technical Lead
11.5k
salaries
| ₹9.1 L/yr - ₹38 L/yr |
|
Associate Software Engineer
5.4k
salaries
| ₹1.8 L/yr - ₹6 L/yr |
|
Team Lead
4.9k
salaries
| ₹5.1 L/yr - ₹16.8 L/yr |
Infosys
Cognizant
Accenture
Wipro
Calculate your in-hand salary
- Home >
- Interviews >
- Tech Mahindra Interview Questions >
- Tech Mahindra Associate Data Engineer Interview Questions for Experienced
