Job market for sql server 2000/2005 Data warehousing/Business Intellgence developer

How is the job market for a SQL server 2000/2005 data warehousing and Business intelligence developer (AS, MDX, SSIS,RS,..)?  Is it good skills to have? What would be the future of DW/BI market?
jung1975Asked:
Who is Participating?
 
imran_fastCommented:
Is it good skills to have?
yes,
After the relational store the first major component of the SQL Server 2005 platform is Integration Services.
Enterprise ETL platform
High performance
High scale
More trustworthy and reliable
Best in class usability
Rich development environment
Source control
Visual debugging of control flow and data
Great range of transforms out-of-the-box
Highly extensible
Custom tasks
Custom enumerations
Custom transformations
Custom data sources
0
 
MikeWalshCommented:
Jung - to answer your question more directly rather than a generalization of 2005 components.. Yes they are marketable skills. People are deploying BI databases with SQL, and even if they are using other DBMSs (like Oracle as we talked about in your last employment type question about which skills to have, and I said both if you can), SSIS in 2005 and DTS in 2000 are used for a lot of ETL processes.

I would say it is first good to have solid DBA skills in general, then SQL DBA skills and Database development skills, then add to that a solid understanding of AS and it's components including the tools (DTS and SSIS in 2005) used to get data into the warehouse. Having a degree based in Mathematics helps with the DW end of things.
0
 
Craig YellickDatabase ArchitectCommented:
Microsoft bundles all of the BI/DW/OLAP and reporting tools into the base product price, which means anyone with an installation of SQL Server could potentially be in need of the services of such a developer. SQL Server does not (yet) dominate the market in terms of license dollars, but it does dominate the sheer number of installations.

Go to www.Dice.com and search on "microsoft sql server BI", as of this afternoon there were 95 listings.

From everything that I can see, BI in general and the Microsoft SQL Server platform in particular looks to be a good long-term career option.

-- Craig
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.