Company :Capgemini    

1. Entire project work flow in ssis what sources and transformation have you applied.

2. Transaction In SSIS Package

3. Have you used temp tables in packages? Is there any property that we need to take care of?

4. Which kind of dimension have you implemented through package, have you know type of dimension

5. Type of Fact

6. SCD and it's Type, have you faced any difficulty?

7. Have you done package configuration, how do you manage your connection in different environments like UAT,Production,development.

8. If there is any package that fails in production and I want to know what is the reason for it and we people do not have access in the production environment, how do you find out the error?

9. How do you trace your query from a performance point of view?

10. Have you worked on column store index? disadvantage of column store index

11. Scenario: If I have 2 tables,  1st table contains 1000 rows along with duplicate data, without any primary key,indexing and 2nd table has composite key  (column 1 and column2) then I want to insert this data without duplication. How will I do that?

12. Have you used intersect and Except? performance wise which is better as I can get same output with join as well

13. CTE?  Can we create an index on CTE?

14. Have you used triggers?

15. Reporting Tool, have you worked on power BI?

16. Cascading parameter in SSRS