We offer a 6 Week intensive Informatica Training followed by interview guidance and technical support during the 1st project. Instruction will be both in class and online. Students will be given 24/7 access to Informatica Software (Power Center 8.6, Power Exchange 8.6). Limited Accommodation is available*
Eligibility: Preferably BS/MS in CS/IS/IT, IT Professionals. Candidates from Non-IT background are also welcome if they are willing to devote at least three (3) hours a day.
Target Audience: IT aspirants and IT Professionals looking to switch fields
Topic | Number of Hours |
Data Warehousing Concepts | 10 Hrs |
SQL, PL/SQL | 10 Hrs |
Live Project | 10 Hrs |
Informatica 8.6 | 24 |
Total Hours | 54 ( Approx 8 weekends) |
Course Details
Week 1 Introduction to Data warehousing:
Types of Systems, OLTP, DSS, Maintenance of Data warehouse, Data warehousing Life Cycle, Data warehousing Testing Life Cycle, Data warehousing Architecture, Source, Integration Layer, Staging Area, Targets, Analysis & Reporting,• ODS
Data Modeling Introduction, Different phases of Modeling, Multi Dimensional Modeling , Dimensions, Facts, Multi Dimensional Model Hierarchies, OLAP, MOLAP, ROLAP, HOLAP, Cubes and their Functions, Star Schema, Fact Table, Dimensional Tables, Snow flake Schema, Factless Fact Table, Confirmed Dimensions
Week 2 (Day 1)
SQL Basics
Introduction to Relational Database Systems: ORACLE, DB2, SQL Server Introduction to SQL:Basic SQL commands, the SELECT Statement, Ordering the output, Conditional retrieval of data , Working with variables Pseudo columns and functions, character functions, date functions , Using non-character function multiple tables, Different type of Joins, Writing Outer Joins ,Using the SET operators Aggregating data using group functions
Week 2 (Day 2)
Introduction to Informatica
Overview, Basic Definitions, Informatica Products, Informatica Architecture, Tools and their roles, Folders Sub Folders Power center, Differences between 7x and 8x
Week 3 (Day 1)
SQL Continued
Creating Subqueries Enhancing groups function ,Transaction Control Language, Rollback, Commit, Processing hierarchies , Creating the Tree structure, Data Manipulation Language Data Definition Language, Using Declarative Constraints Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null
Week 3 (Day 2)
Informatica Designer Introduction
Introduction to designer, Designer interfaces, Designer tools, Defining Sources, Database as a source, Defining Targets, Importing from database, Creating a new target Creating target database objects Mapping Introduction, Ports, Mapping Table to Table, Mapping flat file to Table
Week 3(Day 2,3)
Transformations
Expression Transformation, Aggregator Transformation, Joiner Transformation, Homogeneous, Heterogeneous, Sequence Generator Transformation, Rank Transformation, Router Transformation, Union Transformation,Source Qualifier, Source Qualifier Transformation, SQL override in Source Qualifier Transformation, Mapping Source Qualifier as Filter Source Qualifier to join data, Flat Files sources & targets, Delimited Fixed width, Debugger
Week 4(Day 1,2)
Lookup:
Static, Dynamic, Unconnected, Cached & Uncached, Customized Named Cache use technique from static & dynamic lookup Flat file lookup, Handling subsecond precision for a Lookup transformation, Filtered lookup Mapping Wizards, Implementing of SCDs (Each types by at least by five Methods), Type-I, Type-II, Type-III
Week 4(Day 4)
SQLT, Normalizer, Transaction Control, Stored Procedure Transformation, XML Transformation, Custom Transformation
Informatica Workflow Manager
Workflow Introduction, Tasks, Workflow Tools, Connections Defining Tasks, Command Task, Email Task, Session Task Link Conditions, Event Wait & Event Raise, Setting properties of Session Task, Creating Workflow, Starting Workflow, Monitoring Workflow, Workflow Parameters
Week 5(Day 1,2)
Advanced Topics
Incremental Aggregation, Mapping Analyst for Excel (MAE), Push-down Optimization Mapplet Implementation, Meta Data Backup & Restore, Copying Repository, Sending Notification Messages, Informatica Tuning, User Defined Function, Version Control, Copy folder and Deployment, Shortcut, pmcmd commands Week 8 Project The project will be conceived and developed by the group from scratch, right from gathering requirement to final mappings. Various persons will assume various roles and the roles will be interchanged as the project progresses. The project may be based on Insurance/ Financial/ Pharmaceutical industry
Week 5/6
Project
The project will be conceived and developed by the group from scratch, right from gathering requirement to final mappings. Various persons will assume various roles and the roles will be interchanged as the project progresses. The project may be based on Insurance/ Financial/ Pharmaceutical industry
Interview Sessions
Resume’: Every member will be helped with resume. Each aspect of the resume and the project will be discussed extensively. Interview: Each member will be subjected to a rigorous interview preparation which includes defending resume’, Question bank, Recorded Interview Sessions and mock Interviews
Support during the 1st project *
Technical Support will be provided to Individuals throughout the 1st project/1st Year*
Certification Guidance*
Individuals interested in Preparing for Certification in Informatica will be given the required material and guidance
*Subject to certain Terms and Conditions. Please comment at this post for details. Please provide a valid email address so that we may contact you.