ETL Testing Training in Chennai
- Expert Designed ETL Testing Training Course Content
- No.1 among all the other ETL Testing Training Centres in Chennai
- One and only institute for all kind of ETL Testing Tool Training in Chennai
- ETL Testing Online Training in Chennai also available
- Ranked the BEST ETL Testing Training Institute in Chennai
- Intellectual and Real Time Training in Chennai
- Job based ETL Testing Training with Placement assistance
Course Features
- Duration60 hours
- Skill levelAll level
- Batch Strength15
- AssessmentsYes
- Mock InterviewsYes
- Resume BuildingYes
- PlacementsYes
- Flexible TimingYes
- Fee InstallmentsYes
- LanguageTamil/English
- What is Data warehousing?
- Why Data warehousing?
- Purpose of Data warehousing?
- Architecture of Data warehousing?
- Overview of OLTP, ETL and OLAP Systems
- Data marts Introduction
- Operational Data Store – Overview
- What is Dimensional modelling?
- Difference between relational and dimensional modelling
- Star schema, snowflake schema and fact constellations schema – Overview
- Fact and Dimensional tables
- What is Normalization and De-Normalization
- Types of SCD
- Overview of ETL Architecture
- What is ETL?
- Importance of ETL testing?
- Differences between ETL testing and manual, automation testing
- SDLC / STLC
- Exploring the following Challenges in DWH testing compared to other testing
- Deduct Incompatible and duplicate data
- Handling Loss of Data during ETL process
- Finding the Volume and Complexity of data
- Workflow activities of ETL testing
- Analyze and explore business requirements.
- Create workflow for estimations
- How to prepare the test cases with the help of design documents which is provided by the development team.
- Evaluate system testing and integration testing
- Find / report bugs in ETL testing
- Types of ETL testing
- Data Completeness
- Data Transformations
- Data Quality
- Performance and Scalability Testing
- Integration testing
- SQL Queries for perform ETL testing
- Incremental load testing
- Initial load testing
- Full load testing
- What are the different tools available in the market?
- Overview of Informatica, Abinitio, Datastage
- List of Power center components
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
- How to Mapping document?
- How to prepare test cases?
- How to execute test cases?
- Overview of Mapplet, Worklet
- What is Regression Testing
- How to prepare Test Case template?
- Introduction of SQL
- Structure of SQL
- Select, Insert, Update, Delete, drop, truncate, filter, alter, Where, Group By, between, IN, having, order by commands.
- Perform Arithmetic, comparison, logical and Range operators
- How to use “IN / NOT IN, Set” Operators?
- What is Union, Union all, Intersect?
- List of Join queries available in SQL
- Simple Join
- Equi join
- Self Join
- Inner Join
- Outer Join
- Left outer Join
- Right Outer Join
- Full Outer Join
- Subqueries
- Nested Subqueries
- Constraints & Aggregate functions
- Rank and Dense Rank
You will be going through detailed 2 to 3 months of ETL Hands-on training
- Detailed instructor led sessions to help you become a proficient Expert in ETL Testing.
- Build a ETL Testing professional portfolio by working on hands on assignments and projects.
- Personalised mentorship from professionals working in leading companies.
- Lifetime access to downloadable ETL Testing course materials, interview questions and project resources.
Credo Systemz - Velachery, Chennai
Call Us +91 9884412301
Credo Systemz - OMR, Chennai
Call Us +91 9600112302
Credo systemz is the evergreen institute in Chennai for testing especially trainer teaching is excellent on etl testing. No other institute competitive to Credo systemz training institute. I feel that it is a real time institute to learn. He will take care about each student and he is asking daily questions.. It`s very helpful to me and he gave a good confidence to get job. It`s a full worth for what I paid.
I am very much thankful to Credo Systemz for providing the best ETL Testing Training in Chennai. My trainer gave a clear idea about working in ETL testing from the very beginner leave to the latest real time topics. Detailed explanations provided for all the topics without any hurry. He'll move to the new topic once we are clear about the previous one. Wonderful Training, Interview focused assessments & assignments were given. Thank You for all the support.
Hello, friends, I'm Saradha having experience in Manual testing for I like to learn ETL Testing for my career enhancement. Had a free demo session with the trainer directly and discussed with him about my requirements, He gave a clear idea about the session. Joined there had a real time experience of working on a project. Thank You trainer and Credo Systemz
Came to know about through Google. As I'm looking for my ETL Certification training, The course content they provided looks unique while comparing others, started from basics to advanced topics. Atonce booked my seat for next batch with offers. Really had an interesting session, Trainer made the session very simple and easy to understand, special thanks for him. Flexible Timing, Friendly environment. Looking for Software training then Credo Systemz is the best.
