For 3 yrs experience:

Technical assessment on SSIS & SQL.

SSIS questions in assessment: 25 SQL: 5 Total questions: 30 Time: 40 mins

After completing the assessment, you will receive a call for the Skill Round (1st interview).

Managerial Round (2nd interview).

About the project?

What is Package Configuration?

What is logging and non-logging transformations?

What is SSIS logging?

What is a container: sequence, for loop, and foreach loop?

What is delay validation?

What is a lookup transformation and how do you implement it?

What is a breakpoint and a checkpoint?

In which conditions will you use breakpoints, checkpoints, delay validation, and SSIS logging, and how do you implement them all?

What are multicast, data conversion, and derived column transformations?

What are merge and union all transformations, and how do you implement them?

What is a variable?

What is the work of a row count transformation?

How do you implement transactions in SSIS?

Where do you use and how do you implement a send mail task?

What is a parent and child package?

Scenario -> If you have a text file, a CSV file, and an Excel file, and you have to load them into SQL tables, which transformations do you use?

How do you deploy and execute an SSIS package?

How do you improve the performance of a package?

Can we use a temp table in SSIS? If yes, then how do you implement it?

If you have multiple sources with high-volume data and you have to load data into a destination, which tasks and transformations do you use in this case?

SQL - 3rd highest salary, duplicate records, nth salary, triggers, functions, stored procedures, views, list employees who joined in the last 6 months, date before 3 months, date after 10 months, cross and self-join, nested views, composite keys, find the 2nd highest salary using a subquery, indexes - clustered and non-clustered, normalization.