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.

Why H2K Infosys?

  • [Image: Oriented Training]

    100% job oriented training

  • [Image: Live Training]

    Instructor-led face-to-face live training

  • [Image: Latest Technologies]

    Huge course syllabus on latest technologies

  • [Image: Real Time

    Real-time projects to gain hands-on experience

  • [Image: Cloud Test]

    Cloud Test Lab to practice on software tools and projects

  • [Image: Recorded Class]

    Lifetime access to recorded class videos

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
    • Triggers
    • Jobs
    • SubJobs
    • 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

Interview questions not provied yet

Sample Resumes

Please fill the contact form, we can email you the details

Advanced ETL Testing Training Ratings



Santosh is excellent instructor.I am taking ETL Testing from him.He explains concepts in a very easy to understand way by giving examples.He clears doubt with patience.I like his way of teaching.Thank you Santosh. Read more

I have attended ETL basics classes by Santosh. He is an excellent teacher and has a good command on the subject loved the way he taught especially the presentation skills. Read more

[Image: Mobile-Number]
H2K Infosys - IT Training & Placement Assistance
Rated 4.8/5 based on 198 customer reviews

Request a Demo

I agree to the H2KInfosys T&C