IDC Technologies Ssis Developer Interview Questions and Answers

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...read more
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...read more
Answered by AI
Add your answer

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

Q1. 
Sum of Two Numbers Represented as Arrays
Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...read more
Ans. 
Given two numbers represented as arrays, calculate their sum and return the result as an array.
• Iterate through the arrays from right to left, adding digits and carrying over if necessary

• Handle cases where one array is longer than the other by considering the remaining digits

• Ensure the final sum array does not have any leading zeros
Answered by AI
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.