Informatica Certification Training

An industry-oriented course designed by experts. Master Informatica from basics to advance with this course filled with real-world projects, assignments, and hands-on.

Watch
INTRO VIDEO

Duration
5 Weeks

Start Date
2nd Oct, 2022

Format
Online

EMI Options
No interest EMI

Program Overviews

Key Highlights 
  • 36+ Hours of interactive learning
  • 30+ Hours of exercise and project work
  • 5+ Projects, hands-on, and case studies
  • Attend as many batches for lifetime
  • Lifetime access to LMS
  • 24/7 Technical Support
  • Resume Building
  • Placement Assistance
Talk To Us  
IND : +91-8003428234

US : +1- 833-777-233 Toll Free 

Download Syllabus

;

Course Fees

Choose your Dates specialisations,   Receive industry mentorship,   Dedicated career support,  
learn tools & languages & much more

Batches  Date 
TIME TABLE 

  Date  Days  Time 
2nd Oct Sat & Sun (Weekend) 8:00 PM IST to 11:00 PM IST
8th Oct Sat & Sun (Weekend) 8:00 PM IST to 11:00 PM IST
15th Oct Sat & Sun (Weekend) 8:00 PM IST to 11:00 PM IST
23rd Oct Sat & Sun (Weekend) 8:00 PM IST To 11:00 PM IST

Course Fees
Details & Offers 

Was $ 258.00

Now $ 149.00

This Offer   Expires in

Syllabus 

Best-in-class content by leading faculty and industry leaders in the form of videos, cases and projects, assignments and live sessions

14+ Programming Tools/ Languages

25 Expert Coaching Sessions

36+ Content Hours of Learning

• Understanding data warehousing
• How to do the extract, transform and load the processes?
• Understanding the aggregation of data
• Understanding scrubbing and cleansing of data
• Discussing the need of Informatica PowerCenter ETL
● Step-by-step installation of Informatica tool
● Installing and Configuring informatica tool
● Installing the operational administration activities and integration services
● What is Active Transformation?
● What is Passive Transformation?
● Comparison between Active and Passive Transformation
● Features in both Active and Passive Transformation
● What is Ranking Transformation?
● What is Union Transformation?
● Comparing both Ranking and Union Transformation
● Understanding the Deployment in them
● Understanding the Deployment in them
● Characteristics of these transformation
● Understanding rank function and dense rank functions
● Use-cases in each of these functions
● Syntax for each of these functions
● What is Router Transformation?
● Working of router transformation works
● Essential Features of Router Transformation
● Understanding Source Qualifier Transformation.
● Overview of Lookup transformation
● Various types of lookup transformations:
● Connected
● Unconnected
● Dynamic and static
● What is Slowly Changing Dimension (SCD)?
● How to do processing in xml?
● Learn how to handle a flat file, list and define various transformations
● Implementing ‘for loop’ in PowerCenter
● Understanding the concepts of pushdown optimization and partitioning
● Understanding constraint-based loading
● Understanding incremental aggregation
● Understanding different types of Designers:
● Mapplet
● Worklet
● Target load plan
● Loading to multiple targets
● Linking property
● What is Performance Tuning in Informatica?
● Understanding the Objectives of performance tuning
● Defining performance tuning
● Learning the sequence for tuning
● What is a Repository Manager?
● What is the need of a Repository Manager?
● How to Manage repository?
● Understanding various aspects in Repository Manager:
● The client tools
● Functionalities of previous versions
● Important tasks in Repository Manager
● Understanding and adopting best practices for managing repository in informatica
● Understanding Informatica Workflow Manager
● Looking into common tasks/functionalities in the workflow manager
● Creating dependencies and the scope for a workflow monitor
● Creating a workflow with dependencies of nodes
● Defining the different variables and parameters in Informatica
● Discussing the parameter files and their scope
● The parameter of mapping, worklet and session parameters
● Workflow and service variables and basic development errors
● Define variables and parameters in functions, use the parameter of mapping, use worklet and session parameters and use workflow and service variables
● Session and workflow log
● Using debuggers
● Error-handling framework in Informatica
● Failover and high availability in Informatica
● Debug development errors
● Read workflow logs and use the error-handling framework
● High Availability and Failover in Informatica
● Configurations and mechanisms in recovery and checking health of PowerCenter environment
● Configure recovery options and check health of PowerCenter environment
● Infacmd
● pmrep
● infasetup
● Processing of a flat file
● Use commands: infacmd, pmrep and infasetup
● Fixed length and delimited, expression transformations: sequence numbers and dynamic targeting using transaction control
● Perform expression transformations: sequence numbers and dynamic targeting using transaction control
● Dynamic target with the use of transaction control and indirect loading
● Use of transaction control with dynamic target and indirect loading
● Importance of Java transformations to extend PowerCenter capabilities, transforming data and active and passive mode
● Use Java transformations to extend PowerCenter capabilities
● Understanding the unconnected stored procedure in Informatica and different scenarios of unconnected stored procedure usage
● Use the unconnected stored procedure in Informatica in different scenarios
● Using SQL transformation (active and passive)
● Use SQL transformation (active and passive)
● Understanding incremental loading and aggregation and comparison between them
● Do incremental loading and aggregation
● Working with database constraints using PowerCenter and understanding constraint-based loading and target load order
● Perform constraint-based loading in each order
● XML Transformation and Active Lookup
● Various types of XML transformation in Informatica and configuring a lookup as active
● Perform XML transformation and configure a lookup as active
● Understanding what data profiling in Informatica is, its significance in validating content and ensuring quality and structure of data as per business requirements
● Create data profiling in Informatica and validate the content
● Understanding workflow as a group of instructions/commands for integration services and learning how to create and delete workflow in Informatica
● Create and delete workflow in Informatica
● Understanding the database connection, creating a new database connection in Informatica and understanding various steps involved
● Create a new database connection in Informatica
● Working with relational database tables in Informatica, mapping for loading data from flat files to relational database files
● Create mapping for loading data from flat files to relational database files
● Understanding how to deploy PowerCenter for seamless LinkedIn connectivity with Informatica PowerCenter
● Deploy PowerCenter for seamless LinkedIn connectivity with Informatica PowerCenter
● Connection with Sources
● Connecting Informatica PowerCenter with various data sources like social media channels such as Facebook, Twitter, etc.
● Connect Informatica PowerCenter with various data sources like social media channels such as Facebook, Twitter, etc.
● Pushdown optimization for load-balancing on the server for better performance and various types of partitioning for optimizing performance
● Optimize using pushdown technique for load-balancing on the server for better performance and create various types of partitioning for optimizing performance
● Understanding session cache, the importance of cache creation, implementing session cache and calculating cache requirement
● Implement cache creation and work with session cache

Industry Projects

Learn through real-life industry projects sponsored by top companies across industries
  • Engage in collaborative projects with student-mentor interaction
  • Benefit by learning in-person with expert mentors
  • Personalised subjective feedback on your submissions to facilitate improvement
  • What Our Learners Are Saying?

    Where our Alumni Works 

    Learn from leading faculty and industry leaders
    Avatar

    Archit Jha

    Avatar Pre Sales Consultant
    Avatar
    Avatar Solutions Architect
    Avatar

    Suvarchala Kopella

    Avatar System Engineer
    Avatar
    Avatar Cloud Consultant

    Certification

    Master's Degree from Eduranz

    Complete all the courses successfully to obtain this prestigious recognition from LJMU.
  • Connect with Global network of Faculty
  • Get access to complete digital library
  • Earn a Master's degree same as on-campus degree at 1/10th the cost
  • Corporate Training

  • Customized Learning
  • Enterprise Solution
  • 24x7 Support
  • CONTACT US

    FAQ's

    Frequently Asked Questions Related to Course

    Financial Options

    Avail Easy EMI For Learning with Our partnered Companies 

    NO COST EMI

    We are partnered with companies to provide financial options @ 0% interest

    • Instant Transfer
    • No Prepayment Charges

    Check Eligibility

    Recommended Courses 

    Learn through real-life industry projects sponsored by top companies across industries

    SEARCH OUR COURSES

    Browse Our Featured Course.

    Microsoft Azure Developer Associate Certification Training (AZ-204)

    6 Weeks
    Course Starts : 8th May, 2022

    Trending
    $ 149.00
    Read More
    Microsoft Azure Administrator Associate Certification Training (AZ-104)

    6 Weeks
    Course Starts : 19th Jun, 2022

    Trending
    $ 149.00
    Read More
    Python for Data Science Certification Training

    6 Weeks
    Course Starts : 27th Mar, 2022

    Trending
    $ 149.00
    Read More
    Data Science Certification Training

    6 Weeks
    Course Starts : 24th Apr, 2022

    Trending
    $ 149.00
    Read More
    MS SQL DBA Certification Training

    6 Weeks
    Course Starts : 7th Aug, 2022

    Trending
    $ 149.00
    Read More
    Informatica Certification Training

    5 Weeks
    Course Starts : 2nd Oct, 2022

    Trending
    $ 149.00
    Read More
    Tableau Certification Training

    5 Weeks
    Course Starts : 2nd Oct, 2022

    Trending
    $ 149.00
    Read More

    Need More Info ?

    IND: +91-8003428234, US: (Toll Free) +1-833-622-2922