SSIS questions
Any idea for SSIS test for interview?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Some other points based on SSIS interviews I've both given and participated in:
Tell me how you performed production support on SSIS package failures, or success where the data processed was not what the client expected.
What third-party tools have you used in SSIS development?
Have you ever had to deal with confidential information (banking, healthcare, PII) and how did you protect it?
What other ETL packages have you worked with besides SSIS?
What is your preference, Extract-Transform-Load (ETL) or Extract-Load-Transfer (ELT)?
When would you write code in a Stored Procedure vs. complex transforms in an SSIS package?
btw related to elliciting requirements I have an article out there called Requirements Document Template for an ETL Project that would help with interview prep.
I went on a tear and wrote a new article on your question. Let me know how your interview went, and specifically if you have any lessons learned from the interview that I didn't cover in the article please comment in my article, so I can add your content.
Thanks.
Jim
Thanks.
Jim
http://www.msbiguide.com/2012/12/ssis-interview-questions-and-answers/
https://www.linkedin.com/pulse/ssis-interview-questions-khanh-phung