i
Infosys
Filter interviews by
I applied via Recruitment Consulltant and was interviewed in Jan 2022. There was 1 interview round.
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...
What people are saying about Infosys
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
I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.
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
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
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.
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
posted on 21 Dec 2024
I applied via Campus Placement
General aptitude, computer science fundamentals multiple-choice questions, and data structures and algorithms multiple-choice questions were asked.
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
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
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
I applied via Naukri.com and was interviewed in Dec 2024. There were 3 interview rounds.
I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.
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
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.
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
Logical reasoning, quantitative analysis and computer test
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
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].
Technology Analyst
56.1k
salaries
| ₹3 L/yr - ₹11 L/yr |
Senior Systems Engineer
49.8k
salaries
| ₹2.8 L/yr - ₹8 L/yr |
System Engineer
39k
salaries
| ₹2.5 L/yr - ₹6.5 L/yr |
Technical Lead
30.6k
salaries
| ₹5.2 L/yr - ₹19.5 L/yr |
Senior Associate Consultant
27.3k
salaries
| ₹6.2 L/yr - ₹16.8 L/yr |
TCS
Wipro
Cognizant
Accenture