AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
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
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
(2 Questions)
- Q1. Array qs reverse
- Q2. Question about angular and react
SHOW TIME
Performance tunning and sql profiler
I applied via Company Website and was interviewed in Jan 2024. There were 2 interview rounds.
Basic General knowledge questions in Aptitude test
(5 Questions)
- Q1. My personal details Hobbies Job purpose Salary expectation
- Q2. My personal detailsî
- Q3. Job purpose in daily life
- Ans.
The job purpose of a Junior Software Developer is to develop and maintain software applications.
Developing and coding software applications
Testing and debugging software
Collaborating with team members to design and implement software solutions
Maintaining and updating existing software
Troubleshooting and resolving software issues
Learning and adapting to new technologies and programming languages
- Q4. What are my hobbies
- Q5. Salary Expectations
Interview Preparation Tips
- Java
- Web technology
- SQL
Junior Software Developer Interview Questions & Answers
Societe Generale Global Solution Centre
Anonymous
posted on 5 Feb 2024
Selected
I applied via campus placement at Dayananda Sagar College of Engineering, Bangalore and was interviewed in Aug 2023. There were 4 interview rounds.
It wa easy , there were 20 mcq and 2 coding question .
(1 Question)
- Q1. In the first round of interview it was all techical based question . Topics like OOPs , Data structures were covered.
(1 Question)
- Q1. This round was a technical+managerial round. I was given senarious ans situations and asked for solutions for them.
(1 Question)
- Q1. This was the last round , and was purely HR based.
I applied via Naukri.com and was interviewed in Aug 2023. There were 4 interview rounds.
(1 Question)
- Q1. Experience,ctc,expected ctc
(1 Question)
- Q1. Plsql concepts , procedure , functions
(1 Question)
- Q1. Plsql advance concepts, procedure , function
Full Stack Software Developer Interview Questions & Answers
NTT
DINESHWARI V RAJA
posted on 4 Jun 2024
(1 Question)
- Q1. Springboot -all questions relevant to springboot were asked
My best past is the core java and oops concepts also
Any one topic I can accept it.
(1 Question)
- Q1. Tell me about yourself
- Ans.
I am an experienced SQL Developer with a strong background in database management and query optimization.
Over 5 years of experience in SQL development
Proficient in writing complex SQL queries and stored procedures
Expertise in database performance tuning and optimization
Familiarity with various database management systems such as Oracle, MySQL, and SQL Server
Strong problem-solving and analytical skills
Ability to work ef
(1 Question)
- Q1. What is your strength
- Ans.
My strength is my ability to write efficient and optimized SQL queries.
Proficient in writing complex SQL queries
Optimizing queries for better performance
Strong understanding of database design principles
Experience with query tuning and indexing
Ability to analyze and optimize query execution plans
Interview Preparation Tips
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.3k
salaries
|  ₹5.1 L/yr - ₹16 L/yr |
|
Programmer Analyst
55.5k
salaries
| ₹2.4 L/yr - ₹9.6 L/yr |
|
Senior Associate
48.4k
salaries
| ₹8.9 L/yr - ₹27.3 L/yr |
|
Senior Processing Executive
28.8k
salaries
| ₹1.8 L/yr - ₹9.3 L/yr |
|
Technical Lead
17.6k
salaries
| ₹5.9 L/yr - ₹24.8 L/yr |
TCS
Infosys
Wipro
Accenture
- Home >
- Interviews >
- Cognizant Interview Questions >
- Cognizant Ssis Developer Interview Questions
