October 27, 2011 at 8:23 pm
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.
October 27, 2011 at 9:02 pm
No offense but if you're going to a job and don't know about data modeling/ETL at all then they'll sniff that out real quick. If you're really that new to it I'd suggest being honest about your level of knowledge and at least cite some good resources you could turn to to help get you up to speed. Try checking out SQL University (http://sqluniversity.org) and check out some of the posts there. David Stein did a great intro to data modeling and data warehousing and we've got some great ssis content to. Good luck!
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
October 27, 2011 at 9:18 pm
Thanks so much.I have some knowledge in Data Modeling and Pretty good knowledge in SSIS.But I never attended a face to face interview.I thought of asking what kind of questions they may ask in face to face interview.I already cleared telephonic round but was in doubt what else they can ask during in person interview.
October 27, 2011 at 9:24 pm
You'll hate this answer but "it depends". Is this a junior position? Senior? Best thing to do is be prepared for anything. Whats difference between control flow and data flow? What's difference between synchronous and asynchronous tasks? Explain difference between a relational model and dimensional model? Again, don't try to cram and then spit back canned responses, interviewers can quickly tell if you know what you're talking about.
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
October 27, 2011 at 9:29 pm
This is a bit senior position.I never worked on SSIS.I worked as a SQL Server Developer.I have knowledge on all tasks and transformations.I dont know if they ask me to create a package or troubleshoot a package then I will be out of that position 😀
October 28, 2011 at 12:33 am
srik.kotte (10/27/2011)
This is a bit senior position.I never worked on SSIS.I worked as a SQL Server Developer.I have knowledge on all tasks and transformations.I dont know if they ask me to create a package or troubleshoot a package then I will be out of that position 😀
Senior position - Pretty good knowledge in SSIS - I never worked on SSIS
No offense, but don't you see a flaw somewhere?
Just be honest about your level of expertise and as SQLChicken said, try to explain how you would improve yourself. If you get your way through the interview but you can't handle the job, they will notice and your reputation is ruined.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 28, 2011 at 9:53 am
A bit senior..
Sir, not to be too unpleasant, but you don't even qualify for "a bit junior". Honestly you aren't doing anybody any favors by trying to get a job so far outside your experience. Sure it is usually a good thing to push yourself but this is like saying you are a marathon runner when you haven't seen your toes in years or spend all your time on the couch..
Short answer, you aren't ready, be honest about your experience, don't lie, that always comes back in the end they might be willing to do some training.
CEWII
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply