Data Warehousing Profession

It is estimated with reliable amount of evidences that India is going to become a super power in coming few decades. The economic progress is accelerated the reverse brain drain process, which is going to accelerate the industrial sector further. It means that their will be an increased demand for data warehouse users, employees and professionals in the future.

Good quality successful data warehouse systems require a considerable amount of time and expertise to develop and implement successfully at the user end. In other words, it takes some time to gain experience with the usual problems that develop at different phases of a data warehousing effort. Now we will examine few areas, which are expected to generate job opportunity:-

Few specialised areas of data warehousing profession

Customer relation manger (CRM) – Analytic development and management

Senior Data warehousing consultant.

Principle consultants and data miner.

Data warehouse project leader.

Data warehouse designer and architect.

Data warehouse team leader.

Data warehouse administrators.

Data warehouse manager.

Data modeler/architect.

IDBM (IBM Data wareshousing and Business Modeling).

Oracle warehouse builder

SAP BW (Business Warehousing)


Role and skills required
Extraction, Transformation & Loading related to Data warehouse, Data mining. It requires the ability to work on Data warehouse Design and Micro Strategy based Business Intelligence/ Data warehousing projects.

Responsibilities
Develop applications for data extraction, transformation, and loading optimized for maximum scalability with minimum maintenance requirements.
Develop business intelligence applications for data analysis optimized for the best performance and scalability requirements using Micro Strategy technology.
Work directly with the overseas Data Warehousing users and partners.
Work closely with the onshore team to create a client-focused software development culture focused on professionalism, productivity and flexibility.
Experience

Since all areas mentioned above, needs communication with oversees users and Indian users, high level verbal and written communication skills in English is an essential and general requirement.
Nearly five years of experience on Data Warehousing projects with any of the following databases - Oracle, Microsoft SQL Server, DB2, Teradata.
Experience with one or more of the following Business Intelligence tools: MicroStrategy, Cognos, Business Objects.
Experience with one or more of the following tools: Informatica, Datastage, DTS, Oracle Warehouse Builder.
Strong SQL, data modeling and analytical skills.
Experience with Unix/Linux Shell Scripting is desirable.
Experience with Multinational software development organizations in India or overseas is desirable.
Any data warehousing professional should be self-motivated and able to excel in a fast-paced environment. The ability to prioritize tasks and work concurrently on multiple tasks is essential. Education qualification required becoming a data warehousing professional is B.E/B.Tech, MBA, MCA, M.E/M.Tech/MS, PGDCA, PGDM.
Training Institutions

In India most of the Universities, IITs and other Engineering Colleges are offering formal courses at various UG and PG degree in Computer/Systems science with Data warehousing as a principle subject. In the higher education segment, lot of research has been conducted and many are in the progressing stage. In this context our young researchers and academic institutions should provide opportunity for research and development in Data warehousing. For getting commercial and industrial training one has to depend on private institutions.