Tech Mahindra Interview Questions, Process, and Tips

DHCP is a network protocol that assigns IP addresses to devices on a network. There are two types of DHCP: DHCPv4 and DHCPv6.

• DHCP stands for Dynamic Host Configuration Protocol.

• DHCPv4 is used for assigning IPv4 addresses, while DHCPv6 is used for assigning IPv6 addresses.

• DHCP DORA process stands for Discover, Offer, Request, Acknowledge.

• Discover: Client broadcasts a DHCP Discover message to find available DHCP servers.

• ...read more

OU stands for Organizational Unit, used to organize objects within a domain. ADC stands for Active Directory Connector, used to synchronize data between on-premises AD and Azure AD.

• OU is a container within a domain used to organize objects like users, groups, and computers.

• OU helps in delegating administrative tasks and applying Group Policies.

• Example: Sales department can have its own OU with specific users and polici...read more

APIPA stands for Automatic Private IP Addressing, a feature in Windows that automatically assigns IP addresses to computers when DHCP server is not available.

• APIPA is a feature in Windows operating systems that automatically assigns IP addresses in the range of 169.254.0.1 to 169.254.255.254 when a DHCP server is not available.

• It is commonly used in small home or office networks where a DHCP server is not present.

• APIPA...read more

OSPF and BGP are routing protocols used in networking to determine the best path for data packets to travel.

• OSPF (Open Shortest Path First) is an interior gateway protocol used to exchange routing information within an autonomous system.

• BGP (Border Gateway Protocol) is an exterior gateway protocol used to exchange routing information between different autonomous systems.

• OSPF uses link-state routing algorithm to calcula...read more

The OSI (Open Systems Interconnection) model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven distinct layers.

• Layer 1 - Physical layer: Deals with physical connections and transmission of raw data over a physical medium (e.g. cables, fibers).

• Layer 2 - Data Link layer: Responsible for node-to-node communication, error detection, and flow control (e.g. Ethern...read more

Extract the 14 characters before @ in a given URL

• Use string manipulation to extract characters before @ symbol

• Consider edge cases like no @ symbol or less than 14 characters before @

• Handle special characters like %20 or %40

Regex pattern to match at least one capital letter, one small case letter, one digit, and one special character.

• Use the regex pattern: (?=.*[A-Z])(?=.*[a-z])(?=.*[0-9])(?=.*[^A-Za-z0-9])

• Example: Password@123

Code to output each word with vowel count in a given string.

• Split the string into words using space as delimiter

• Iterate through each word and count the number of vowels

• Store the word and its vowel count in an array of strings

To find the maximum diagonal sum in a 2X2 Matrix, sum the elements of the main diagonal and the opposite diagonal.

• Sum the elements of the main diagonal (top left to bottom right) and the opposite diagonal (top right to bottom left).

• Compare the sums of both diagonals and return the maximum sum.

• Example: For a 2X2 Matrix [[1, 2], [3, 4]], the main diagonal sum is 1+4=5 and the opposite diagonal sum is 2+3=5. The maximum d

To find the selected option text from a dropdown in Selenium, you can use the getFirstSelectedOption() method.

• Use the Select class to work with dropdown elements in Selenium

• Use the getFirstSelectedOption() method to get the selected option

• Retrieve the text of the selected option using getText() method

Find duplicates in a dropdown along with their occurrence/frequency.

• Iterate through the dropdown options and store each option in a hashmap with its frequency.

• Identify options with frequency greater than 1 as duplicates.

• Return the duplicates along with their occurrence/frequency.

Resolve merge conflicts in git by using git commands and tools.

• Pull the latest changes from the remote repository

• Use 'git status' to identify conflicting files

• Open the conflicting files and manually resolve the conflicts

• Add the resolved files to the staging area using 'git add'

• Commit the changes with a merge message using 'git commit'

Use git cherry-pick command to bring specific commit changes to your branch.

• Identify the commit hash of the specific changes you want to bring to your branch.

• Checkout to the branch where you want to apply the changes.

• Use 'git cherry-pick <commit-hash>' command to apply the specific commit changes to your branch.

To switch to a frame in Selenium, use driver.switchTo().frame() method. To come out of a frame, use driver.switchTo().defaultContent() method.

• Use driver.switchTo().frame() method to switch to a frame

• Use driver.switchTo().defaultContent() method to come out of a frame

• Example: driver.switchTo().frame("frameName");

• Example: driver.switchTo().defaultContent();

I am a dedicated and experienced Technical Support Associate with a strong background in troubleshooting and customer service.

• Experienced in resolving technical issues for customers

• Skilled in providing excellent customer service

• Proficient in troubleshooting software and hardware problems

Yes, I am comfortable speaking in English.

• Fluent in English

• Comfortable communicating in English

• Have experience speaking English in previous roles

Yes, I have knowledge of Unix operating system.

• Familiar with Unix commands and shell scripting

• Experience in working with Unix-based systems

• Knowledge of file systems, processes, permissions, and networking in Unix

• Proficient in using tools like grep, sed, awk, etc. in Unix environment

My technical round went well. I was able to showcase my knowledge and skills effectively.

• Demonstrated proficiency in troubleshooting technical issues

• Provided detailed explanations for my problem-solving approach

• Highlighted relevant experience and certifications

• Received positive feedback from the interviewer

I expect a supportive work environment, opportunities for growth, and a strong team dynamic.

• Supportive work environment

• Opportunities for growth

• Strong team dynamic

Application performance is crucial for ensuring optimal user experience and efficiency.

• Monitor key performance indicators such as response time, throughput, and error rates

• Identify and address bottlenecks in the application architecture or code

• Utilize performance testing tools like JMeter or LoadRunner to simulate real-world scenarios

• Optimize database queries and ensure efficient use of resources

• Implement caching mecha

Capacity planning involves forecasting future resource needs and ensuring that the necessary resources are available.

• Identify current resource usage and performance levels

• Forecast future resource needs based on growth projections

• Determine any potential bottlenecks or constraints

• Allocate resources accordingly to meet future demands

• Regularly review and adjust the capacity plan as needed

Creating a Standard Operating Procedure involves identifying the process, documenting steps, obtaining feedback, and finalizing the SOP.

• Identify the process or task that needs an SOP

• Document each step involved in the process

• Obtain feedback from relevant stakeholders for improvements

• Finalize the SOP with clear instructions and guidelines

• Regularly review and update the SOP as needed

I handle transitions by communicating effectively, setting clear expectations, and providing support to team members.

• Communicate openly and transparently with team members about upcoming changes

• Set clear expectations and goals for the transition period

• Provide support and resources to help team members adjust to the changes

• Lead by example and remain positive and adaptable during transitions

I provide feedback by being specific, timely, and constructive.

• Be specific about what was done well and what needs improvement

• Provide feedback in a timely manner to address issues promptly

• Offer constructive criticism and suggestions for improvement

• Encourage open communication and dialogue for feedback to be effective

Handled an escalation call by actively listening, empathizing, and offering a solution.

• Remain calm and composed while listening to the customer's concerns.

• Empathize with the customer and acknowledge their frustration.

• Offer a solution or escalate the issue to a higher authority if necessary.

• Follow up with the customer to ensure their issue has been resolved satisfactorily.

Managed conflict between team members by facilitating open communication and finding common ground.

• Addressed the issue privately to understand each team member's perspective

• Encouraged open communication and active listening to resolve misunderstandings

• Facilitated a team meeting to discuss the conflict and find common ground

• Established clear expectations and guidelines for future interactions

I have worked with KPIs such as sales targets, customer satisfaction scores, employee productivity metrics, and project completion rates.

• Sales targets

• Customer satisfaction scores

• Employee productivity metrics

• Project completion rates

I established end-to-end operations by defining clear processes, assigning roles, providing training, and monitoring performance.

• Defined clear processes from start to finish

• Assigned roles and responsibilities to team members

• Provided training and resources to ensure understanding and proficiency

• Monitored performance and made adjustments as needed

Developed a data pipeline to ingest, process, and analyze customer feedback data for a retail company.

• Used Google Cloud Platform services like BigQuery, Dataflow, and Pub/Sub for data processing.

• Implemented data cleansing and transformation techniques to ensure data quality.

• Created visualizations and dashboards using tools like Data Studio for stakeholders to easily interpret the data.

GCP offers different storage classes for varying performance and cost requirements.

• Standard Storage: for frequently accessed data

• Nearline Storage: for data accessed less frequently

• Coldline Storage: for data accessed very infrequently

• Archive Storage: for data stored for long-term retention

SQL optimization techniques focus on improving query performance by reducing execution time and resource usage.

• Use indexes to speed up data retrieval

• Avoid using SELECT * and instead specify only the columns needed

• Optimize joins by using appropriate join types and conditions

• Limit the use of subqueries and instead use JOINs where possible

• Use EXPLAIN to analyze query execution plans and identify bottlenecks