20+ Tech Mahindra Team Lead Interview Questions and Answers

The force required to open the door depends on various factors such as the size of the door, the type of handle, and the direction of the wind.

• The size and weight of the door will determine the force required to open it.

• The type of handle or knob on the door can also affect the force needed to open it.

• The direction of the wind can make it easier or harder to open the door.

• Without knowing the specific details of the door, it is impossible to accurately determine the force requ...read more

To find 3rd column in a pipe delimited file in unix, use the cut command.

• Use the cut command with -d option to specify the delimiter as pipe(|)

• Use -f option to specify the field/column number to extract, in this case 3

• Example: cut -d '|' -f 3 filename.txt

• This will output the 3rd column from the file filename.txt

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 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

Decompiler is a tool to convert compiled code back to source code. Increase error message length in pro*C using the define SQLERRMC.

• Decompiler is used to reverse engineer compiled code to its original source code.

• Pro*C error message length can be increased by defining SQLERRMC to a larger value.

• For example, to increase error message length to 100 characters, define SQLERRMC as char SQLERRMC[100];

Managing customers, resolving conflicts, presenting business decks, Excel shortcuts and formulas, role responsibilities, CAPA, 5 WHY ANALYSIS, RCA

• To manage customers, prioritize their needs, communicate effectively, and provide excellent service

• To resolve conflicts between team mates, listen to both sides, find common ground, and encourage open communication

• To present a business deck, focus on key points, use visuals, and engage the audience

• Excel shortcuts: Ctrl+C (copy), Ctr...read more

Index in SQL is a data structure that improves the speed of data retrieval operations.

• Indexes are used to quickly locate data without having to search every row in a table.

• Clustered index determines the physical order of data in a table.

• Non-clustered index creates a separate structure that contains the indexed columns and a pointer to the actual data.

• Unique index ensures that the indexed columns contain unique values.

• Full-text index is used for efficient text-based searches.

• C...read more

Multi array transformation in JSON in Kafka

• Use a JSON serializer and deserializer to convert multi arrays to JSON and vice versa

• Ensure that the data is properly formatted and validated before sending it to Kafka

• Consider using a schema registry to manage the schema for the JSON data

• Test the transformation thoroughly to ensure that it is working as expected

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

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

Pro*C code can be compiled using the Pro*C precompiler. Indicator variables are used to handle null values in database columns.

• Pro*C code can be compiled using the Pro*C precompiler, which generates C code from the Pro*C code.

• The Pro*C precompiler requires the Oracle client libraries to be installed.

• Indicator variables are used to handle null values in database columns. They are declared as short integers and are set to -1 if the corresponding column is null.

• Indicator variabl...read more

Hive supports various analytical functions for data processing and analysis.

• Hive supports aggregation functions like SUM, COUNT, AVG, MIN, MAX, etc.

• It also supports window functions like ROW_NUMBER, RANK, LAG, LEAD, etc.

• Hive provides statistical functions such as CORR, COVAR_POP, STDDEV, etc.

• It supports date and time functions like YEAR, MONTH, DAY, HOUR, etc.

• Hive also offers string manipulation functions like CONCAT, SUBSTRING, LENGTH, etc.

Hinge joint can be modeled using beam elements with rotational degrees of freedom.

• Use beam elements to model the joint

• Assign rotational degrees of freedom to the joint

• Apply appropriate boundary conditions to simulate the joint behavior

• Consider the material properties and loading conditions

• Verify the results with experimental data if available

I have used various libraries in Python such as NumPy, Pandas, Matplotlib, Scikit-learn, etc.

• NumPy - for numerical computations and array manipulation

• Pandas - for data manipulation and analysis

• Matplotlib - for data visualization

• Scikit-learn - for machine learning tasks

• Requests - for making HTTP requests

• BeautifulSoup - for web scraping

• NLTK - for natural language processing

• OpenCV - for computer vision tasks

Dense rank assigns consecutive integers to distinct values, rank assigns integers to distinct values but skips integers for ties, row number assigns integers to rows in the result set.

• Dense rank assigns consecutive integers to distinct values

• Rank assigns integers to distinct values but skips integers for ties

• Row number assigns integers to rows in the result set

• Dense rank and rank are used for ranking data, while row number is used for pagination

• Example: Dense rank - 1, 1, 2, ...read more

HashMap and HashTable are both data structures in Java used to store key-value pairs, but HashTable is synchronized while HashMap is not.

• HashMap allows null keys and values, while HashTable does not.

• HashMap is not synchronized and is not thread-safe, while HashTable is synchronized and thread-safe.

• HashMap is faster than HashTable for most operations, as it is not synchronized.

• HashMap is part of the Java Collections Framework, while HashTable is a legacy class.

Lambda function is a small anonymous function in Python.

• Lambda functions can have any number of arguments but only one expression.

• They are used as a shortcut to define small functions without a name.

• Lambda functions can be used as arguments to higher-order functions.

• Example: lambda x: x**2 defines a function that squares its input.

• Example: sorted(list, key=lambda x: x[1]) sorts a list of tuples by the second element.

Null values in HIVE can be eliminated using the COALESCE function.

• Use the COALESCE function to replace null values with a default value.

• Syntax: COALESCE(column_name, default_value)

• Example: SELECT COALESCE(name, 'Unknown') FROM table_name;

ACID properties ensure data consistency and reliability in HIVE tables.

• ACID stands for Atomicity, Consistency, Isolation, and Durability.

• Atomicity ensures that a transaction is treated as a single unit of work.

• Consistency ensures that the data remains in a valid state before and after the transaction.

• Isolation ensures that concurrent transactions do not interfere with each other.

• Durability ensures that once a transaction is committed, it is permanent and can survive system fa...read more

Bolt slippage is calculated by measuring the amount of movement between the bolt and the joint it is fastening.

• Bolt slippage occurs when the bolt rotates or moves within the joint it is fastening

• To calculate bolt slippage, measure the amount of movement between the bolt and the joint

• This can be done using a dial indicator or other measuring device

• Bolt slippage can be caused by insufficient torque, improper lubrication, or other factors

Shrinkage can be controlled by implementing strict inventory management procedures and conducting regular audits.

• Implementing a system for tracking inventory levels and conducting regular audits to identify any discrepancies

• Ensuring that all employees are properly trained on inventory management procedures and are held accountable for any losses

• Implementing security measures such as surveillance cameras and access controls to prevent theft

• Regularly reviewing and analyzing sal...read more

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

Yield strength is the amount of stress a material can withstand before it starts to deform permanently.

• It is the stress at which a material begins to deform plastically

• It is an important factor in determining the strength and durability of a material

• It is usually measured in units of psi or MPa

• Examples of materials with high yield strength include steel and titanium

Filtering in PySpark involves using the filter function to select rows based on specified conditions.

• Use the filter function with a lambda function to specify the condition for filtering

• Filter based on column values or complex conditions

• Example: df.filter(df['column_name'] > 10)

Partitioning in data warehouse involves dividing large tables into smaller, more manageable parts based on certain criteria.

• Partitioning helps improve query performance by allowing parallel processing of data.

• Common partitioning methods include range, list, hash, and composite partitioning.

• Example: Partitioning a sales table by date can improve query performance when searching for sales data within a specific time frame.