Career Transition
Career Gap
Placement Activities
Placement Drives
Latest Hiring
Whats App Reviews
Course Design By
Nasscom & Wipro
Become an ETL expert. Join now to master the core concepts of ETL.
4.2/5
4.8/5
4.6/5
4.3/5
4.5/5Course Duration
40 Hrs.Live Project
2 ProjectCertification Pass
GuaranteedTraining Format
Live Online /Self-Paced/ClassroomWatch Live Classes
Speciality
300+
Professionals Trained
4+
Batches every month
20+
Countries & Counting
100+
Corporate ServedCURRICULUM & PROJECTS
ETL Certification Training
- DWH: Data Ware Housing Concepts
- ETL Testing
- Challenges in DWH ETL Testing compare to other testing
- ETL Testing flow activities involved
- Type of ETL testing
- Different ETL tools available in the market
- Power Centre Components
- Informatica Concepts and Overview
- Sources
- Targets
- Transformation Active and Passive Transformations
- Slowly changing dimenson
- Workflow manger
- Timer task
- Performing Tuning
Get full course syllabus in your inbox
- What is Data Warehouse
- Need of Data Warehouse.
- Introduction to OLTP, ETL and OLAP Systems
- Difference Between OLTP and OLAP
- Data Warehouse Architecture
- Data Marts
- ODS (Operational Data Store)
- Dimensional Modelling
- Difference Between relation and dimensional modelling
- Star Schema and Snowflake Schema
- What is fact table
- What is the dimensional table
- Normalization and De- Normalization
Get full course syllabus in your inbox
- ETL Architecture.
- What is ETL and importance of ETL testing
- How DWH ETL Testing is different from the Application Testing
- SDLC / STLC in the ETL Project (ex: V Model, Water fall model)
Get full course syllabus in your inbox
- Incompatible and Duplicate Data
- Loss of data during ETL process
- Testers have no privileges to execute ETL jobs by their own.
- Volume and complexity of data is very huge.
- Fault in business process and procedures.
- Trouble acquiring and building test data.
Get full course syllabus in your inbox
- Analyse and interpret business requirements/ workflow to create estimations
- Approve requirements and prepare the test plan documents provided by developer team
- Execute system testing and integration testing
- Best practice to create quality documentations (Test plan, Test Scripts, and Test closure summaries.
- How to detect the bugs in ETL testing
- How to report the bus in ETL testing
- How to co-ordinate with the developer team for resolving the defects
Get full course syllabus in your inbox
- Data completeness
- Data transformation
- Data quality
- Performance and scalability
- Integration testing.
- User acceptance testing.
- SQL Queries for ETL testing
- Increment load testing
- Initial Load/ Full load testing
Get full course syllabus in your inbox
- Informatica
- AB Initio
- IBM Data stage
Get full course syllabus in your inbox
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
- Power centre Admin Console
Get full course syllabus in your inbox
- Informatica Architecture
Get full course syllabus in your inbox
- Working with relational Sources
- Working with flat files.
Get full course syllabus in your inbox
- Working with Relational targets
- Working with flat targets
Get full course syllabus in your inbox
- Expressions
- By Lookup Different types of lookup Cache
- Sequence generator
- Filter
- Joi
- Store procedure
Get full course syllabus in your inbox
- Scd type 1
- Scd type 2
- Date, Flag and version
- Scd type 3
Get full course syllabus in your inbox
- Creating Reusable tasks
- Workflows, Worklets & Sessions
- Tasks
- Session
- Decision Task
- Control task
- Event wait task
Get full course syllabus in your inbox
- Monitoring workflows and debugging errors
- Indirect Loading
- Constraint based load ordering
- Target load plan
- Work let
- Migration ML migration and folder copy
- Scheduling workflow
- Parameter and variables
- XML source target and transformations
Get full course syllabus in your inbox
- Pipeline partition
- Dynamics partition
- Pushdown optimization
- Preparation of test cases
- Executing test case
- Preparing sample data
- Data validation in source and target
- Load and performing testing
- Unit and performance testing
- Unit testing procedure
- Error handling procedure
Get full course syllabus in your inbox
+ More Lessons
Course Design By
Course Offered By
Croma Campus
Real
Stories
success
inspiration
Abhishek
career upgrad
Upasana Singh
career upgrad
Shashank
career upgrad
Abhishek Rawat
career upgrad
Course Duration
40 Hrs.
Weekday1 Hr/Day
Weekend2 Hr/Day
Training ModeClassroom/Online
Flexible Batches For You
05-Jul-2025*
- Weekend
- SAT - SUN
- Mor | Aft | Eve - Slot
07-Jul-2025*
- Weekday
- MON - FRI
- Mor | Aft | Eve - Slot
-
09-Jul-2025*
- Weekday
- MON - FRI
- Mor | Aft | Eve - Slot
-
05-Jul-2025*
- Weekend
- SAT - SUN
- Mor | Aft | Eve - Slot
-
07-Jul-2025*
- Weekday
- MON - FRI
- Mor | Aft | Eve - Slot
-
09-Jul-2025*
- Weekday
- MON - FRI
- Mor | Aft | Eve - Slot
Course Price :
For Indian
16,500
14,850
10 % OFF, Save
1650
Expires in: 00D:00H:00M:00S
Program fees are indicative only* Know more
Expires in: 00D:00H:00M:00S Get exclusive
access to career resources
upon completion
Mock Session
You will get certificate after
completion of program
LMS Learning
You will get certificate after
completion of program
Career Support
You will get certificate after
completion of program
Showcase your Course Completion Certificate to Recruiters
-
Training Certificate is Govern By 12 Global Associations.
-
Training Certificate is Powered by “Wipro DICE ID”
-
Training Certificate is Powered by "Verifiable Skill Credentials"
in Collaboration with
Not Just Studying
We’re Doing Much More!
Empowering Learning Through Real Experiences and Innovation
Mock Interviews
Prepare & Practice for real-life job interviews by joining the Mock Interviews drive at Croma Campus and learn to perform with confidence with our expert team.Not sure of Interview environments? Don’t worry, our team will familiarize you and help you in giving your best shot even under heavy pressures.Our Mock Interviews are conducted by trailblazing industry-experts having years of experience and they will surely help you to improve your chances of getting hired in real.
How Croma Campus Mock Interview Works?
Not just learning –
we train you to get hired.
Phone (For Voice Call):
+91-971 152 6942WhatsApp (For Call & Chat):
+91-971 152 6942Download Curriculum
Get a peek through the entire curriculum designed that ensures Placement Guidance
Course Offered By
Request Your Batch Now
Ready to streamline Your Process? Submit Your batch request today!
+91-971 152 6942
+91-971 152 6942 
+16473706470
+91-971 152 6942
Interested in Course?
Master in Cloud Computing Training