Tech Mahindra Senior Technical Support Interview Questions and Answers

Q1. I would like to develop a company what restrictions in company and the company management. Was the tell about it.. I tharole follow
Add your answer
Q2. What about the company
Add your answer
Q3. The Company was overall placements..
Add your answer
Q4. The company management was very good and excellent
Add your answer

What questions they will ask..

Who to develop the company profit and shares

First Round was assessment test round, Which includes English + Cognitive questions

Q1. As I have completed aeronautical engineering. They asked me basic questions related to aeronautics. What are the primary part of the airplane?
Add your answer

Q1. Introduce yourself
Add your answer

Q1. How can we iterate files in ssis
Ans. 
Files in SSIS can be iterated using Foreach Loop Container or Script Task.
• Use Foreach Loop Container to iterate through a list of files in a specified directory.

• Set the Enumerator type to 'Foreach File Enumerator' and configure the necessary properties like file extension, file path, etc.

• Alternatively, use a Script Task to programmatically iterate through files and perform custom actions.
Answered by AI
Add your answer
Q2. What is checkpoint in ssis
Ans. 
Checkpoint in SSIS is a feature that allows packages to restart from a specific point in case of failure.
• Checkpoints are used to save the state of the package at specific points during execution.

• They help in resuming package execution from the last successful checkpoint in case of failure.

• Checkpoints can be configured at the package level or at the task level.

• They are useful in scenarios where long-running packages nee...read more
Answered by AI
Add your answer

Q1. Explain about your project?
Add your answer
Q2. Explain about ssis expressions
Ans. 
SSIS expressions are used to dynamically set property values at runtime in SQL Server Integration Services packages.
• SSIS expressions are written using a combination of functions, operators, and constants.

• Expressions can be used to set properties such as connection strings, file paths, and SQL queries.

• Expressions can be used to make packages more flexible and reusable.

• For example, an expression can be used to dynamicall...read more
Answered by AI
Add your answer

Q1. What is your Favorite movie ?
Ans. 
My favorite movie is The Shawshank Redemption.
• Directed by Frank Darabont

• Based on a Stephen King novella

• Set in a prison in Maine

• Themes of hope, friendship, and redemption

• Starring Tim Robbins and Morgan Freeman
Answered by AI
Add your answer
Q2. What is your Favorite colour?
Ans. 
My favorite color is blue because it reminds me of the calming ocean and clear skies.
• Blue is associated with calmness and tranquility

• It symbolizes trust, loyalty, and confidence

• Examples: navy blue, sky blue, royal blue
Answered by AI
Add your answer

Q1. What is power draining?
Ans. 
Power draining refers to the excessive consumption of power by a device or system, leading to decreased battery life or performance.
• Power draining can occur due to background apps running constantly on a device.

• Faulty hardware components can also contribute to power draining.

• Settings such as high screen brightness or frequent data syncing can increase power draining.

• Examples include a smartphone losing battery quickly ...read more
Answered by AI
Add your answer
Q2. What is VPN? When you use it?
Ans. 
VPN stands for Virtual Private Network. It is used to create a secure connection over the internet, allowing users to access private networks remotely.
• VPN encrypts data to ensure privacy and security

• It allows users to access restricted websites or content

• Commonly used for remote work, accessing company networks, and bypassing geo-restrictions

• Examples include NordVPN, ExpressVPN, and Cisco AnyConnect
Answered by AI
Add your answer

Q1. Sql query , database connectivity,
Add your answer
Q2. Unix commands , grep, find, sed
Add your answer

Q1. About Switching
Add your answer
Q2. About Routers switching, LAN, SD-WAN
Add your answer