Data Warehouse Training

Anyone can start Data Warehouse Training course because there are no prior requirements necessary. We provide a 25-hour Data Warehouse course taught by instructors with more than 10 years of real-time experience. The course includes real-world assignments and the faculty will direct you toward setting a work environment to practice assignments.

Assistance in CV preparation, interview questions answers, and materials are part of the training program. We do advise taking a one-hour session every day, From Monday through Friday, but one can also look into the weekend, fast-track, one-on-one, or customized programs.

contact-number-svr-technologies

Data Warehouse Career

✔️Data Warehouse Pre-requisites

Basic Computer Knowledge.

✔️Jobs On Data Warehouse

Top IT MNC such as Capgemini, Cognizant, IBM, Infosys, Accenture, etc.,

✔️Data Warehouse Specialist Salary

The average salary for a Data Warehouse Specialist with 4 years experience in India is ₹13.0 Lakhs.

✍️ Detailed Course Curriculum

Our Technical expert will help you with real time issues. He also guide you in certification preparation and career mentoring if required.

Data Warehouse Course FAQ's

01. can you help me in CV preparation?
Yes, We can help you preparing your resume.

02. will you help in interview preparation?
We can provide you interview question answers. The course covered many real-time examples. These examples might help you.

03. Is this course sufficient to get a job?
Our training covered as many real-time examples as we can. This course may equivalent to 2 to 3 years of work experience. You have to work hard if you are aimed at 4+ years of experience.

04. What’s the certification process?
Please come with an exam code. We’ll guide you further. We’ll guide you on how to get certified. Don’t worry, we’ll help you in certification process.

05. Can you provide Work Support?
We can provide job support for an additional fee. Contact the support team for fee details. You can choose either the hourly rate or monthly fee.

DATA WAREHOUSE BASICS

  • Anintroduction to Data Warehousing
  • Purpose of Data Warehouse
  • Data Warehouse Architecture
  • Operational Data Store
  • OLTP Vs Warehouse Applications
  • Data Marts
  • Data marts Vs Data Warehouses
  • Data Warehouse Life cycle

DATA MODELING

  • Introduction to Data Modeling
  • Entity Relationship model (E-R model)
  • Data Modeling for Data Warehouse
  • Normalization process
  • Dimensions and fact tables
  • Star Schema and Snowflake Schemas

ETL DESIGN PROCESS

  • Introduction to Extraction
  • Transformation & Loading
  • Types of ETL Tools
  • Key tools in the market

DATA STAGE ADMINISTRATOR

  • Datastage Training project Administration
  • Editing projects and Adding Projects
  • Deleting projects Cleansing up project files
  • Environmental Variables
  • Environment management
  • Auto purging
  • Runtime Column Propagation(RCP)
  • Add checkpoints for sequencer
  • NLS configuration
  • Generated OSH (Orchestra Engine)
  • System formats like data
  • timestamp
  • Projects protect — Version details

DATA STAGE DIRECTOR

  • Introduction to Data stage Director
  • Validating Data stage Jobs
  • Executing Data stage jobs
  • Job execution status
  • Monitoring a job, Job log view
  • Job scheduling
  • Creating Batches
  • Scheduling batches

DATA STAGE DESIGNER

  • Introduction to Datastage Training Designer
  • Importance of Parallelism
  • Pipeline Parallelism
  • Partition Parallelism
  • Partitioning and collecting(In depth coverage of partitioning and
    collective techniques)
  • Symmetric Multi Processing (SMP)and Massively Parallel Processing
    (MPP)
  • Introduction to Configuration file
  • Editing a Configuration file

WORKING WITH PARALLEL JOB STAGES

  • Database Stages, Oracle, ODBC, Dynamic RDBMS
  • File Stages, Sequential file, Dataset
  • File set, Lookup file set
  • Processing Stages, Copy, Filter, Funnel
  • Sort, Remove duplicate, Aggregator, Switch
  • Pivot stage, Lookup, Join, Merge
  • Difference between look up, join and merge
  • Change capture, External Filter, Surrogate key generator
  • Transformer, Real time scenarios using different Processing Stages — Implementing different logics using Transformer

ADVANCED STAGES IN PARALLEL JOBS

  • Explanation of Typel and Type 2 processes
  • Implementation of Typel and Type2 logics using Change Capture stage
    and SCD Stage
  • Range Look process
  • Surrogate key generator stage
  • FTP stage
  • Job performance analysis
  • Resource estimation
  • Performance tuning

JOB SEQUENCERS

  • Arrange job activities in Sequencer
  • Triggers in Sequencer
  • Restablity
  • Recoverability
  • Notification activity
  • Terminator activity
  • Wait for file activity
  • Start Loop activity

IBM INFORMATION SERVER ADMINISTRATION GUIDE

  • Opening the IBM Information Server Web console
  • Setting up a project ion the console
  • Customizing the project dashboard
  • Setting up security
  • Creating users in the console
  • Assigning security roles to users and groups
  • Managing licenses
  • Managing active sessions
  • Managing logs
  • Managing schedules
  • Backing up and restoring IBM Information Server
  • Additional Features
  • Performance Tuning of Parallel Jobs
  • Data stage Installation process and setup
  • Project Explanation
review image svr technologies