Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

How to break into data warehouse management Expand / Collapse
Author
Message
Posted Wednesday, July 9, 2014 12:44 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:30 PM
Points: 38, Visits: 173
Hi All,

I'm hoping I can get some valuable input from people in the field. My current and past jobs have been junior developer roles, working with MS SQL Server some .Net (although I wouldn't say I'm a programmer by any means), and SSIS/SSAS under the supervision of senior developers.I've been interested in working more with databases and am wondering how I can break into a data warehouse management position? Any advice would be appreciated. Thanks!
Post #1590912
Posted Wednesday, July 9, 2014 4:51 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:51 AM
Points: 558, Visits: 1,652
If your current position has you supporting data warehouses and gives you opportunity to develop SSIS jobs, do as many as you can, dotting the i's and crossing the t's (by adding features like error handling/reporting that might be skipped by novices or in rush jobs).

You might also study for Microsoft Exam 70-463. Passing it would be a powerful reason for someone to hire you for this job.
Post #1590969
Posted Thursday, July 10, 2014 6:55 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 2:54 PM
Points: 820, Visits: 2,135
You could also do work for yourself on the side to learn the tools. I've had several candidates for an open position tell me they are interested in BI, but they haven't done anything with the tools. I broke into programming and database work by doing things on my own time to learn how the tools work. I started data warehousing as a work requirement, but I'd expect someone who told me they wanted to break in what they have been doing on their own and why they find it so intereting.


Post #1591128
Posted Thursday, July 10, 2014 7:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:30 PM
Points: 38, Visits: 173
Thanks, Dan. Unfortunately my current position doesn't afford me the opportunity to do the things you've mentioned, but my previous position did. I will definitely look into the exam you referenced. Thanks!
Post #1591138
Posted Thursday, July 10, 2014 7:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:30 PM
Points: 38, Visits: 173
Thanks, Ron. Are there any data warehousing tools you can suggest I can look into? I agree with what you're saying and I'd like to familiarize myself with such tools on my own time, if that's what it takes.
Post #1591140
Posted Thursday, July 10, 2014 7:43 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 2:54 PM
Points: 820, Visits: 2,135
The MS stack is available in the developer's edition. It's very inexpensive as an investment in your career. Read Ralph's Kimballs data warehouse books and start learning.


Post #1591155
Posted Tuesday, July 15, 2014 1:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:30 PM
Points: 38, Visits: 173
Hi Ron,

Thanks again for the input. By the MS stack, are you referring to the MS SSIS/SSAS/SSRS tools? If so, would the Express Edition suffice for learning?
Post #1592786
Posted Tuesday, July 15, 2014 2:09 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 2:54 PM
Points: 820, Visits: 2,135
Yes, that's what I'm refering to, and no, the Express edition will not suffice. That is a very scaled down version of SQL Server.


Post #1592793
Posted Tuesday, July 15, 2014 3:35 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:51 AM
Points: 558, Visits: 1,652
Express will not work. In fact, if you install SQL Server Express 2012 on a workstation, you WILL NOT be able to properly install SQL Server Data Tools, which are required to develop SSIS jobs!

Fortunately, you can get the developer edition for a modest price. It looks like DVDs for 2012 Developer are no longer available from Microsoft, but you can get the 2014 Developer Edition
http://www.amazon.com/Server-Developer-2014-English-Only/dp/B00JKMY8KC/ref=sr_1_2?s=software&ie=UTF8&qid=1405459309&sr=1-2&keywords=microsoft+sql+server+developer+edition
Post #1592828
Posted Wednesday, July 16, 2014 10:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:30 PM
Points: 38, Visits: 173
Thanks, Ron and Dan. I happen to have th SQL Server Management Studio R2 2008 installed which I obtained via the MS Alliance with Universities, as I'm in school. I'm wondering how different 2008 is from 2012 and if it'll be adequate for practice/study purposes.

Also, what are your thoughts on obtaining certifications? I was looking at the MCSE line of certs, but am not sure if I should go the Data Platform or BI route. Do any of you have or plan on earning these?
Post #1593170
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse