Monday, March 28, 2011

SSIS Interview Questions

Below are some questions I recently asked while interviewing for an SSIS developer. Thought they might be helpful to others looking to hire. Answers to follow . . .
  1. Have you used SSIS in a project/product type of environment as opposed to an operational/once-off type of an environment?
  2. Have you worked with a hierachical/modular type of SSIS project with packages calling other packages? If so, did you pass values back and forth between the packages and if so, how?
  3. Have you dealt with package versioning and if so, how?
  4. Have you used any of the package configuration functionality within SSIS? If so, which types and for what types of values?
  5. Have you used any kind of restart mechanisms in SSIS? If so, which one(s)?
  6. Have you developed packages that could be migrated from one environment to another without any code changes (directory locations, database connections, etc.)? If so, how?
  7. Which data flow transformations have you used?
  8. Are you familiar with dimensional/star-schema modeling and concepts such as junk dimensions and slowly changing dimensions?
  9. Have you used the Slowly Changing Dimension transformation? If so, what if any issues did you encounter while using it?
  10. What kind of logging have you used with SSIS, if any?
  11. Have you used package event handlers for any kind of processing logic?
  12. What types of debugging tools/methods have you used with SSIS?
  13. Have you used script components and if so, what language are you most comfortable with?
  14. Where have you stored/deployed your production SSIS packages (file system or msdb)? What is your preference and why?

1 comment:

  1. Thank you for sharing valuable "SSIS Interview Questions".

    Placement Papers