Oneqsoft

Menu
Job Portal
Start Course

ETL Testing with Informatica - Mastering Data Quality Assurance

One-Q Soft offers you complete practical and Real-time ETL Informatica Power Center training with basic to advanced concepts along with DWH Concepts.

Here in One-Q Soft– along with this course we also include concept wise documentation, Real-time scenario, Project solution, Project use case & interview preparation guidance for your job interviews.

Why only One-Q Soft

  • 1400+ professionals trained on different technologies.
  • Splendid Certified and Experienced Trainers.
  • Highly Interactive & Classroom training
  • Customised complete course notes
  • Job guidance
  • Guidance on official certification

ETL Testing Informaticaa Highlights

  • Free Demo class
  • 45 days class room training
  • Successfully trained 1000+ learners
  • Customised course notes
  • Live instructor-LED Online and Classroom training
  • Real-time practical guidance
  • Doubt clarification schedules
  • Basic to advanced training
  • Interview Guidance

ETL Testing Informatica Course Overview

ETL is done to ensure that the data that has been loaded from a source to the destination after transformation is performed. It also involves the validation of data in different stages used between source and destination using Informatica Power Centr. ETL stands for Extract-Transform-Load.

Apart from delivering you the best ETL development training, you will also get many other extra learning concepts which include, advanced material for ETL developmentinterview questions and Job Guidance.

ETL Testing Informatica Course Curriculum

  • ETL Development
    • Introduction to ETL Development
    • Importance of ETL Development
    • Difference between different ETL tools
    • Oracle
  • SQL
    • DDL, DML, DCL, TCL & DQL
    • Sub Queries & Case Statement
    • SET Operators
    • Window Functions
    • Joins
    • Views
    • Predefined Functions
    • Temporary Tables and CTE
    • Clauses
    • Aggregate Functions
    • Indexes
    • Procedures
    • User Defined Functions
  • Data Warehouse
    • What is Data Warehouse
    • Purpose of Data Warehouse
    • OLTP and OLAP
    • Data Marts and ODS [Operational Data Store]
    • Dimensional Modelling
    • Types of Dimensional Modelling
    • Dimension and Fact Tables
    • Normalization and Denormalization
  • ETL Tool
    • Introduction to different ETL tools
    • About Informatica Components
    • Designer o Repository Manager
    • Workflow Manager
    • Workflow Monitor
    • Power Centre Admin Console
    • Informatica Concepts and Overview
    • Informatica Architecture
    • Power Centre Components
    • Designer o Repository Manager
    • Informatica -Sources
    • Informatica -Target
    • Informatica -Transformations
    • Workflow Manger – Creating Reusable tasks
    • Workflow Manger – Workflows, Worklets & Sessions
    • Workflow Manger – Tasks
    • Session
    • Types – Decision task, Control Task, Event wait task, Timer task
    • Monitoring workflows and debugging errors
    • Indirect Loading
    • Constraint based load ordering
    • Target Load plan
    • Worklet, Mapplet, Reusable transformation
    • Scheduling Workflow
    • Parameter and variables
    • XML Source, Target, and Transformations
    • Performance Tuning – Pipeline Partition
    • Performance Tuning – Dynamic Partition
    • Performance Tuning – Pushdown optimization
  • ETL Testing Validations
    • Source Files check
    • Metadata Check
    • Integrity check
    • Data Transformation check
    • Data difference check
    • Data quality check
    • Performance check
    • SQL queries for Testing
    • Creating SQL queries based on requirements
    • ETL Pipeline Checks
    • Practice-1
    • Practice-2
    • Practice-3
    • Practice-4
    • Practice-5
    • Practice-6
    • Practice-7