Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Datawarehousing
- Thread starter vsatec
- Start date
Read the landmark of dw from 1998, Ralph Kimball's . It kicks ... If that does not insprire, consider something else.
The Data Warehouse Lifecycle Toolkit: Tools and Techniques for Designing, Developing, and Deploying Data Warehouses
Read his other books too. See
Another writer with a different approach is WH Immon. You don't have to see the two approaches opposite, in reality best of both worlds are applied.
Can't say anything about career evolution.
Cheers
[blue]Backup system is as good as the latest recovery[/blue]
The Data Warehouse Lifecycle Toolkit: Tools and Techniques for Designing, Developing, and Deploying Data Warehouses
Read his other books too. See
Another writer with a different approach is WH Immon. You don't have to see the two approaches opposite, in reality best of both worlds are applied.
Can't say anything about career evolution.
Cheers
[blue]Backup system is as good as the latest recovery[/blue]
johnherman
MIS
Like most computer fields and niche areas, salaries in data warehousing depend on your experience, the company needs, the company salary structure, and geographical location of work.
You can't really switch from Java to DW or CRM. DW and CRM are *applications* while Java is a language or tool. Java could be used to build a CRM or DW application.
I also recommend "The Data Warehouse Lifecycle Toolkit" by Kimball et al and either "Building the Data Warehouse" by Inmon or "Corporate Information Factory" by Inmon et al. as good foundation books.
IMHO, your best bet is to study DW to see if you like it, then try to hook on at a DW project seeking Java experience. They leverage your java, you learn DW - a win/win situation.
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
You can't really switch from Java to DW or CRM. DW and CRM are *applications* while Java is a language or tool. Java could be used to build a CRM or DW application.
I also recommend "The Data Warehouse Lifecycle Toolkit" by Kimball et al and either "Building the Data Warehouse" by Inmon or "Corporate Information Factory" by Inmon et al. as good foundation books.
IMHO, your best bet is to study DW to see if you like it, then try to hook on at a DW project seeking Java experience. They leverage your java, you learn DW - a win/win situation.
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
- Thread starter
- #4
Thank you guys for your replies.
I would like to go in more details about why i want to switch from Java to DW.
I had very good job. Then last year i gave birth to baby boy who has minor medical condition. That's the reason i quite java job because that job was onsite. Right now, i'm getting interview for java jobs but all are onsite. Because of my son, i'm looking some kind of career i can do from home. Someone told me that as DW you can have more chances to get jobs from home or night jobs. Is it true?
Thank you again,
vsatec
I would like to go in more details about why i want to switch from Java to DW.
I had very good job. Then last year i gave birth to baby boy who has minor medical condition. That's the reason i quite java job because that job was onsite. Right now, i'm getting interview for java jobs but all are onsite. Because of my son, i'm looking some kind of career i can do from home. Someone told me that as DW you can have more chances to get jobs from home or night jobs. Is it true?
Thank you again,
vsatec
johnherman
MIS
It is possible you could do DW support in the ETL (Extract Transform and Load) from a remote location. ETL is the periodic (usually nightly but possibly weekly or monthly) process which Extracts data from the transactional systems, performs Transformations on the data so that the data in the warehouse is standardized, then Loads the data into a relational or multidimensional database. Writing code for these processes, and supporting their daily (weekly, monthly) execution could be performed at home. Other than that, I don't see how DW could be done remotely, there is a considerable amount of time and effort associated with user requirements and the use of spiral development methods which indicate that considerable on-site work is indicated.
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
- Thread starter
- #6
johnherman
MIS
A good book on (general) ETL was just published, The Data Warehouse ETL Toolkit by Kimball and Caserta.
ETL can be coded using languages such as VB, but is most often done using a tool such as Informatica, Data Stage, Ab Initio, or one of the other (lesser) competitors.
Just like any job, ETL salaries depend on experience, market demand, etc. Most DW projects will have a lead ETL person sometimes called ETL Architect or maybe Lead ETL Developer. Guess which title usually gets paid more?
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
ETL can be coded using languages such as VB, but is most often done using a tool such as Informatica, Data Stage, Ab Initio, or one of the other (lesser) competitors.
Just like any job, ETL salaries depend on experience, market demand, etc. Most DW projects will have a lead ETL person sometimes called ETL Architect or maybe Lead ETL Developer. Guess which title usually gets paid more?
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
- Thread starter
- #8
johnherman
MIS
There is and will continue to be some consolidation in the ETL tools area. At this time, there are over 20 companies providing solutions in this area. Within 5 years, I predict there will be less than 10. Informatica is one I expect to be around. Also Data Stage, Ab Initio, (Microsoft) DTS, and a couple more.
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
- Thread starter
- #10
johnherman
MIS
Yes, that's a good start.
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
- Status
Similar threads
- Locked
- Question