Informatica Training In Miyapur From HTS

About The Course

Harshitha Technologies Solutions's Informatica Power Center 9.X Developer & Admin Course, will introduce the participants to work with the PowerCenter. Developers can use Informatica to create, execute, as well as administer, monitor and schedule ETL processes and understand how these are used in data mining operations. The course will also cover Installation & Configuration of Informatica PowerCenter 9.X and basic Administration Activities. Participants will also get to implement one project towards the end of the course.

Course Objectives

After the completion of the Informatica course at HTS, you will be able to : 

1. Understand and identify different Informatica Products 

2. Describe Informatica PowerCenter architecture & its different components

3. Use Power Center 9.x components to build Mappings, Tasks, Workflows

4. Describe the basic and advanced features functionalities of PowerCenter 9.X transformations

5. Understand Workflow Task and job handling

6. Describe Mapping Parameter and Variables

7. Perform debugging, troubleshooting, error handling and recovery

8. Learn to calculate cache requirement and implement session cache

9. Execute performance tuning and Optimization

10. Recognize and explain the functionalities of the Repository Manager tool.

11. Identify how to handle services in the Administration Console

12. Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation

13. Gain insight on ETL best practices using Informatica

Who should go for this course?

The following professionals can go for this course :

1. Software Developers

2. Analytics Professionals 

3. BI/ETL/DW Professionals

4. Mainframe developers and Architects

5. Individual Contributors in the field of Enterprise Business Intelligence

Pre-requisites

The pre-requisites for this course include knowledge of SQL and basic Unix.

Project Work

Towards the end of the Course, you will be working on a live project to perform data analytics.

Project #1 : Creation of Sales Data Warehouse 

Industry : Retail 

Data : NorthWind/AdventureWorks dataset. 

Problem Statement : Creation of ETL jobs to build Sales Data Mart using Informatica. 

Project #2 : Transaction Analysis for Retail

Industry : Retail 

Data : Sales data from Real time retail project. ( Data will be masked) 

Problem Statement : Analyzing Retail Transaction Information using Informatica.

Why learn Informatica?

Informatica provides the market's leading data integration platform. Tested on nearly 500,000 combinations of platforms and applications, the data integration platform inter operates with the broadest possible range of disparate standards, systems, and applications. This unbiased and universal view makes Informatica unique in today's market as a leader in the data integration platform. It also makes Informatica the ideal strategic platform for companies looking to solve data integration issues of any size.

And many sub topics are there for more details please go through the website.

Please call us for the Demo Classes we have regular batches and weekend batches.

Contact Number: USA: +1-6109903968, INDIA: +91 9989630313,

Email: mhtspvtltd@gmail.com

Web: http://www.harshithatechnology.com