Well if you reading this you must be interested in a career in data warehousing.
Data Warehousing is vast field.
So even if you are involved with data warehousing it not necessary that you work in main field that is creating the data warehouse.
You can take several roles in the project.
I will try to explain in detail two real time projects in latter blog
Well there are plenty of career which you can take depending on your skills set,experience or interest.
1. ETL developer : This is main person who works on creating mapping(in informatica).That is he develop the code which move the data from source to target.
2.DBA : Generally for Data Warehousing DBA will be allocated.His main job will be to maintain tables in data warehouse and deals with other DBA issues like indexes,keys etc.
3.UNIX administrator : Well generally information server is installed on UNIX server.So we need an admin to take care of various issues like space allocation in unix etc.
4.Data Modeller : Well this job is coolest.You are required to be the first to analyze the source data and build the data warehouse accordingly.
5.Testing: Well yeah we have testing too.Testers will analyze the data that you loaded into Data Warehouse and check the consistency of data with source data.
6.Repors Developer : Ok.The data warehouse has been build but who is going to use it.Here come the person who will prepare reports on data loaded into datawarehouse like "sales of shop in north region" in graph format so that Business Users Can use it
Depending on the project you may need few other people too.
Please leave your comment and view
Thanks for Reading
Monday, July 6, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment