Hi Kalasql, I do not know what position you are applying to, and what is your level of comfort with SSIS (data modelling though is another forum). When it comes to face to face interviews, you obviously have very little time to prepare to respond, so you need to know what you are talking about, yet the interviewers tend to discuss various pitfalls or just interesting user experiences/stories, at least in my experience. When I hire people I normally throw a couple of hard questions in hope to see how much exposure a candidate potentially had. There are several good places to start on SSIS Q 'n As: PDF with questions: http://www.sql-server-business-intelligence.com/sql-server/interview-questions-and-answers/ssis-interview-questions-and-answers-pdf-download a short list: http://blog-mstechnology.blogspot.com/2010/06/ssis-interview-questions-and-answers.html Thread on MSDN Forum: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/b2ede456-ce40-4978-ba86-0b42270da875/Arthur My Blog

Hello, I am new to SSIS.I have a face to face interview on ETL Concepts and Data Modeling.I dont have any idea what they gonna ask me in face to face interview.I never attended a face to face interview on SSIS or Data modeling.Please suggest me.Any help is much appreciated. Thanks in advance.

Hi Kalasql, I do not know what position you are applying to, and what is your level of comfort with SSIS (data modelling though is another forum). When it comes to face to face interviews, you obviously have very little time to prepare to respond, so you need to know what you are talking about, yet the interviewers tend to discuss various pitfalls or just interesting user experiences/stories, at least in my experience. When I hire people I normally throw a couple of hard questions in hope to see how much exposure a candidate potentially had. There are several good places to start on SSIS Q 'n As: PDF with questions: http://www.sql-server-business-intelligence.com/sql-server/interview-questions-and-answers/ssis-interview-questions-and-answers-pdf-download a short list: http://blog-mstechnology.blogspot.com/2010/06/ssis-interview-questions-and-answers.html Thread on MSDN Forum: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/b2ede456-ce40-4978-ba86-0b42270da875/Arthur My Blog