Financial Accounting Basic Settings

  • DataWareHousing Concepts
  • What is Data Ware House?
  • Difference between OLTP and DataWare Housing
  • Data Acquisition
  • Data Extraction
  • Data Transformation
  • Data Loading
  • Data Marts
  • Dependent Data Mart
  • Independent Data Mart
  • Data Base Design
  • Star Schema
  • Snow Flake Schema
  • SCD(slowly changing dimension)
  • Type-1 SCD
  • Type-2 SCD
  • Type-3 SCD

ETL Tool: Informatica

  • Designer
  • Workflow manager
  • Workflow monitor
  • Transformations
  • Source Structure
  • Target Structure
  • Mappings
  • Mapplets
  • Paramets
  • Variables
  • Reusable T/R
  • Sessions
  • Types of Transformations
  • Lookup concepts
  • Incremental Aggregation
  • Tasks
  • Scheduling
  • Basic Concepts in SQL
  • Overview of ETL Tool Architecture
  • White Box and Black BOX Testing Functionality on Different Transformation Rules
  • Data Ware House Life Cycle
  • Different Types of Testing Techniques in ETL
  • Minus Queing
  • Count Queing
  • ETL Testing Concepts
  • Informatica Transformations and their functionality
  • Introduction
  • What is use of testing
  • What is quality & standards
  • Responsibilities of a ETL Tester
  • Software development life cycle
  • Waterfall model
  • V-model
  • Agile model & methodology
  • White box testing
  • Black box testing
  • Grey box testing
  • ETL Testing Work Flow Process
  • How to Prepare the ETL Test Plan
  • How to design the Test cases in ETL Testing.
  • How to reporting the Bugs in ETL Testing ?
  • ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
  • How to detect the bugs through database queries
  • ETL Performing Testing & Performing Tuning
  • Basic Unix concepts

Quick Form