Informatica Certification Training Course
Access Duration - 365 Days
4.3( 3 REVIEWS )
155 STUDENTS
What Will I Learn?
Gain in-depth knowledge of the Informatica PowerCenter, its Architecture, and Environment
Comprehensive knowledge of various tools like Informatica Administrator Suite, Repository Manager, Designer and Workflow Manager
Capability to load Dimension Tables, use Advanced Transformation, recognize and repair Connection & Network Errors, configure Workflows & Sessions, create Users and Group and design Error Handling strategies
Gain hands-on knowledge of Informatica PowerCenter command line tools
Learn industry standards and best practices
Overview
Informatica is one of the most widely used data integration platforms in the world. It combines advanced hybrid integration capabilities and centralized governance with self-service business access for a variety of analytic functions. Informatica PowerCenter is a metadata-driven integration tool that accelerates projects in order to deliver data to the business more quickly than manual hand-coding. It also allows developers and analysts to collaborate, prototype, analyse, and deploy projects.
This Informatica Certification course offers you an overview of the product and installation of Informatica PowerCenter, data integration principles and data warehousing. You will know how different PowerCenter creation units can be used to construct a basic mapping. The Informatica Certification Course introduces you to advanced transformation strategies and ETL scenarios. You will also learn the features provided by Informatica to debug, troubleshoot ,handle errors and learn the best practices for optimum performance of your ETL process and to manage the repository effectively.
Why You Should Consider Taking this Course at Global Edulink?
Global Edulink is a leading online provider for several accrediting bodies, and provides learners the opportunity to take this exclusive course awarded by CPD. At Global Edulink, we give our fullest attention to our learners’ needs and ensure they have the necessary information required to proceed with the Course. Learners who register will be given excellent support, discounts for future purchases and be eligible for a TOTUM Discount card and Student ID card with amazing offers and access to retail stores, the library, cinemas, gym memberships and their favourite restaurants.
- Access Duration
- Who is this Course for?
- Entry Requirement
- Method of Assessment
- Certification
- Awarding Body
- Career Path & Progression
The course will be delivered directly to you, and from the date you joined the course you have 12 months of access to the online learning platform. The course is self-paced, and you can complete it in stages at any time.
- Data Integration developers
- Informatica PowerCenter Administrators
- BI/ETL/DW Professionals
- Informatica Administrators with some considerable experience in using PowerCenter or maintaining Data Quality
- Individual Contributors in the field of Enterprise Business Intelligence
- Learners should be over the age of 16, and have a basic understanding of English, ICT and numeracy.
- A sound educational background
In order to complete the course successfully, learners will take an online assessment. This online test is marked automatically, so you will receive an instant grade and know whether you have passed the course.
Upon the successful completion of the course, you will be awarded the ‘Informatica Certification Training Course’ by CPD.
CPD is an internationally recognised qualification that will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in an enterprise.
Once you successfully complete the course, you will gain an accredited qualification that will prove your skills and expertise in the subject matter. With this qualification you can further expand your knowledge by studying related courses on this subject, or you can go onto get a promotion or salary increment in your current job role. Below given are few of the jobs this certificate will help you in, along with the average UK salary per annum according to http://payscale.com/
- Database developer – Up to £69k per annum
- Administrator – Up to £68k per annum
- Data Integration developer – Up to £79k per annum
Key Features
Gain an Accredited UK Qualification
Access to Excellent Quality Study Materials
Personalised Learning Experience
Support by Phone, Live Chat, and Email
Eligible for TOTUM Discount Card
UK Register of Learning Providers Reg No : 10053842Course Curriculum
| 1: Informatica PowerCenter 10 - An Overview | |||
| Informatica & Informatica Product Suite | |||
| Informatica PowerCenter as ETL Tool | |||
| Informatica PowerCenter Architecture | |||
| Component-based development techniques | |||
| 2: Data Integration and Data Warehousing Fundamentals | |||
| Data Integration Concepts | |||
| Data Profile and Data Quality Management | |||
| ETL and ETL architecture | |||
| Brief on Data Warehousing | |||
| 3: Informatica PowerCenter Transformations | |||
| Visualize PowerCenter client tools | |||
| Data Flow | |||
| Create & execute mapping | |||
| Transformations & their usage | |||
| 4: Informatica PowerCenter Tasks & Workflows | |||
| PowerCenter Workflow Manager | |||
| Flow within a Workflow | |||
| Reusability & Scheduling in Workflow Manager | |||
| Components of Workflow Monitor | |||
| Workflow Task and job handling | |||
| 5: Advanced Transformations, Techniques & Reusability Features | |||
| Advanced transformations (Java, SQL, Normalizer) | |||
| XML File Processing & Transaction Processing | |||
| Error handling features | |||
| Cleaning the data (Advanced Functions, Regular Expressions) | |||
| Reusability features | |||
| 6: ETL Scenarios using Informatica | |||
| Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc. | |||
| Advanced techniques – Flat File, XML File | |||
| Loading Dimensional Tables (SCD-1, SCD-2, SCD-3) | |||
| 7: Service & Support of Informatica PowerCenter Environment | |||
| Power Center Error | |||
| Basic troubleshooting methodology | |||
| Debugger | |||
| Workflow and Session logs to diagnose errors | |||
| Connection Errors & Network errors | |||
| Recovery scenarios & mechanisms | |||
| Configure workflow & sessions for recovery | |||
| High Availability | |||
| Power Center Environment | |||
| 8: Performance Tuning, Design Principles & Caches | |||
| Performance Tuning Methodology | |||
| Mapping design tips & tricks | |||
| Caching & Memory Optimization | |||
| Partition & Pushdown Optimization | |||
| Design Principles & Best Practices | |||
| 9: Informatica PowerCenter Repository Management | |||
| Repository Manager tool (functionalities, create and delete, migrate components) | |||
| PowerCenter Repository Maintenance | |||
| 10: Informatica Administration & Security | |||
| Features of Power Center 10 | |||
| Overview of the Power Center Administration Console | |||
| Integration and repository service properties | |||
| Services in the Administration Console (services, handle locks) | |||
| Users and groups | |||
| 11: Command Line Utilities | |||
| Infacmd, infasetup, pmcmd, pmrep | |||
| Automate tasks via command-line programs | |||
| 12: Informatica 10 - Technical Architecture | |||
| Informatica 10 Architecture | |||
| Application services | |||
| Buffer memory | |||
| Connectivity among the tolls | |||
| Connection Pooling | |||
Skye Houghton
This was a very professional course and I learned a lot. Content is great and are easily understandable with the examples
Jesse Turner
This course is very good to start for anyone interested in Informatica. Good use of Example and best practices.
Harley Barnes
The course gave me a good understanding of Informatica. Thank you! I would encourage to provide more videos like these.