Ask IT Career Coach
Start a data warehousing career by learning what data warehousing is all about.
A Data Warehouse is often referred to as an OLAP (Online Analytical Processing) Database as opposed to traditional relational database designs known as OLTP (Online Analytical Transaction Processing).
There are several terms, processes and terminologies that are peculiar to Data Warehousing which you have to learn.
These include terms like OLAP, MOLAP, HOLAP, DATAMART, CUBE, ETC. You may find a complete list of these terms in the article titled: How To Become A Data Warehouse Architect
Data warehouses are essentially large aggregated databases designed to support Decision Making, Analysis and Reporting.
Building a DataWarehouse is like designing a de-normaliez databases. In other words, you invert some of the principles you\'ve learnt to practice as a relational database developer.
In addition, data warehousing architects extract and aggregate data from several relational databases, so the first step to becoming a data warehousing architect is to learn database development.
In addition, no-one will probably give you a data warehousing architect job if you don\'t already know how to design or develop optimized relational databases.
So, this is not a career for freshers but a career that you can grow into after getting strong experience as a database developer.