Home
Course
Combo Courses
Data Warehousing and ETL Combo | Combo Course

Data Warehousing and ETL Combo | Combo Course

Have Queries? Ask us

+91-96807-56123

Tecklearn’s Data Warehousing and ETL Combo includes the following Courses: • Informatica Training and Certification • ETL Testing Training This Combo Training Course will help you master Data Integration concepts such as ETL and Data Mining using Informatica PowerCenter and ETL testing, Performance Tuning, cubes etc., through hands-on projects. It will also make you proficient in Advanced Transformations, Informatica Architecture, Data Migration, Performance Tuning, Installation & Configuration of Informatica PowerCenter....

Informatica professionals earn up to $130,000 per year - Indeed.com

GE, eBay, PayPal, FedEx, EMC, Siemens, BNY Mellon & other top Fortune 500 companies use Informatica.

An ETL Developer can earn $100,000 per year – indeed.com

Curriculum

• Informatica & Informatica Product Suite
• Informatica PowerCenter as ETL Tool
• Informatica PowerCenter Architecture
• Component-based development techniques

• Data Integration Concepts
• Data Profile and Data Quality Management
• ETL and ETL architecture
• Brief on Data Warehousing

• Configuring the Informatica tool
• How to install the Informatica operational administration activities and integration services

• Visualize PowerCenter Client Tools
• Data Flow
• Create and Execute Mapping
• Transformations and their usage
• Hands On

• Informatica PowerCenter Workflow Manager
• Reusability and Scheduling in Workflow Manager
• Workflow Task and job handling
• Flow within a Workflow
• Components of Workflow Monitor

• Look Up Transformation
• Active and Passive Transformation
• Joiner Transformation
• Types of Caches
• Hands On

• Load Types – Bulk, Normal
• Reusable and Non-Reusable Sessions
• Categories for Transformation
• Various Types of Transformation – Filter, Expression, Update Strategy, Sorter, Router, XML, HTTP, Transaction Control

• Error Handling and Recovery in Informatica
• High Availability and Failover in Informatica
• Best Practices in Informatica
• Debugger
• Performance Tuning

• Performance Tuning Methodology
• Mapping design tips & tricks
• Caching & Memory Optimization
• Partition & Pushdown Optimization
• Design Principles & Best Practices

• Repository Manager tool (functionalities, create and delete, migrate components)
• PowerCenter Repository Maintenance

• Features of PowerCenter 10
• Overview of the PowerCenter Administration Console
• Integration and repository service properties
• Services in the Administration Console (services, handle locks)
• Users and groups

• Infacmd, infasetup, pmcmd, pmrep
• Automate tasks via command-line programs

• Java Transformation
• HTTP Transformation

• Introduction to ETL testing
• Life cycle of ETL Testing
• Database concepts and ETL in Business Intelligence
• Understanding the difference between OLTP and OLAP and data warehousing

• Introduction to Relational Database Management Systems (RDBMS)
• Concepts of Relational database
• Data warehousing testing Versus database
• Integrity constraints
• Test data warehousing testing
• Hands On

• Data warehouse workflow
• ETL Testing scenarios and ETL Mapping
• Data Warehouse Testing
• Data Mismatch and Data Loss Testing
• Creation of Data warehouse workflow
• Create ETL Mapping
• Hands On

• Introduction to various testing scenarios
• Structure validation and constraint validation
• Data correctness, completeness, quality and Data validation
• Negative testing
• Hands On

• Using SQL for checking data
• Understanding database structure
• Working with SQL Scripts
• Hands On

• Reports and Cube Testing
• Scope of Business Intelligence Testing
• Hands On

Training Option

Self-Paced Learning

₹15,999.00

Learn at your convenient time and pace
Gain on-the-job kind of learning experience through high quality Videos built by industry experts.
Interactive Sessions as good as Classroom experience.
Learn end to end course content that is similar to instructor led virtual/classroom training.
Cost Effective as well as Convenient.

ENROLL NOW

Blended Learning

Everything in Self-Paced Plus
Learn in an instructor-led online training class

Corporate Training

Customized to your team’s needs

Customized learning delivery model (self-paced and/or instructor-led)
Flexible pricing options
Enterprise grade learning management system (LMS)
Enterprise dashboards for individuals and teams
24×7 learner assistance and support

Course Description

Informatica Training and Certification

Tecklearn’s Informatica Training will help you master Data Integration concepts such as ETL and Data Mining using Informatica PowerCenter. It will also make you proficient in Advanced Transformations, Informatica Architecture, Data Migration, Performance Tuning, Installation & Configuration of Informatica PowerCenter. You will get trained in Workflow Informatica, data warehousing, Repository Management and other processes.

What you will Learn in this Course?

Overview of Cloud Computing and AWS
Amazon Elastic Compute Cloud (EC2)
Amazon Storage Services
AWS Database Services
Load Balancing in AWS
Amazon Application Services
AWS IAM
Preparing for the PowerCenter Developer Certification

ETL Testing Training

Today’s businesses have to work with data in multiple formats extracted from multiple sources. All this makes ETL Testing all the more important. Tecklearn’s ETL Testing training offers an in-depth understanding of Data warehousing and business intelligence concepts through real-world examples. You will also gain the essential knowledge of ETL testing, Performance Tuning, cubes, etc., through hands-on projects, and this will help you to become a successful ETL Testing expert.

What you will Learn in this Course?

Introduction to ETL testing
Database Testing and Data Warehousing Testing
ETL Testing Scenarios
Various Testing Scenarios
Data Checks using SQL
Reports & Cube testing
Certification & Projects

Self-Paced Online Video

• Self-paced Videos: 48 Hrs
• Exercises & Project Work: 74 Hrs
• A 360-degree learning approach that you can adapt to your learning style

1 Year Unlimited Access

You get 1 Year unlimited access to LMS where presentations, quizzes, installation guide & class recordings are there.

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket-based tracking system

Certification

Successfully complete your course and Tecklearn will provide you Course Completion Certificate.

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various Informatica and ETL concepts.

Learn at your Convenience

• Certification and Job Assistance
• Flexible Schedule

Reviews

Certification

This course is designed for clearing the following Certifications:

PowerCenter Developer Certification exam

As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly. Tecklearn’s Course Completion Certificate for the courses included in this combo course will be awarded upon the completion of the course.

Projects

To put your knowledge on into action, you will be required to work on various industry-based projects that discuss significant real-time use cases.
These projects are completely in-line with the modules mentioned in the curriculum and help you to clear the certification exam.

Click to Zoom

FAQ Content

You will never miss a lecture at Tecklearn. Tecklearn provides recordings of each class so you can review them as needed before the next session.

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover, the access to our 24x7 support team will be granted instantly as well. You can start learning right away.

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

All the instructors at Tecklearn are practitioners from the Industry with minimum 10-15 years of relevant IT experience. Each of them has gone through a rigorous selection process that includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating remain on our faculty.

Learning pedagogy has evolved with the advent of technology. Online training adds convenience and quality to the training module. With our 24x7 support system, our online learners will have someone to help them all the time even after the class ends. This is one of the driving factors to make sure that people achieve their end learning objective. We also provide life-time access of our updated course material to all our learners.

Tecklearn actively provides placement assistance to all learners who have successfully completed the training. We also help you with the job interview and resume preparation part as well.

56 STUDENTS ENROLLED

Course Curriculum

Reviews

5/5

Tecklearn Apache Storm training will give you a working knowledge of the open-source computational engine, Apache Storm.… View More

Remember me

Forgot your password?

I agree with the Terms

Back to login

Data Warehousing and ETL Combo | Combo Course

Why you take this Combo Training?

Curriculum

Informatica PowerCenter 10 - An Overview

Data Integration and Data Warehousing Fundamentals

Informatica Installation and Configuration

Informatica PowerCenter Transformations

Informatica PowerCenter Tasks & Workflows

Advanced Transformations

More Advanced Transformations – SQL (Pre-SQL and Post-SQL)

Various Types of Transformation - Rank, Union, Stored Procedure

Performance Tuning, Design Principles & Caches

Informatica PowerCenter Repository Management

Informatica Administration & Security

Command Line Utilities

More Advanced Transformations – XML

Introduction to ETL testing

Database Testing and Data Warehousing Testing

ETL Testing Scenarios

Various Testing Scenarios

Data Checks using SQL

Reports & Cube testing

Training Option

Self-Paced Learning

₹21,499.00 ₹15,999.00

Blended Learning

Corporate Training

Course Description

Informatica Training and Certification

ETL Testing Training

Key Features

Self-Paced Online Video

1 Year Unlimited Access

24 x 7 Expert Support

Certification

Real-life Case Studies

Learn at your Convenience

Reviews

Certification

FAQ Content

What if I miss a class?

What if I have queries after I complete this course?

How soon after Signing up would I get access to the Learning Content?

Is the course material accessible to the students even after the course training is over?

Who are our instructors and how they are selected?

Why should this course online? How is it better than offline training?

Does Tecklearn offer job assistance?

Course Curriculum

Related Courses

₹63,995.00 ₹44,500.00

₹172,886.00 ₹99,000.00

₹36,997.00 ₹29,900.00

₹78,895.00 ₹44,500.00

₹69,995.00 ₹49,900.00

₹103,891.00 ₹49,900.00

₹102,889.00 ₹44,900.00

₹81,990.00 ₹44,900.00

₹44,397.00 ₹29,900.00

₹43,895.00 ₹39,900.00

TRENDING COURSES

₹17,999.00 ₹12,999.00

₹17,999.00 ₹12,999.00

₹17,999.00 ₹12,999.00

₹12,999.00 ₹7,999.00

₹17,999.00 ₹12,999.00

₹12,999.00 ₹7,999.00

₹17,999.00 ₹12,999.00

₹12,999.00 ₹7,999.00

₹18,999.00 ₹13,999.00

₹10,999.00 ₹5,999.00

Contact Us

Contact Us

Thank you

₹15,999.00

₹44,500.00

₹99,000.00

₹29,900.00

₹44,500.00

₹49,900.00

₹49,900.00

₹44,900.00

₹44,900.00

₹29,900.00

₹39,900.00

₹12,999.00

₹12,999.00

₹12,999.00

₹7,999.00

₹12,999.00

₹7,999.00

₹12,999.00

₹7,999.00

₹13,999.00

₹5,999.00