1 Infosys Ssis Developer Interview Questions & Answers | Complete Prep Guide 2025

Infosys Ssis Developer Interview Experiences

1 interview found

Ssis Developer Interview Questions & Answers

posted on 25 Feb 2022

I applied via Recruitment Consulltant and was interviewed in Jan 2022. There was 1 interview round.

Round 1 - Technical

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

Answered by AI

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - know your basics
don't panic only write those thing that you know in your resume

Skills evaluated in this interview

Ssis Developer Jobs at Infosys

View all

SSIS Developer

Bangalore / Bengaluru

5-8 Yrs

Not Disclosed

SSIS Developer

Bangalore / Bengaluru

5-8 Yrs

Not Disclosed

What people are saying about Infosys

View All

zestyrose

works at

Infosys

Tips for getting interview call in naukri

I have 3 yoe in sap basis am currently preparing for interview. And also started to apply for jobs in naukri and indeed almost 30-45 application applied but not got even single interview call. Any tips pls😪. Lost hopes. Thanks in advance ❤

Got a question about Infosys?

Ask anonymously on communities.

Interview questions from similar companies

Ssis Developer Interview Questions & Answers

Cognizant

Anonymous

posted on 3 Jan 2021

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?

Add your answer

Q2. Then tell us how many Tasks & transformations used in your project and give me brief details about it?

Add your answer

Q3. And they will give some scenarios like we have FFs source so we need to load into SQL server how you will do?

Add your answer

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

Answered by AI

Add your answer

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

Answered by AI

Add your answer

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.

Answered by AI

Add your answer

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

Answered by AI

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident.

Skills evaluated in this interview

Ssis Developer Interview Questions & Answers

Tech Mahindra

Adity Radia

posted on 25 Oct 2023

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via LinkedIn and was interviewed in Apr 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist

Pro Tip by AmbitionBox:

Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.

View all Resume tips

Round 2 - Coding Test

A basic coding test was done and screened based on this.

Round 3 - Assignment

Application based questions were been given

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a good experience.

Software Developer Interview Questions & Answers

TCS

Ashish Kumar

posted on 15 Dec 2021

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.

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of DSA, have knowledge about the databases, some common dml ,ddl statements, programming knowledge of a particular language like C,Java, python,etc...have good command on oops concepts... little bit of frameworks knowledge will also help

System Engineer Interview Questions & Answers

TCS

Anonymous

posted on 5 Jul 2022

I applied via Company Website and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Coding Test

Attended the codevita competition in final year of college.

Round 2 - Technical

(3 Questions)

Q1. About College Project

Add your answer

Q2. Some very basics of java

Add your answer

Q3. Experience of college project as a team

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Codevita is a really good platform to help you join TCS as a final year graduate in college

System Engineer Interview Questions & Answers

TCS

Anonymous

posted on 3 Mar 2022

I applied via Campus Placement and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - Coding Test

Round 2 - Technical

(5 Questions)

Q1. If you cleared Aptitude and Coding, Mostly Interview will be cleared with some basics questions like OOPs concepts, sort functions kind of questions.

Add your answer

Q2. Explain OOPs concept in JAVA?

Ans.

OOPs concept in JAVA is a programming paradigm that focuses on objects and their interactions.

OOPs stands for Object-Oriented Programming
It involves the use of classes, objects, inheritance, polymorphism, and encapsulation
Classes are used to define objects and their properties
Objects are instances of classes that can interact with each other
Inheritance allows for the creation of new classes based on existing ones
Polymo...

Answered by AI

Add your answer

Q3. Function to sort an array in Java?

Ans.

Java provides Arrays.sort() method to sort an array.

Use Arrays.sort() method to sort an array of strings.
The method sorts the elements in ascending order by default.
To sort in descending order, use Collections.reverseOrder() method.

Answered by AI

Add your answer

Q4. Tell me about yourself?

Add your answer

Q5. Final year project which you worked on?

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Most of people clears Aptitude/Coding round. clears interview for freshers recruit

Skills evaluated in this interview

Software Developer Interview Questions & Answers

TCS

Anonymous

posted on 18 Jun 2022

I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test

Round 2 - Technical

(1 Question)

Q1. Basic questions of java.

Add your answer

Round 3 - HR

(1 Question)

Q1. Intro and other hr related questions.

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Cover the basic questions regarding the programming language.

System Engineer Interview Questions & Answers

TCS

Arham Khokhar

posted on 24 Apr 2022

I applied via Company Website and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test

It's totally based on Basic understanding of concepts such as Linear arrangement, circular arrangement، blood relation, direction sense, ratio proportion, time, speed, distance

Round 2 - Technical

(3 Questions)

Q1. It's based on OOPS Concepts,

Add your answer

Q2. Strength and weaknesses

Add your answer

Q3. About yourself, about educational background, why should we hire you

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Show your confidence ✨️ you will be selected with ease

Business Analyst Interview Questions & Answers

TCS

Anonymous

posted on 7 Sep 2022

I applied via Naukri.com and was interviewed before Sep 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist

Pro Tip by AmbitionBox:

Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.

View all Resume tips

Round 2 - Aptitude Test

Entry level aptitude test

Round 3 - One-on-one

(1 Question)

Q1. Introduction and about college project.

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a really good experience working in TCS

System Engineer Interview Questions & Answers

TCS

Anonymous

posted on 30 Jul 2022

I applied via Company Website and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Aptitude Test

The first round is an aptitude online test that had Basics of Computer Science, Mathematics, English and then finally one basic program to code and compile like Palindrome.

Round 2 - Group Discussion

Three panellists were present and it was a face-face round, Panellist 1 and 2 takes the technical discussions like classes, inheritance, oops concept, basic syntax, and such. Panellist 3 talks more about your resume skills, hobbies and the company overview.

Interview Preparation Tips

Topics to prepare for TCS System Engineer interview:

Basic Promgramming Questions
Aptitiude

Interview preparation tips for other job seekers - Since this was my first job it was slightly challenging in several ways in terms of how to present yourself, confidence and such. But make sure to stay humble and agree to most of the requests made and stick to the resume.

Infosys Interview FAQs

How many rounds are there in Infosys Ssis Developer interview?

Infosys interview process usually has 1 rounds. The most common rounds in the Infosys interview process are Technical.

How to prepare for Infosys Ssis Developer interview?

Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Infosys. The most common topics and skills that interviewers at Infosys expect are SSIS, MSBI, Software Quality Assurance, Debugging and Business Intelligence.

Tell us how to improve this page.

Infosys Interviews By Designations

Interview Questions for Popular Designations

Join Infosys Creating the next opportunity for people, businesses & communities

TCS Interview Questions

3.7

• 10.4k Interviews

Accenture Interview Questions

3.8

• 8.1k Interviews

Wipro Interview Questions

3.7

• 5.6k Interviews

Cognizant Interview Questions

3.8

• 5.6k Interviews

Capgemini Interview Questions

3.7

• 4.8k Interviews

Tech Mahindra Interview Questions

3.5

• 3.8k Interviews

HCLTech Interview Questions

3.5

• 3.8k Interviews

Genpact Interview Questions

3.8

• 3.1k Interviews

LTIMindtree Interview Questions

3.8

• 2.9k Interviews

IBM Interview Questions

4.0

• 2.3k Interviews

View all

National Institute of Technology (NIT), Warangal Placement Questions

52 Interviews

Institute of Chartered Accountant of India (ICAI) Placement Questions

10 Interviews

Vellore Institute of Technology (VIT) Placement Questions

9 Interviews

Veermata Jijabai Technological Institute (VJTI), Mumbai Placement Questions

9 Interviews

Sathyabama University Placement Questions

7 Interviews

Guru Gobind Singh Indraprastha University (GGSIU) Placement Questions

5 Interviews

Maharaja Surajmal Institute of Technology, Delhi Placement Questions

5 Interviews

View all

Infosys Ssis Developer Salary

based on 8 salaries

₹3.6 L/yr - ₹10 L/yr

8% more than the average Ssis Developer Salary in India

View more details

Ssis Developer Jobs at Infosys

SSIS Developer

Bangalore / Bengaluru

5-8 Yrs

Not Disclosed

SSIS Developer

Bangalore / Bengaluru

5-8 Yrs

Not Disclosed

Explore more jobs

Infosys Salaries in India

Technology Analyst 55.6k salaries	₹0 L/yr - ₹0 L/yr
Senior Systems Engineer 50.7k salaries	₹0 L/yr - ₹0 L/yr
System Engineer 39.6k salaries	₹0 L/yr - ₹0 L/yr
Technical Lead 30.7k salaries	₹0 L/yr - ₹0 L/yr
Senior Associate Consultant 28.1k salaries	₹0 L/yr - ₹0 L/yr