Which should be a better career option – software testing or data warehousing?
It depends actually. Software testing will always be around as new applications are being built. There is some skill required as you will basically be running user processes that are not in the manual (if the manual for the application is written at all). But generally, basic computing skill is all that’s required. Data warehousing on the other hand is tricky at best and testing. People who intend to go build a data warehouse are suggested to have the basic discipline of understanding operational/transactional processes and translating it to the data. It really more of translating a business definition to a technical definition. Business value “A” is the aggregate of column “W” divided by “X” if condition “Y” is satisfied else “Z”. Most enterprise systems define these sort of stuff on the fly and is not translated to any ounce of definition on the systems. Additionally, what is record by record transaction to SQL developers will be quite rare on data warehouses. DW’s are more akin to j