AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Tech Mahindra
Compare
Filter interviews by
Clear (1)
Tech Mahindra Ssis Developer Interview Questions and Answers
Tech Mahindra Ssis Developer Interview Experiences
1 interview found
Adity Radia
Selected
I applied via LinkedIn and was interviewed in Apr 2023. There were 3 interview rounds.
A basic coding test was done and screened based on this.
Application based questions were been given
Interview Preparation Tips
Interview questions from similar companies
Anonymous
I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
7 Questions
- Q1. The first and staring question is what is your roles and responsibilities in this project and what is the aim of your project?
- Q2. Then tell us how many Tasks & transformations used in your project and give me brief details about it?
- Q3. And they will give some scenarios like we have FFs source so we need to load into SQL server how you will do?
- Q4. Tell us from Scratch how you will find File count in Source folder and how you check files exist or not.?
- Ans.
To find file count in source folder and check if files exist, use SSIS Script Task with C# code.
Create a SSIS package with Script Task
Write C# code to get file count and check if files exist
Use System.IO namespace to access files and folders
Use Directory.GetFiles() method to get all files in folder
Use File.Exists() method to check if file exists
Use a variable to store file count and use it in subsequent tasks
- Q5. Hove you ever done Performance tuning in SSIS if yes tell me the process?
- Ans.
Yes, I have done performance tuning in SSIS.
Identify bottlenecks using performance counters and logging
Optimize data flow by using appropriate transformations and buffer sizes
Use parallelism and concurrency to improve performance
Minimize network traffic by compressing data and using bulk load operations
Use caching and lookup transformations to reduce database queries
Profile and test the package to validate performance
- Q6. Have you ever implemented Loging in your project if yes tell us how you do?
- Ans.
Yes, I have implemented logging in my projects.
I use log4net library for logging.
I log all the important events and errors in the application.
I store the logs in a separate file or database table.
I also use different log levels to differentiate between different types of logs.
I regularly review the logs to identify any issues or areas of improvement.
- Q7. Have you ever implemented error handle?
- Ans.
Yes, I have implemented error handling in my SSIS projects.
I always include a try-catch block in my SSIS packages to handle errors.
I use event handlers to log errors and send notifications.
I also use data flow transformations like Conditional Split and Derived Column to handle errors.
I have experience with custom error handling using Script Task and .NET code.
I make sure to test my error handling thoroughly to ensure i
Interview Preparation Tips
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Jan 2022. There was 1 interview round.
(1 Question)
- Q1. SSIS part what transformation you have worked with? lookup and its catch mode merge vs union containers forloop foreach loop sequence data source type you can connect to SSIS how to schedule a job how to...
- Ans.
Interview questions for SSIS and SQL developer
Worked with Lookup transformation and its catch mode
Understand the difference between Merge and Union transformations
Familiar with containers like For Loop, Foreach Loop, and Sequence
Able to connect to various data source types in SSIS
Know how to schedule a job in SSIS
Able to call a stored procedure in SSIS
Able to find the top 3rd salary in SQL
Understand the difference betw...
Interview Preparation Tips
don't panic only write those thing that you know in your resume
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Jul 2021. There were 4 interview rounds.
Aptitude test on CS subjects like C programming, DBMS, CN, and OS.
There were 2 input-output based questions of easy to moderate level
Every candidate was given an individual topic and was asked to speak on it
(1 Question)
- Q1. Some typical HR questions
Interview Preparation Tips
I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.
Interview Preparation Tips
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Java questions
Interview Preparation Tips
I applied via Company Website and was interviewed before Jul 2021. There were 3 interview rounds.
Aptitude, reasoning, English, cloud sections
2 questions in which , one has to complete within an 50 minutes
(2 Questions)
- Q1. Tell me about t Yourself
- Q2. What are the previous experiences
Interview Preparation Tips
- Java
- SQL
- Agile Methodology
- SDLC
Keep it just and short
Explain more about your experiences
I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.
(1 Question)
- Q1. Basic questions of java.
(1 Question)
- Q1. Intro and other hr related questions.
Interview Preparation Tips
I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.
Puzzles, Psychometric Test
(1 Question)
- Q1. Some water in 3 Jars question, you had to measure out 5L correctly
Interview Preparation Tips
I applied via Company Website and was interviewed before Feb 2021. There were 3 interview rounds.
TNQT: TCS National Qualifier Test
(1 Question)
- Q1. All technical questions related to your project and basic understanding of any programming language. Basically questions from your resume will be asked.
(2 Questions)
- Q1. Tell me about yourself.
- Q2. What is your family background?
Interview Preparation Tips
Tech Mahindra Interview FAQs
Recently Viewed
DESIGNATION
SALARIES
Bunge India
SALARIES
IDC Technologies
SALARIES
South Indian Bank
INTERVIEWS
TCS
No Interviews
JOBS
Search Engine Optimisation /SEO Specialist
Discover jobs you love
REVIEWS
Bunge India
No Reviews
REVIEWS
Phonon Communications
No Reviews
SALARIES
South Indian Bank
SALARIES
Federal Bank
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 Customer Support Associate Interview Questions
- Tech Mahindra Associate Software Engineer Interview Questions
- Tech Mahindra Customer Service Executive Interview Questions
- Tech Mahindra Customer Care Executive Interview Questions
- Tech Mahindra Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- SQL Developer Interview Questions
- Show more
Tech Mahindra Ssis Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
26.3k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
21.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Technical Lead
11.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate Software Engineer
5.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Team Lead
5k
salaries
| ₹0 L/yr - ₹0 L/yr |
Infosys
Cognizant
Accenture
Wipro
- Home >
- Interviews >
- Tech Mahindra Interview Questions >
- Tech Mahindra Ssis Developer Interview Questions
