Informatica and ETL Testing

About Informatica and ETL Testing

Informatica is a powerful data integration tool used to design, build, and manage ETL (Extract, Transform, Load) processes. It helps organizations move and transform data from various sources into target systems like data warehouses efficiently and securely.

ETL Testing involves validating the ETL process to ensure that data is correctly extracted from source systems, accurately transformed as per business rules, and properly loaded into the target database. ETL testing in Informatica includes checking data completeness, data accuracy, performance, and data integrity to ensure the quality and reliability of the data used for reporting and analytics.

Informatica and ETL Duration:    2 Months

Fees:    15,000 (Includes Informatica + ETL Testing)

Informatica and etl testing course contents

INTRODUCTION OF ETL TESTING

ETL Testing Project Architecture What is ETL Testing?

What is Data Warehouse? ETL Testing tools

ETL Process

What is the difference between ETL testing and GUI testing? ETL Testing Process

What is the difference DB Testing and ETL Testing? ETL testing challenges

Why we need Data warehouse? ETL Testing projects Advantages of ETL Testing

Data moving different stages in DWH

DATAWARE HOUSING CONCEPTS

  • Whatis Data Ware House?
  • Differencebetween OLTP and OLAP
  • DWHFathers
  • RalphKimball
  • WH Inman (characteristic) a)integrated
  1. Non-volatile
  2. Timevariant
  3. Subjectoriented

 

Data Acquisition

  • DataExtraction
  • DataTransformation
  • DataLoading

 

Data Marts

  • DependentData Mart
  • Independent Data Mart Data Modeling
  • Whatis a Dimension Table
  • Whatis a Fact table
  • ConfirmedDimension Table
  • Factless Fact Table Data Base Design
  • StarSchema
  • SnowFlake Schema
  • Factconstellation Schema
  • IntegratedSchema

 

SCD (slowly changing dimension)

  • Type-1SCD  Type-2 SCD
  • Type-3SCD
  • MinusQueries  Count Queries

 

STRUCTURE QUERY LANGUAGE (SQL)

Introduction to RDBMS

  • What is Data Base
  • Importance of Data Base
  • WorkingRDBMS
  • Why is Data Base need in Industries
  • Whatisthe use of Data Engineering in DB Sub Language Commands
  • DataDefinitionLanguage (DDL)
  • Data Retrieval Language (DRL)
  • Data Manipulation Language (DML)
  • TransactionControlLanguage (TCL)
  • Database Security and Privileges (DCL)
  • OraclePreDefined Datatypes
  • DDLCommands
  • Create,Alter(add, modify, rename, drop) Columns, Rename, truncate, drop
  • DML- Insert, update, delete
  • DQL-SELECTStatements usingWHERE clause
  • Comparison and Conditional Operators
  • Arithmetic and Logical Operators
  • Special Operators – IN (NOTIN), BETWEEN (NOTBETWEEN),
  • LIKE (NOTLIKE), IS NULL(IS NOT NULL)
  • Transactionalcommands
  • Rollback
  • Commit
  • Save Point
  • Workingwithjoins
  • innerjoin
  • outerjoin
  • crossjoin
  • full join
  • WorkingwithSubquery
  • Single-rowsubquery
  • Multiplerowsubquery
  • Correlatedsubquery
  • Nested subquery

 

ETL TOOL (INFORMATICA)

  1. InformaticaConcept
  • Introductionto INFORMATICA
  • ETLprocess in Informatica
  • ETLnaming conventions of different vendors
  • InformaticaProducts (Power Center and Powermart)
  • InformaticaSoftwares (Server and Client)
  • InformaticaComponents and sub-components (Server and Client)
  • ETLImplementation Tasks in Informatica
  • InformaticaArchitecture

 

  1. InformaticaTransformations
  • SourceQualifier
  • Filter
  • Expression
  • Sorter
  • Aggregator
  • SequenceGenerator
  • Rank
  • Router
  • Union
  • Joiner
  • Lookup
  • StoredProcedure
  • UpdateStrategy
  • TransactionControl Transformation
  • Normalizer
  • XmlSource Qualifier

 

  1. InformaticaAdvanced Concepts
  • ImplementingConstraint Based Load Ordering
  • ImplementingTarget Load Plan
  • Creatingand Implementing Unconnected Lookup
  • Creatingand Implementing Unconnected Stored Procedure
  • DebuggingMapping (Before creation of session and After creation Session)
  • Creatingand Implementing Reusable Transformation
  • Creatingand Implementing Mapplet
  • Definingand Using Mapping Parameter
  • Definingand Using Mapping Variable
  • Reusableand Non-Reusable Sessions
  • ImplementingPre SQL and Post SQL
  • Activeand Passive Transformations
  • Executingworkflow by using pmcmd command
  • Schedulingworkflow
  • SlowlyChanging Dimensions by wizards (SCD-TYPE1, SCD-TYPE2, SCDTYPE3 )
  • Creatingand Implementing Worklet

 

 MANUAL TESTING

  1. SoftwareTesting Tools
  • Introduction
  • Introductionto Software Testing
  • SoftwareDevelopment Process
  • ProjectVs Product
  • Objectivesof Testing
  • TestingPrincipals
  • SoftwareDevelopment Life Cycle
  • SDLC
  • SDLCModels
  • WaterfallModel
  • SpiralModel
  • VModel
  • AgileModel (Scrum)
  • Howto Choose Model for a Project
  • SoftwareTesting-Methods
  • WhiteBox Testing
  • BlockBox Testing
  • GrayBox Testing
  • Levelsof Testing
  • UnitTesting
    1. UserAcceptance Testing
      • AlphaTesting
      • BetaTesting
    2. TestingTerminology
      • FunctionalTesting
  • End-EndTesting
  • Ad-hocTesting
  • RiskBased Testing
  • Sanity/SmokeTesting
  • Re-Testing
  • RegressionTesting
  • ExploratoryTesting
  • BoundaryValue Analysis
    1. TestCase Authoring
  • FunctionalTest Case
  • ReviewTest Case
  • Walkthroughs
  • Inspection
  • PeerReview
  • TraceabilityMatrix

 

ETL TESTING

  1. Introduction
  • Whatis use of testing
  • Whatis quality & standards
  • Responsibilitiesof a ETL Tester
    1. ETLSoftware development life cycle
  • Waterfallmodel
  • V-model
  • Agilemodel & methodology
    1. Testingmethodologies
  • Whitebox testing
  • Blackbox testing
  • Greybox testing
  • MinusQueries
  • CountQueries
  • ETLTesting Work Flow Process
  • Responsibilitiesof ETL Testing
  • Typesof ETL Testing(16Types)
  • DifferentTypes of Testing Techniques in ETL
  • Howto validate data form source to target
  • Howto prepare ETL check list
  • Howto Prepare the ETL Test Plan
  • Howto design the ETL Test cases and execute test case
  • Howto reporting the Bugs in ETL Testing
  • ETLTesting Responsibilities in DataStage, Informatica, Abinitio etc;
  • Howto detect the bugs through database queries
  • ETLPerforming Testing & Performing Tuning

PROJECT ESSENTIAL

  • ProjectDescription
  • Rolesand Responsibilities
  • ProjectArchitecture
  • StaticTest Plan
  • CheckList
  • TestScenarios & Test Case Preparation
  • TraceabilityMatrix
  • Bug& Regression
  • Endto End Flow
  • StatusReport
  • MappingReport

 

AGILE METHOLOGY

  1. AgileMethodology Concepts
  • Whatis Agile?
  • WhyAgile is so popular?
  • Whento go for Agile?
  • AgileMethodology Principles
  • Comparisonof traditional models with Agile
  • Benefitsof Agile Methodology
  • Drawbacksof Agile Methodology
  • AgileMethodology Frameworks
    • Introduction to Scrum Framework What is Scrum?
  • Componentsof Scrum Framework
  • ScrumRoles
  • ScrumArtifacts
  • ScrumEvents
  • ScrumRoles and Responsibilities
  • ProductOwner
  • ScrumMaster
  • ScrumDevelopment Team
  • ScrumArtifacts
  • ProductBacklog
  • SprintBacklog
  • BurndownChart
  • ScrumEvents
  • SprintPlanning Meeting
  • DailyScrum Meeting
  • SprintRetrospective Meeting
  • Toolsusage in Agile
  • ProductBacklog Template

WHAT IS JIRA SOFTWARE?

  • Howto use it?
  • Createaccount
  • Loginaccount
  • CreateProject
  • Inviteuser to project
  • Createbug/task/story
  • Assigntasks to others
    • Movetickets from one place to other place
  • CreateSprint and start it
  • CompleteSprint
  • Whatis the backlog and how to use it?

 

1 UNIX LINUX COURSE OVERVIEW

1.1 Unix Course Prerequisite

1.2 Unix / Linux Training Course Objective

1.3 Unix / Linux Training Course Duration

2 UNIX TRAINING CONTENT

2.1 UNIX File System Architecture

2.2 File System of UNIX

2.3 Different UNIX Commands

2.4 Links

2.5 Complex Filters

2.6 Working with Files

2.7 Working with Directories

2.8 Displaying Files

2.9 Simple Filters

  • ZipFiles
  • PrintingFiles
  • FindingFiles
  • Inputand Output Redirection
  • ShellMeta Characters
  • MoreFilters
  • RegularExpressions and Patterns
  • HowC programs are useful for solving problems in UNIX
  • UNIXCommands
  • BackupUtilities
  • Piping
  • FilePermissions
  • CommunicationCommands
  • Networkingcommands
  • DiskUtilities
  • JobControl
  • PrcoessStatus
  • Jobscheduling
  • ed,ex and vi editors
  • ShellScripting
  • ShellInput and Output
  • Backslashcharacter constants aliases and History concept variables
  • Operators
  • FlowControl Structure
  • Looping
  • FormattedI/O
  • Namespacesin UNIX
  • Introductionto Message Queues
  • Introductionto Different Types of System Calls
  • ProgrammingAspects of Berkeley Sockets & Reserved Ports
  • UNIXDomain Protocol
  • Socket Addresses

As a part of ETL Testing Training, you will be exposed to real-life industry scenarios which give you in-depth understanding of Data warehousing and concepts of business intelligence. ETL testing course will help you to become a successful ETL Testing expert.

For Reading Material? Click here

Master Data Integration with Informatica at Learn Tech Masters

Learn Tech Masters offers specialized training in Informatica, a leading data integration and ETL tool used by top enterprises worldwide. Our course covers real-time data extraction, transformation, and loading techniques, along with hands-on ETL testing practices. Gain the skills to manage complex data workflows and ensure data quality in modern data-driven environments.