Tech Mahindra Technical Assistant Interview Questions and Answers

Advance Excel and share well email drafting etc

Q1. 10 question over the technical
Add your answer

Q1. Tell your Self introduction
Add your answer

Q1. Share details of your previous job.
Add your answer
Q2. What is your family background?
Add your answer
Q3. Tell me about yourself.
Add your answer

Q1. Azure cloud platform tech
Add your answer
Q2. Informatica tech stack ques
Add your answer

Q1. Adf tech stack que
Add your answer
Q2. Scd type 2 implementation
Ans. 
SCD Type 2 implementation involves tracking historical changes in data by creating new records for each change.
• Identify the columns that need to be tracked for changes

• Add effective start and end dates to track the validity of each record

• Insert new records for changes and update end dates for previous records

• Maintain a surrogate key to uniquely identify each version of the record
Answered by AI
Add your answer

Q1. Dw related que ans
Add your answer
Q2. Solution design related que
Add your answer

Q1. Aspiration from my end
Add your answer
Q2. How soon can join
Ans. 
I can join the team within 2 weeks.
• I can start within 2 weeks of receiving the offer.

• I need to give notice to my current employer.

• I may need to relocate, which could affect my start date.
Answered by AI
Add your answer

Q1. What is polymorphism
Ans. 
Polymorphism is the ability of a function or method to behave differently based on the object it is acting upon.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• It enables a single interface to be used for different data types or classes.

• Examples include method overloading and method overriding in object-oriented programming.
Answered by AI
Add your answer
Q2. What is method overriding
Ans. 
Method overriding is a feature in object-oriented programming where a subclass provides a specific implementation of a method that is already provided by its parent class.
• Occurs in inheritance when a subclass provides a specific implementation of a method that is already provided by its parent class

• The method in the subclass must have the same name, return type, and parameters as the method in the parent class

• Allows fo...read more
Answered by AI
Add your answer

Q1. What is interceptor
Ans. 
An interceptor is a design pattern commonly used in software development to capture and manipulate incoming and outgoing requests.
• Interceptors can be used for logging, authentication, authorization, error handling, and more

• In Angular, interceptors can be used to modify HTTP requests before they are sent to the server

• In Spring framework, interceptors can be used to intercept client requests and server responses
Answered by AI
Add your answer
Q2. What is filter in spring
Ans. 
A filter in Spring is a component that intercepts incoming requests and outgoing responses, allowing for pre-processing and post-processing.
• Filters are used for tasks such as logging, authentication, authorization, and more

• Filters can be configured in the Spring application context

• Examples of filters in Spring include CharacterEncodingFilter, HiddenHttpMethodFilter, and CorsFilter
Answered by AI
Add your answer

Q1. What is your contribution
Ans. 
My contribution as a Technical Lead includes leading a team, providing technical guidance, resolving technical issues, and ensuring project success.
• Leading a team to achieve project goals

• Providing technical guidance and mentorship to team members

• Resolving technical issues and challenges

• Ensuring project success through effective planning and execution
Answered by AI
Add your answer
Q2. What have you done in your project
Ans. 
I have led a team in developing a new feature for our product, involving designing, coding, testing, and deployment.
• Led a team in developing a new feature

• Designed the architecture for the feature

• Coded the functionality using Java and Spring Boot

• Tested the feature using JUnit and Mockito

• Deployed the feature to production environment
Answered by AI
Add your answer

Q1. How soon can you join
Ans. 
I can join within 2 weeks.
• I can start within 2 weeks of receiving an offer.

• I need to give notice to my current employer.

• I may need time to relocate if necessary.
Answered by AI
Add your answer
Q2. How was your last interview
Ans. 
My last interview went well, I was able to showcase my technical skills and experience effectively.
• Prepared thoroughly by reviewing common technical interview questions

• Highlighted my experience leading technical teams and projects

• Demonstrated problem-solving skills with real-life examples

• Received positive feedback on my communication and teamwork abilities
Answered by AI
Add your answer

Q1. Offer letter related
Add your answer
Q2. Relocation related
Add your answer

Q1. Ticket booking and travel date related
Add your answer
Q2. Confirmation on travel
Add your answer

Q1. Are you ready to travel?
Ans. 
Yes, I am ready to travel for work as needed.
• I am willing to travel for client meetings, conferences, and team collaborations.

• I have previous experience traveling for work in my current or past roles.

• I understand the importance of face-to-face interactions in a technical lead role.
Answered by AI
Add your answer
Q2. Have you talked to your reporting manager
Ans. 
Yes, I regularly communicate with my reporting manager to provide updates and discuss any issues or concerns.
• Regularly scheduled check-ins with reporting manager

• Provide updates on project progress

• Discuss any issues or concerns

• Seek guidance and feedback from reporting manager
Answered by AI
Add your answer

Q1. Describe architecture of current project
Add your answer

Q1. Microservices Design Patterns
Add your answer

Q1. Salary Discussion
Add your answer