Advanced ETL Testing Training
H2K Infosys offers Advanced ETL Testing online training with real time examples. Advanced ETL Testing concepts have designed by professionals according to current job market.
About Advanced ETL Testing Training Course
Major Highlights Advanced ETL Testing course are:-
- More hands-on exercise for students so that they can gain expertise in Building Test case, Executing them and preparing Test Plan.
- More scenario questions will be discussed in terms of specific problems encountered while working in actual data-warehousing project.
- SQL being one of the most important topic will be covered in greater details.
- Complete Hands-On on Advanced level SQL knowledge involving complex SQL queries.
- Advanced level knowledge on ETL tools specifically Informatica in terms of their detailed features.
- Details on various transformations used in Informatica and how we can build and implement ETL logic.
Advanced ETL Testing Training Course Syllabus
- DWH Concepts
- SDLC of ETL Projects
- Phase 1 - Test Case Generation
- Phase 2 - Test Case Execution
- Validation of LDM,PDM (Logical Data Model,Physical Data Model)
- Validation of Source to Target Mapping document
- Assessment of source data quality
- Schema Validation.
- ETL Transformation rules validation.
- Informatica PowerCenter Client
- SAMPLE Loading from source to target
- SORTER Transformation
- FILTER Transformation
- ROUTER Transformation
- EXPRESSION Transformation
- Lookup Transformation
- Talend Overview
- Talend Components
- Talend Admin Console
- Big Data and Cloud Components
- Teradata Features
- Teradata Utilities Overview
- Teradata SQL
- Teradata OLAP Functions
- Dashboard Creation
- Report Testing
- Deployment Group Creation
- How to migrate and test ETL codes across different environments
- Test Exit Report
- How to prepare DSR
- How to log defects in QC
- How to test unstructured data using PIG,Hive
Extensive Hands-on with real project examples on all above modules
Interview questions not provied yet
Please fill the contact form, we can email you the details