Menu
or
All Courses
INR USD

Informatica

Informatica PowerCenter is a widely used extraction, transformation and loading (ETL) tool used in building enterprise data warehouses. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse.

Why this course ?

Being a highly important function in database management, ETL is achieved by using different tools and programs. The most advanced and used data integration/ETL tool is Informatica. Whereas Informatica is an ETL tool, used for loading data and export functions

Course Features

  • Instructor Live Sessions

    30hrs of Online Live Instructor-led Classes. Weekend class:10 sessions of 3 hours each and Weekday class:15 sessions of 2 hours each.
  • Real-life Case Studies

    Live project based on any of the selected use cases on the above selected Domain.
  • Assignments

    Each class will be followed by practical assignments which can be completed before the next class.
  • Lifetime Access

    You get lifetime access to the Learning Management System (LMS). Class recordings and presentations can be viewed online from the LMS.
  • 24 x 7 Expert Support

    We have 24x7 online support team available to help you with any technical queries you may have during the course.
  • Certification

    Towards the end of the course, you will be working on a project. Covalent certifies you as an course Expert based on the project.

Course Curriculum

Download
  • Informatica course content

    Inforamtica Power Center Course Objective 

    • Purpose ETL Tool
    • About Informatica
    • Informatica Architecture
    • Informatica Components
    • Power Center Client Tools
    • Informatica Connectivity
    • Project Life Cycle
    • Informatica Transformations Overview 

     

    Inforamtica Architecture 

    • ETL Process
    • Sources Overview
    • Target Overview
    • Power Center Domain
    • Power center services
    • Repository Service
    • Integration Service
    • Inforamtica Server and Data movement
    • Power Center connectivity 

     

    Informatica Components 

    • Power Center Designer
    • Power Center Workflow Manager
    • Power Center Workflow Monitor
    • Power Center Repository Manager 

     

    Power Center Repository Manager 

    • Configuration Repository
    • Export/Import Mapping/Workflow 

     

    Power Center Power Center Designer 

    • Source Analyzer
    • Target Designer
    • Transformation Developer
    • Mapplet Designer
    • Mapping Designer 

     

    Power Center Workflow Manager 

    • Task Developer
    • Worklet Designer
    • Workflow Designer 

     

    Power Center Workflow Monitor 

    • Gantt Chart View
    • Tasks View
    • View Workflow & Session Logs
    • Stop / Abort, Restart a workflow/task
    • Schedule /Unschedule the workflow 

     

    Transformation

    • Type of transformation
    • Transformation properties
    • Different type of transformation
    1. Expression
    2. Aggregator
    3. Filter
    4. Router
    5. Sorter
    6. Sequence Generator
    7. Source Qualifier
    8. Rank
    9. Joiner
    10. Lookup
    11. Union
    12. Update strategy
    13. Normalizer 

    Workflow Task 

    1. Session
    2. Email
    3. Command
    4. Event Wait
    5. Event Raise
    6. Timer
    7. Decision 

     

    PLC (Project Life Cycle)

    1. High Level Design phase
    2. Low Level Design phase
    3. Technical Documentation phase
    • Functional Document
    • Technical Document
    1. Development phase
    2. Unit Testing Phase
    3. SIT Phase -System Integration testing
    4. UAT phase -  User Acceptance test
    5. Production
    6. Support 

Projects

  • Informatica Project

    we are giving Real time case studies for generating reports.

     

FAQ's

  • Can I attend a demo session before enrolment?

    Yes

  • What if I miss a class ?

    If you miss a class we can provide recording video for particular session and same session you have to attend another batch also.

  • Will I get placement Assistance ?

    Yes

  • Do I receive a certificate for training ?

    • Once you are successfully through the course you will be awarded with Covalent's Training certificate.
    • Covalent certification has industry recognition and we are the preferred training partner for many MNCs.
  • what support is available after the training?

    Doubts clarification up to getting a job

    Resume preparation

    Mock interviews

    Placement Assistance

  • What Features do you provide?

    • Led sessions with corporate trainers
    • Course Material
    • Real time projects with industry experts
    • Day wise Assignments (Tasks)
    • Lab facilities
    • Placement assistance
    • Resume preparation
    • Software installation
    • Doubts  clarifications

Certifications

  • Course Completion Certificate

    • Once you are successfully through the course you will be awarded with Covalent's Training certificate.
    • Covalent certification has industry recognition and we are the preferred training partner for many MNCs.

Videos

Informatica Videos are under construction

Reviews

Sunil Kumar Reddy E

Assistant System Engineer

There is just one word for covalent and that is Fantastic!! The support team is superb. They help with all types of problem that you are facing. I had ... opted for Informatica course and to tell you the faculties were well experienced and the learning curve was really high. covalent deserves a 5 star atleast from my side.

readmore...

Narendra

Software Developer-Informatica

the work culture at Informatica is probably one of the best one will get, But having said this it should be more aggressive as a technology firm to win the battles in the market. So This technology Covalent should teach perfect way with Real time case studies. Through covalent support i got a job in MNC company.

readmore...

Enroll Now

© 2018 Covalent Technologies All rights reserved

Drop us a Query

Drop us a Query

Call us on

IN: 91-9848733309
IN: +91-9676828080