Premium Employer

i

This company page is being actively managed by Infosys Team. If you also belong to the team, you can get access from here

Infosys Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 37.4k Reviews

Filter interviews by

Infosys Ssis Developer Interview Questions and Answers

Updated 25 Feb 2022

Infosys Ssis Developer Interview Experiences

1 interview found

Ssis Developer Interview Questions & Answers

user image sudeep mandal

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

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

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected 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 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.

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

  • Answered by AI
  • 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
  • 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
  • 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

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

General aptitude, computer science fundamentals multiple-choice questions, and data structures and algorithms multiple-choice questions were asked.

Round 2 - Technical 

(2 Questions)

  • Q1. Given a string, write a function to reverse the string.
  • Ans. 

    Function to reverse a given string

    • Create an empty string to store the reversed string

    • Iterate through the input string in reverse order and append each character to the new string

    • Return the reversed string

  • Answered by AI
  • Q2. Given a sorted array of integers, write a function to perform a binary search to find the index of a target value. If the target value is not found, return -1.
  • Ans. 

    Binary search function to find target value in sorted array

    • Define function that takes sorted array and target value as input

    • Initialize variables for start, end, and middle indices

    • Use while loop to iterate until start is less than or equal to end

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. About the company
  • Q2. What are three significant achievements in your life?
  • Ans. 

    Graduating with honors, winning a hackathon, volunteering in a developing country

    • Graduated with honors from university with a degree in Computer Science

    • Won first place in a hackathon competition by developing a unique and innovative software solution

    • Volunteered in a developing country to help build schools and provide education to underprivileged children

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Naukri.com and was interviewed in Dec 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Project related question , Interface , Abstraction
Round 2 - Technical 

(1 Question)

  • Q1. Scenario based question
Round 3 - HR 

(1 Question)

  • Q1. Salary Discussioon
Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Angular routing
  • Q2. What are pipes in angular
  • Ans. 

    Pipes in Angular are used for transforming data in templates.

    • Pipes are used to format data before displaying it in the view

    • They can be used to filter, sort, or transform data in various ways

    • Examples include date pipe, currency pipe, and uppercase/lowercase pipe

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. Which version of java you use?
  • Ans. 

    I use Java version 8 for Angular development.

    • I use Java 8 for its compatibility with Angular frameworks and libraries.

    • Java 8 introduced features like lambda expressions and streams which are useful in Angular development.

    • Example: I use Java 8 to write backend services for my Angular applications.

  • Answered by AI
  • Q2. What are the new features in java 8?
  • Ans. 

    Java 8 introduced several new features including lambda expressions, functional interfaces, streams, and default methods.

    • Lambda expressions allow you to write code in a more concise and readable way.

    • Functional interfaces provide a way to define interfaces with a single abstract method.

    • Streams allow you to process collections of objects in a functional style.

    • Default methods allow you to add new methods to interfaces wit

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Ui development and component related
  • Q2. Performance of technology and challenges
Round 2 - HR 

(2 Questions)

  • Q1. Personal introduction and location details
  • Q2. Negatition of salries excepectations

Interview Preparation Tips

Interview preparation tips for other job seekers - It's very good organization. Freindly nature in team operation is good from leads hikes also ok
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - HR 

(1 Question)

  • Q1. Basic html css questions
Round 2 - Aptitude Test 

Logical reasoning, quantitative analysis and computer test

Round 3 - Technical 

(1 Question)

  • Q1. Basic html, css, javascript questions
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. How to pass data from component to another component
  • Q2. Life cycle hooks
  • Q3. Observables&subject
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Sliding Window find the subarray with sum equal to k
  • Ans. 

    Using sliding window technique to find subarray with sum equal to k.

    • Initialize two pointers at the start of the array.

    • Move the right pointer to expand the window until the sum is greater than or equal to k.

    • Move the left pointer to shrink the window if the sum exceeds k.

    • Repeat until the end of the array is reached.

    • Example: Input array [1, 4, 20, 3, 10, 5], k=33. Output: [20, 3, 10].

  • Answered by AI

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.

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

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.2k Interviews
Accenture Interview Questions
3.9
 • 8k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.5k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
Genpact Interview Questions
3.9
 • 3k Interviews
LTIMindtree Interview Questions
3.9
 • 2.9k Interviews
IBM Interview Questions
4.1
 • 2.4k 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

Bangalore / Bengaluru

5-8 Yrs

Not Disclosed

Explore more jobs
Technology Analyst
56.1k salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Senior Systems Engineer
49.8k salaries
unlock blur

₹2.8 L/yr - ₹8 L/yr

System Engineer
39k salaries
unlock blur

₹2.5 L/yr - ₹6.5 L/yr

Technical Lead
30.6k salaries
unlock blur

₹5.2 L/yr - ₹19.5 L/yr

Senior Associate Consultant
27.3k salaries
unlock blur

₹6.2 L/yr - ₹16.8 L/yr

Explore more salaries
Compare Infosys with

TCS

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.8
Compare

Accenture

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview