Add office photos
i
Tech Mahindra
Compare
Filter interviews by
Tech Mahindra Associate Data Engineer Interview Questions and Answers
Tech Mahindra Associate Data Engineer Interview Experiences
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
Interview Questionnaire
1 Question
- Q1. How would you recommend customer to migrate on cloud
- Ans.
To recommend customers to migrate to the cloud, assess their current infrastructure, plan the migration strategy, choose the right cloud provider, and ensure data security.
Assess the customer's current infrastructure and identify the applications and data that can be migrated to the cloud.
Plan the migration strategy by considering factors like cost, time, and resource requirements.
Choose the right cloud provider based ...
Skills evaluated in this interview
30 multiple choice questions
There were many puzzles ,some english ,comp sci related questions
English-arrange sentence in order ,ram,dns server,preposition,smallest unit bit,modem,repeater,lan ,search engine
(2 Questions)
- Q1. What is dns ,www,http,domain name,ip address,html
- Ans.
DNS, WWW, HTTP, domain name, IP address, and HTML are all fundamental components of the internet.
DNS (Domain Name System) translates domain names into IP addresses.
WWW (World Wide Web) is a system of interlinked hypertext documents accessed via the internet.
HTTP (Hypertext Transfer Protocol) is the protocol used for transmitting data on the web.
A domain name is the human-readable address used to access websites (e.g. g...
- Q2. About yourself,family ,would you stay for a year
Skills evaluated in this interview
Basic logical and programming questions
(1 Question)
- Q1. Python and SQL basic questions
(1 Question)
- Q1. Salary and relocation discussion
It was easy and Little tricky to complete
(2 Questions)
- Q1. English knowledge related questions
- Q2. Why do you want to be a part of this company
Interview Preparation Tips
Yes
(2 Questions)
- Q1. What are your salary expectations?
- Q2. No
(2 Questions)
- Q1. Tell me about yourself.
- Q2. No
(2 Questions)
- Q1. Why should we hire you?
- Q2. No
(1 Question)
- Q1. No
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Situation based question on experience
Interview Preparation Tips
Senior Data Analyst Interview Questions & Answers
DXC Technology
Hemanth Kumar Arikatla
posted on 12 Aug 2021
Interview Questionnaire
2 Questions
- Q1. SQL questions
- Q2. Tableau questions
Tech Mahindra Interview FAQs
Some of the top questions asked at the Tech Mahindra Associate Data Engineer interview -
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
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
26.4k
salaries
|  ₹2 L/yr - ₹9 L/yr |
|
Senior Software Engineer
21.3k
salaries
| ₹5.5 L/yr - ₹23.4 L/yr |
|
Technical Lead
11.6k
salaries
| ₹9.2 L/yr - ₹37 L/yr |
|
Associate Software Engineer
5.5k
salaries
| ₹1.8 L/yr - ₹6 L/yr |
|
Team Lead
4.9k
salaries
| ₹5.2 L/yr - ₹17 L/yr |
Infosys
Cognizant
Accenture
Wipro
- Home >
- Interviews >
- Tech Mahindra Interview Questions >
- Tech Mahindra Associate Data Engineer Interview Questions
