Add office photos
i
Cognizant
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Cognizant Ssis Developer Interview Questions, Process, and Tips
Cognizant Ssis Developer Interview Experiences
1 interview found
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
Interview questions from similar companies
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
sudeep mandal
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
Selected
(5 Questions)
- Q1. React Life cycle
- Q2. What React hooks have you utilized in your projects?
- Q3. What is Redux, and what are the differences between Redux and Context?
- Q4. What is the difference between visibility: hidden and display: none in CSS?
- Q5. What are JavaScript closures, the temporal dead zone (TDZ), hoisting, and the JavaScript engine?
Identify the duplicate character in the string.
I was interviewed in Jan 2025.
Trips for cracking interview
(5 Questions)
- Q1. For example how to replay for all questions
- Q2. Different questions for all types
- Q3. Interviews easily cracking trips
- Q4. How to get good job in software
- Q5. How to get job
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Dec 2024. There were 3 interview rounds.
(1 Question)
- Q1. Project related question , Interface , Abstraction
(1 Question)
- Q1. Scenario based question
(1 Question)
- Q1. Salary Discussioon
I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.
(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
(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.
- 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
Skills evaluated in this interview
Selected
(1 Question)
- Q1. Basic html css questions
Logical reasoning, quantitative analysis and computer test
(1 Question)
- Q1. Basic html, css, javascript questions
(1 Question)
- Q1. Salary discussion
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(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].
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. How to insert multiple values in one go
- Ans.
Use the INSERT INTO statement with multiple value sets separated by commas
Use the INSERT INTO statement followed by the table name
List the column names in parentheses after the table name
Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas
Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)
- Q2. Update query using joins
- Ans.
Update query using joins in SQL
Use UPDATE statement with JOIN clause to update data in multiple tables
Specify the tables to be updated and joined using ON clause
Set the columns to be updated in SET clause
Interview Preparation Tips
Skills evaluated in this interview
Cognizant Interview FAQs
Some of the top questions asked at the Cognizant Ssis Developer interview -
Tell us how to improve this page.
Cognizant Interviews By Designations
- Cognizant Programmer Analyst Interview Questions
- Cognizant Programmer Analyst Trainee Interview Questions
- Cognizant Associate Interview Questions
- Cognizant Senior Associate Interview Questions
- Cognizant Processing Executive Interview Questions
- Cognizant Software Engineer Interview Questions
- Cognizant Senior Processing Executive Interview Questions
- Cognizant 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
Interview Questions from Similar Companies
Fast track your campus placements
Cognizant Ssis Developer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Associate
72.5k
salaries
|  ₹5.1 L/yr - ₹15.9 L/yr |
|
Programmer Analyst
55.5k
salaries
| ₹2.4 L/yr - ₹9.7 L/yr |
|
Senior Associate
48.4k
salaries
| ₹8.9 L/yr - ₹27.2 L/yr |
|
Senior Processing Executive
28.8k
salaries
| ₹1.8 L/yr - ₹9 L/yr |
|
Technical Lead
17.6k
salaries
| ₹5.9 L/yr - ₹24.5 L/yr |
TCS
Infosys
Wipro
Accenture
- Home >
- Interviews >
- Cognizant Interview Questions >
- Cognizant Ssis Developer Interview Questions
