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 Senior Consultant Interview Questions and Answers
Tech Mahindra Senior Consultant Interview Experiences
7 interviews found
Anonymous
(1 Question)
- Q1. What is index in SQL?
- Ans.
Indexes in SQL are data structures that improve the speed of data retrieval operations on a database table.
Indexes are created on columns in a table to quickly retrieve rows based on the values in those columns.
They can be unique, meaning that the index will enforce uniqueness on the column values.
Indexes can also be composite, where multiple columns are included in the index.
Examples of indexes include primary keys, u
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(1 Question)
- Q1. Basics of the Magento, php ,mysql and git
Interview Preparation Tips
He assigned me a problem-solving quesiton with a certain time limit after just a minute he said
this beyond the capacity and you won't be able to solve it. He lacked the communication as well.
It felt like I was giving interview for an start-up third tier city
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. Past experience
- Q2. What are the biggest challenges in the industry and how would you tackle them
- Ans.
The biggest challenges in the industry include rapid technological advancements, changing regulations, and increasing competition.
Keeping up with rapid technological advancements to stay competitive
Navigating changing regulations and compliance requirements
Managing increased competition from new entrants and existing players
Interview Preparation Tips
What people are saying about Tech Mahindra
I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.
(3 Questions)
- Q1. About azure Active Directory
- Q2. About azure Active Directory user directory roles
- Q3. Not applicable for me
(1 Question)
- Q1. Not applicable for me
Tech Mahindra interview questions for designations
Selected
I applied via Referral and was interviewed before Jan 2023. There were 2 interview rounds.
(1 Question)
- Q1. Core Skill related like SCM
(1 Question)
- Q1. Your current and expected Salary related
Interview Preparation Tips
- Core skill
- SAP
I applied via AmbitionBox and was interviewed in Jul 2022. There were 4 interview rounds.
Online test for 30 mins, consists of voice, reasoning and analytical questions.
(1 Question)
- Q1. Round taken by the Operation Manager.
(1 Question)
- Q1. Final discussion on salary, joining date, facilities and reporting time and etc.
Interview Preparation Tips
(5 Questions)
- Q1. What are your salary expectations?
- Q2. Share details of your previous job.
- Q3. Why should we hire you?
- Q4. Why are you looking for a change?
- Q5. Tell me about yourself.
(1 Question)
- Q1. What value have you added to your org in your prev role?
Interview Preparation Tips
Interview questions from similar companies
(6 Questions)
- Q1. What are some of the Design Patterns you have worked with?
- Q2. What is your approach for a issue you came to know happened in Production.
- Q3. If given a chance to lead a team will you take it up as a challenge of not how would you tackle it?
- Q4. Are you able to work under pressure. How do you manage?
- Q5. What do you understand by SOLID principle? Why do you think it is important.
- Q6. Please solve the coding question provided ( a moderately difficult coding question provided). Help understand your approach and why you chose same. Explain edge caes if possible.
Interview Preparation Tips
Be able to demonstrate through practical approach.
Keep your theoretical approach flexible and more inclined with positive response than bluffing.
Keep confidence at core of and have a good communication practice.
Adhere to Interview rules for example be available with 1 working editor for coding or technical rounds. Be professional in your appearance and always refrain from asking feedback in the interview itself.
I applied via Company Website and was interviewed in Dec 2024. There was 1 interview round.
(8 Questions)
- Q1. Nth higest salary query in sql
- Q2. Constraints
- Q3. Delete drop truncate
- Q4. Identity column
- Q5. Ref and out
- Q6. Polymorphism code
- Q7. Inheritance, interface, abstract class,access modifiers, solid principles,design patterns
- Q8. Remove duplicates from an array
- Ans.
Remove duplicates from an array of strings
Create a Set to store unique elements
Iterate through the array and add each element to the Set
Convert the Set back to an array to get the unique elements
Interview Preparation Tips
I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.
(9 Questions)
- Q1. Shipping point determination
- Q2. Plant determination with order of preference
- Ans.
Plant determination can be done by considering various factors in order of preference.
Start by looking at the plant's physical characteristics such as leaves, flowers, and stems.
Next, consider the plant's habitat and location to narrow down possibilities.
Use plant identification guides or apps for further assistance.
Consult with botanical experts or horticulturists for accurate identification.
Consider factors like seas...
- Q3. Difference between s4 hana and ecc
- Ans.
SAP S/4HANA is the next-generation business suite designed to run on SAP HANA, while ECC is the previous version of SAP's ERP software.
S/4HANA is built on the SAP HANA platform for real-time data processing, while ECC runs on traditional databases.
S/4HANA offers a simplified data model and user interface, while ECC has a more complex structure.
S/4HANA includes advanced features like predictive analytics and machine lea...
- Q4. Difference between Greenfield and brownfield implementation
- Ans.
Greenfield is starting a new project from scratch, while brownfield is implementing changes to an existing project.
Greenfield involves building a new system or project from the ground up.
Brownfield involves making changes or improvements to an existing system or project.
Greenfield projects are typically more time-consuming and costly due to starting from scratch.
Brownfield projects may have limitations or constraints d...
- Q5. Scenario based questions around Product allocation and back order processing bop
- Q6. Business partner and what tables are updated in backend in sap s4 hana, why is the old tables like kna1, knb1 still required?
- Ans.
Old tables like KNA1, KNB1 are still required in SAP S4 HANA for compatibility and historical data purposes.
Old tables like KNA1, KNB1 are still required in SAP S4 HANA for compatibility with existing programs and reports.
Some custom developments may still be using the old tables, requiring them to be maintained.
Historical data stored in the old tables may still be needed for reference or reporting purposes.
- Q7. Questions on current project
- Q8. S4 Hana einvoice - consolidated invoice
- Q9. Why are you looking for a change(Exp in curren company<= 2 years)
- Ans.
Seeking new challenges and growth opportunities after gaining valuable experience in current role.
Looking for new challenges and opportunities for growth
Seeking a role with more responsibility and impact
Want to expand my skill set and knowledge in a different environment
Interview Preparation Tips
- Sap s4 hana
Skills evaluated in this interview
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 Support Associate Interview Questions
- Tech Mahindra Customer Service Executive Interview Questions
- Tech Mahindra Customer Care Executive Interview Questions
- Tech Mahindra Software Developer Interview Questions
- Show more
Tech Mahindra Senior Consultant Interview Process
based on 6 interviews
1 Interview rounds
- Resume Shortlist Round
Senior Consultant Interview Questions from Similar Companies
Fast track your campus placements
Tech Mahindra Senior Consultant Reviews and Ratings
based on 29 reviews
Rating in categories
|
Software Engineer
26.4k
salaries
|  ₹2 L/yr - ₹9.2 L/yr |
|
Senior Software Engineer
21.4k
salaries
| ₹5.5 L/yr - ₹23 L/yr |
|
Technical Lead
11.7k
salaries
| ₹9.5 L/yr - ₹38 L/yr |
|
Associate Software Engineer
5.5k
salaries
| ₹1.8 L/yr - ₹8.2 L/yr |
|
Team Lead
5k
salaries
| ₹5.2 L/yr - ₹17 L/yr |
Infosys
Cognizant
Accenture
Wipro
- Home >
- Interviews >
- Tech Mahindra Interview Questions >
- Tech Mahindra Senior Consultant Interview Questions
