Data Warehousing and ETL Combo | Combo Course

Have Queries? Ask us


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....

Read More

Why you take this Combo Training?

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

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

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


• 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


  • 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.

Blended Learning

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

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
Contact Us

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
  • 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

Key Features

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


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



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.


  • 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.

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.
  • 15,999.00
  • 10 years, 1 month
  • 500 SEATS
  • Course Certificate

Course Curriculum

No curriculum found !

Related Courses


Contact Us

    Contact Us