ETL COURSE:
Prerequisites required to learn Informatica Train
- Basic Knowledge of Software Testing
- Basic Knowledge of SDLC.
- Basic knowledge of database
Course Covers Following Concept:
- Database and SQL
- Advanced SQL
- Data warehouse Concepts
- Informatica Power Center Too
- ETL Architecture
- Types of ETL Testing
- ETL Testing
- Informatica Transformation and itâ??s Testing
- Test Plan, Test Cases
- Understating and Analyzing Requirements and Data Mappings.
- Test Management using QC/HP-ALM Tool.
- Basics of UNIX.
- Flat Files Testing.
- Hands on practice on a Project
- Interview Preparation
- Resume building
Highlights:-
- Training by Real Time Industry Experienced Professional.
- Real Time case studies and examples for better understanding.
- Projects will be assigned to work for self-practice.
- Emphasis on Real Time Business Scenarios.
- Mock Interviews.
- Discussion of Interview Questions.
- Weekend Batches.
ETL and BI Report Testing Contents:
- Advanced SQL & PL/SQL
- DW Basics
- Informatica ETL Tool Basics
- Informatica Transformation
- ETL Testing Techniques
- Different types of Testing
- Flat File Validation
- Facts and Dimensions Validations
- BI report Testing using Tableau
- HP ALM Test Management Tool
- Agile Process
- Sample Projects and Assignment
- UNIX Basics
Along with these topics we are going to give a two real time hands on project.
Mock interviews/mock test will be conducting.
Highlighting the interview questions and topics in the class.