Career Course : Career in Data Warehousing

Career in Data Warehousing


Career in Data Warehousing

A Data Warehouse ( DW ) is a collection of technologies and techniques aimed at enabling the knowledge worker ( executive, manager, analyst, etc ) to make better and faster decisions using various analytical tools. It can be defined as ‘subject – oriented’, integrated, time – varying, non – volatile collections of data that is used primarily in organizational decision making.

Hence in general it can be considers as a power full tool for analytical processing. Nowadays, data Warehousing has become an important strategy in integrating heterogeneous information sources in organizations, and to enable Online Analytic Processing ( OLAP ) and Online Transaction Processing ( OLTP ). The DBMS based present day systems used for the data collection ( accumulation ), storage, retrieval and further processing, doesn’t seem to be completely credible, reliable and dependable.

When it comes to the areas of OLAP, OLTP, ad – hoc query processing data formatting and data cleaning, decision makers need some system which function beyond the capabilities of an ordinary Database Management Systems ( DBMS ). Hence it will be incorrect to see Data warehouse as a bigger form of DBMS or simple upgradation of DBMS.

There is limited number of people available who have worked with the full data Warehousing system project “Life Cycle”. In view of fast economic growth and industrial progress in our country and in the future we need more decision makers. Our small ( Small and Medium Enterprises – SME ) business organizations are growing to big organizations and to the level of Indian multinational companies.

Consider the resent large scale acquisition or consolidation of Indian companies both in India and abroad even from industrialised European countries and in the coming time, we can see this trend will gain momentum. To successfully complete the acquisitions or consolidation and to run the emerging big organizations, we need more data Warehousing professionals for analyzing the past and present data, and for making future prediction in the industry.

Such activities are called Business Intelligence ( BI ), which is a highly demanding IT application area in the industry. Banking, Insurance Health Care, Credit Card Service Providers, academicians, scientist and researchers are widely using data Warehousing and data mining technology for their various analytical activities. In view of the above and the proposed Indian banks consolidation and merging, Data Warehousing is going to generate lot of new opportunity for the IT professional, which are lying under utilised now.

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 in brief :

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 :

  1. Develop applications for Data Extraction, Transformation, and loading optimized for maximum scalability with minimum maintenance requirements.
  2. Develop business intelligence applications for data analysis optimized for the best performance and scalability requirements using Micro Strategy technology.
  3. Work directly with the overseas Data Warehousing users and partners.
  4. 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.

  1. Nearly five years of experience on Data Warehousing projects with any of the following databases – Oracle, Microsoft SQL Server, DB2, Teradata.
  2. Experience with one or more of the following Business Intelligence tools : MicroStrategy, Cognos, Business Objects.
  3. Experience with one or more of the following tools : Informatica, Datastage, DTS, Oracle Warehouse Builder.
  4. Strong SQL, Data Modeling and Analytical Skills.
  5. Experience with Unix / Linux Shell Scripting is desirable.
  6. 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. Few such institutions are listed below.

SQL Start International Bangalore Centre,
40 / 4, 3rd floor Lavella Road,
Above Mandovi Motors,
Behind Browsing Institute,
Bangalore - 01.
#9, 100 Feet Ring Road, BTM 1st Stage,
Opp. BTM Water Tank,
Facsoft Technology Pvt Ltd,
89 / A, 3rd Floor, 1st Main Road,
Gandhi Nagar, Adyar,
Chennai - 20.
Sumukha Technologies,
Address 18, 2nd Floor, 59th Cross,
5th Block Rajajinagar,
Bangalore - 10.
#47, 2nd Floor, Millers Road,
Opp Mahaveer Jain Hospital,
Bangalore - 52.
S.G.Infotech (India) Pvt. Ltd.,
8 / 12, 1st Floor, Honnam Complex,
South Cross Road, Basavanagudi,
United Systems Infotech (P) Ltd.,
30 / 1, 1st Floor, Cunningham Road,
Above Food World,
Neologik India,
329, 3rd Floor, GVS Complex,
22nd Cross, 3rd Block, Jayanagar,
3 - 4, Farida Indl. Estate,
N.S. Palya, BTM 2nd Stage,
Alpha Data India,
1143 / 1, 100 ft. Ring Road, opp. DSERT,
Banashankari III Stage,
Yashasvi Technologies,
115/3, 2nd Floor,
11th Cross, Margosa Road,
Matrix Enterprise Solutions,
34, 2nd Floor,
5th Cross, 5th Block,
Opp. Vijaya Bank, Koramangala,
Silpa Informatics,
100 ft. Road, Indiranagar,
Veonix, Near ISKCON,

TAGS: , ,

Career in Data Warehousing – Few specialised areas of Data Warehousing Profession – Responsibilities – Experience – Training Institutions – Data Warehousing Jobs

Career Course Related : Career in Data Warehousing, Data Warehousing Architecture, Data Warehousing and Data Mining, Career in Data Warehousing, Data Warehousing and Business Intelligence, Data Warehousing Advantages, Data Warehousing as Career, Data Warehousing Basic Concepts, Data Warehousing Bangalore, Data Warehousing Benefits, IBM Data Warehousing Certification, Oracle Data Warehousing Certification, Data Warehousing Development Life Cycle, Data Warehousing Career, Data Warehousing Education, Data Warehousing Environment, Data Warehousing History, Data Warehousing Higher Education, Data Warehousing Institutes in Hyderabad, Data Warehousing Jobs in Bangalore, Data Warehousing Jobs in India, Non Volatile Data Warehouse, Data Warehousing Kolkata, Data Warehousing Life Cycle, Data Warehousing Opportunities, Data Warehousing Online Training, Data Warehousing Salaries, IDBM Bangalore, Career Courses, Options, Offering Colleges, Universities, Course Duration, Features, Available Seats, Admission Procedures, Application Form, Fees, Career Courses in India,

Posted In career course : Leave a response for career in data warehousing by Yoga A

Leave a Comment for Career in Data Warehousing

2 Responses to “Career in Data Warehousing”

  • I want more information about the data warehousing i am E&tc engg can i do this course and is there any % criteria for this course?
    By Vrushali Pawar from Pune, Maharashtra on March 17, 2016 at 11:27 pm
  • I want more information about the data warehousing i am E&tc engg can i do this course and is there any % criteria for that course?
    By Vrushali Pawar from Pune, Maharashtra on March 17, 2016 at 11:26 pm
  • I want more information about the data warehousing i am E&tc engg can i do this course and is there any % criteria for that coure?
    By Vrushali Pawar from Pune, Maharashtra on March 17, 2016 at 11:25 pm
  • I am doing MCS from pune university. I want to do carrer in Data warehousing And Data Mining. so please suggest me same.
    By santosh raut from pune on January 3, 2013 at 2:57 pm
  • I am an MCA fresher, Can I get a job in Data Mining or data warehousing..?
    By Vinay Ranjan from jalandhar on December 2, 2012 at 12:16 am