Bootstrap Example

ETL Testing

ETL Testing

If someone were to ask, "Do you know what software engineering is?" I'm assuming you'd say "yes" in response. However, it could be challenging to define software engineering. That's okay; everybody would. Software engineering seems like a simple concept at first glance, but as you dissect it, the complexity rises. What do programmers do all day long? What new applications of technology have coding received? How does one enter the field of software engineering? How does one advance? Can you switch your programming interests? I'm the first to say that I adore programming. Programming is a skill that allows you to run and execute your own code to produce the desired result. The software sector is also incredibly diverse and active, offering possibilities to people of all skill levels. Whether you're an analytical powerhouse or a creative artist, engineering has a place for you.

However, training in the ETL testing training in Chennai can help you land a job with a high income. A co-op or internship should be in your future regardless of whether you plan to earn a degree (or three). Internships allow you to obtain real-world experience while you are still in school, which is the ideal way to learn. Programming internships are advantageous since they provide you the freedom to select the kind of career you want to follow. Do you like the creative aspect of coding or dealing with statistics and analytics? Because software departments have so many moving parts, internships in ETL testing training in Chennai and cooperative education programmes can let you pick and choose which projects and promotions you want to be a part of. Because there are so many possibilities, it can be challenging to choose the Best ETL testing training institute in Chennai.

One's confidence and optimism may increase as a result of being at SOFTWARWE TESTING TRAINING INSTITUTE(STTI) and taking on this mission. Every aspect of employability is covered in our curriculum, and top CMM companies, MNC business goliaths, and Tier 1 IT companies regularly assist with placement. The best ETL testing training institute in Chennai, SOFTWARWE TESTING TRAINING INSTITUTE(STTI), just prepares and enables a person to pursue a job in the corporate setting.

Syllabus of ETL Testing Online Training Course
Module 1 : DWH Data Ware Housing Concepts
  • What is Data Warehouse?
  • Need of Data Warehouse
  • Introduction to OLTP, ETL and OLAP Systems
  • Difference between OLTP and OLAP
  • Data Warehouse Architecture
  • Data Marts
  • ODS [Operational Data Store]
  • Dimensional Modelling
  • Difference between relation and dimensional modelling
  • Star Schema and Snowflake Schema
  • What is fact table
  • What is Dimension table
  • Normalization and De-Normalization
Module 2 : ETL Testing
  • ETL architecture.
  • What is ETL and importance of ETL testing
  • How DWH ETL Testing is different from the Application Testing
  • SDLC/STLC in the ETL Projects (ex: V Model, Water fall model)
Module 3 : Challenges in DWH ETL Testing compare to other testing
  • Incompatible and duplicate data
  • Loss of data during ETL process
  • Testers have no privileges to execute ETL jobs by their own
  • Volume and complexity of data is very huge
  • Fault in business process and procedures
  • Trouble acquiring and building test data
Module 4 : ETL Testing Work flow activities involved
  • Analyze and interpret business requirements/ workflows to Create estimations
  • Approve requirements and prepare the Test plan for the system testing
  • Prepare the test cases with the help of design documents provided by the
  • developer team
  • Execute system testing and integration testing
  • Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
  • How to detect the bugs in the ETL testing
  • How to report the bugs in the ETL testing
  • How to co-ordinate with developer team for resolving the defects
Module 5 : Types of ETL Testing
  • Data completeness
  • Data transformation
  • Data quality
  • Performance and scalability
  • Integration testing
  • User-acceptance testing
  • SQL Queries for ETL Testing
  • Incremental load testing
  • Initial Load / Full load testing
Module 6 : Different ETL tools available in the market
  • Informatica
  • Ab Initio
  • IBM Data stage
Module 7 : Power Center Components
  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console
Module 8 : Informatica Concepts and Overview
  • Informatica Architecture
Module 9 : Sources
  • Working with relational Sources
  • Working with Flat Files
Module 10 : Targets
  • Working with Relational Targets
  • Working with Flat file Targets
Module 11 : Transformations – Active and Passive Transformations
  • Expression
  • Lookup –Different types of lookup Caches
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Rank
  • Router
  • Aggregator
  • Source Qualifer
  • Update Strategy
  • Normalizer
  • Union
  • Stored Procedure
  • Slowly Changing Dimension
  • SCD Type1
  • SCD Type2 — Date, Flag and Version
  • SCD Type3
Module 12 : Workflow Manger
  • Creating Reusable tasks
  • Workflows, Worklets & Sessions
  • Tasks
  • Indirect Loading
  • Constraint based load ordering
  • Target Load plan
  • Worklet ,Mapplet ,Resuable transformation
  • Migration ?ML migration and Folder Copy
  • Scheduling Workflow
  • Parameter and variables
  • XML Source, Target and Transformations
Module 13 : Performance Tuning
  • Pipeline Partition
  • Dynamic Partition
  • Pushdown optimization
  • Preparation of Test Cases
  • Executing Test case
  • Preparing Sample data
  • Data validation in Source and target
  • Load and performance testing
  • Unit testing Procedures
  • Error handling procedures
Footer 08