Tech Mahindra Interview Questions, Process, and Tips

• Q1. Lets say you have table 1 with values 1,2,3,5,null,null,0 and table 2 has null,2,4,7,3,5 What would be the output after inner join? View Answers (1)
• Q2. Lets say you have customers table with customerID and customer name, Orders table with OrderId and CustomerID. write a query to find the customer name who place...read more Add Answer
• Q3. Spark Architecture, Optimisation techniques Add Answer
• Q4. Some personal questions. Add Answer

• Q1. Explain the entire architecture of a recent project you are working on in your organisation. View Answers (1)
• Q2. How do you design an effective ADF pipeline and what all metrics and considerations you should keep in mind while designing? View Answers (1)
• Q3. Lets say you have a very huge data volume and in terms of performance how would you slice and dice the data in such a way that you can boost the performance? Add Answer
• Q4. Lets say you have to reconstruct a table and we have to preserve the historical data ? ( i couldnt answer that but please refer to SCD) Add Answer
• Q5. We have adf and databricks both, i can achieve transformation , fetching the data and loading the dimension layer using adf also but why do we use databricks if...read more Add Answer

• Q1. Basic HR questions Add Answer

1. *Define Your Goals*: Clearly identify the type of job you're looking for and your long-term career opportunities

1. *Verbal Aptitude:* Tests language skills, reading comprehension, and vocabulary.
2. *Numerical Aptitude:* Assesses mathematical skills, problem-solving, and data interpretation.
3. *Logical Reasoning:* Evaluates ability to think critically, make decisions, and solve problems.
4. *Spatial Aptitude:* Tests visual and spatial skills, including pattern recognition and mental imagery.
5. *Mechanical Aptitude:* Assesses understanding of mechanical concepts, tools, and processes.
6. *Clerical Aptitude:* Evaluates attention to detail, organizational skills, and data entry accuracy.

*Aptitude Test Formats:*

1. *Multiple-Choice Questions:* Most aptitude tests use multiple-choice questions.
2. *True or False:* Some tests use true or false questions.
3. *Fill-in-the-Blank:* Some tests use fill-in-the-blank questions.

*Aptitude Test Scoring:*

1. *Raw Score:* The number of correct answers.
2. *Scaled Score:* A standardized score based on the raw score.
3. *Percentile Rank:* A score showing how you performed compared to others.

*Tips for Taking Aptitude Tests:*

1. *Practice:* Familiarize yourself with the test format and question types.
2. *Time Management:* Make the most of the time allowed.
3. *Stay Calm:* Relax and focus on the questions.
4. *Read Instructions:* Carefully read and follow the instructions.

*Common Aptitude Tests:*

1. *SAT (Scholastic Assessment Test)*
2. *ACT (American College Testing)*
3. *GRE (Graduate Record Examinations)*
4. *GMAT (Graduate Management

• Q1. Be honest and authentic in response Add Answer
• Q2. Show enthusiasm and interest in the company and role Add Answer
• Q3. Highlight relevant skill and experience Add Answer

• Q1. Given UI task display like display boxes side by side in desktop screen and one after the other in mobile screen using media queries? Add Answer
• Q2. Explain difference between authorization vs authentication? View Answers (1)
• Q3. How to render list in react? Also explain difference between state vs prop in react? View Answers (1)

• Q1. What are the webpage optimization techniques? How to check webpage optimization? In lighthouse optimization reports , how to fix issue related render blocking s...read more View Answers (1)
• Q2. Write scss code nested li element by applying background color 2 element and also use mixins? View Answers (1)
• Q3. How to fix cumulative layout shift issues? View Answers (1)

This round was online in college premises. Aptitude test was easy-medium and comprises of all types of questions ranging from numeric ability to series to english ability and images question

After completion of aptitude, result was shown on the screen instantly and those who were qualified were given programming test which comprises of psychometric test, Computer fundamentals, computer network and 2 coding question. Coding questions were easy one was on String, another on array based

• Q1. After results were announced of round 1 and 2. Selected Students gave this round. This was basic Speaking ability test where they gave some sentences and our ta...read more Add Answer

• Q1. After Communication round within 1.5 week Interview was Scheduled. Interview was easy, many things depends on your Resume. I had mentioned Java in my resume tha...read more Add Answer
• Q2. Features of java Add Answer
• Q3. What is byte code Add Answer
• Q4. What is wrapper classes and its syntax Add Answer
• Q5. What is multithreading Add Answer
• Q6. How to connect to mongoDB with code Add Answer
• Q7. What is github and git Add Answer

• Q1. Tell about yourself Add Answer
• Q2. Who all are there in family Add Answer
• Q3. Why do you want to join Tech M Add Answer
• Q4. All other HR basic question Add Answer