About US IT Training

Why US IT Training

US IT Training provides the skills, competencies and concepts necessary to improve business performance.

US IT Training programs are designed to help you acquire the practical skills you need quickly and in-depth and are job-focused.

US IT Training its curriculum to the corporate clients needs thus strengthening the client's competence and skills.

What We Believe

We believe we will be successful if our clients are successful. We believe in professionalism. For us this means to always:

Put the client's interest ahead of our own.

Behave as professionals.

Keep our client information confidential.

Tell the truth as we see it.

Deliver the best of our firm to every client as cost effectively as we can.

Our Professionals are

Responsive

Resourceful

Trustworthy

Innovative

Who We Are

We are a team of Senior IT consultants with a wide array of knowledge in different domains, methodologies, Tools and platforms. We strive to develop and deliver highly qualified IT consultants to the market. We do our best everyday and we have some of the topnotch consultants working for the fortune 500 companies. Our Vision

US IT Training vision is to be the leading global IT training and consulting services firm, respected for our world-class professionals, and trusted with our clients most critical business challenges. Our Core Values

Six shared values underpin everything US IT Training professionals do:

Clients - our first priority

People - our most valuable asset

Integrity - without compromise

Pride - in the quality of our work

Excellence - through passion

Commitment - to improving the company

What We Do

Learn through Experience - We differentiate our training and development program by delivering Role-specific training instead of Product-based training. Ultimately, our goal is to deliver the best IT consultants to our clients. Mission

To develop and deliver exceptional IT consultants to our clients

To provide innovative training solution for individuals and corporations

To coach excellence in technology, business and people skills

To excel in career mentoring

Mission Values

Dream

Innovate

Educate

Collaborate

Grow

Thank you for visiting us.
Let us know how we can help you further with your career?
For details please contact us
Thank you and happy day :) 

Informatica

INTRODUCTION TO DATAWAREHOUSING

·         Data Warehousing Concepts

·         Dataware housing (what/Why/How)

·         Data Modelling(Schemas, FACTS and DIMENSIONS)

·         Slowly Changing Dimensions

·         Metadata

POWERCENTER COMPONENTS AND USER INTERFACE

·         PowerCenter Architecture

·         PowerCenter Client Tools

·         Lab – Using the Designer and Workflow Manager

SOURCE QUALIFIER

·         Source Qualifier Transformation

·         Lab Project Overview

·         Lab A – Load Payment Staging Table

·         Source qualifier Joins

·         Lab B – Load Product Staging Table

·         Source Pipelines

·         Lab C – Load Dealership and Promotions Staging Table and Real time issues

EXPRESSION, FILTER, FILE LISTS AND WORKFLOW SCHEDULER

·         Expression Editor

·         Filter Transformation

·         File Lists

·         Workflow Scheduler

·         Lab – Load the Customer Staging Table and Real time issues

JOINS, FEATURES AND TECHNIQUES I

·         Joiner Transformation

·         Shortcuts

·         Lab A – Load Sales Transaction Staging Table

·         Lab B – Features and Techniques I and Real time issues

LOOKUPS AND REUSABLE TRANSFORMATIONS

·         Lookup Transformation

·         Reusable Transformations

·         Lab A – Load Employee Staging Table

·         Lab B – Load Date Staging Table and Real time issues

DEBUGGER

·         Debugging Mappings

·         Lab – Using the Debugger

SEQUENCE GENERATOR

·         Sequence Generator Transformation

·         Lab – Load Date Dimension Table and Real time issues

LOOKUP CACHING, MORE FEATURES AND TECHNIQUES

·         Lookup Caching

·         Lab A – Load Promotions Dimension Table

·         Lab B – Features and Techniques II

·         Review and more Lab Activities and Real time issues

ROUTER, UPDATE STRATEGY AND OVERRIDES

·         Router Transformation

·         Update Strategy Transformation

·         Expression Default Values

·         Source Qualifier Override

·         Target Override

·         Session Task Mapping Overrides

·         Lab – Load Employee Dimension Table and Real time issues

DYNAMIC LOOKUP AND ERROR LOGGING

·         Dynamic Lookup

·         Error Logging

·         Lab – Load Customer Dimension Table

UNCONNECTED LOOKUP, PARAMETERS AND VARIABLES

·         Unconnected Lookup Transformation

·         System Variables

·         Mapping Parameters and Variables

·         Lab – Load Sales Fact Table

SORTER, AGGREGATOR AND SELF-JOIN

·         Sorter Transformation

·         Aggregator Transformation

·         Active and Passive Transformations

·         Data Concatenation

·         Self-Join

·         Lab – Reload the Employee Staging Table and Real time issues

SCD type1 – LAB

SCD type2 – LAB

SCD type3 – LAB

MAPPLETS

·         Mapplets

·         Lab – Load Product Daily Aggregate Table

·         Review and more Lab Activities and Real time issue

WORKFLOW VARIABLES AND TASKS

·         Link Conditions

·         Workflow Variables

·         Assignment Task

·         Decision Task

·         Email Task

·         Lab – Load Product Weekly Aggregate Table

MORE TASKS AND REUSABILITY

·         Event Raise Task

·         Event Wait Task

·         Command Task

·         Reusable Tasks

·         Reusable Session Task

·         Reusable Session Configuration

WORKLETS AND MORE TASKS

·         Worklets

·         Timer Task

·         Control Task

·         Lab – Load Inventory Fact Table

INFORMATICA ANALYST 9.1

·         Analyst GUI

·         Metadata and Data access/import

·         Column Profiling

·         Frequency/Patterns/Statistics/Drill downs

·         Rule Profiling

·         Out Of The Box rules

·         Custom rules

·         Reference Tables Management

·         Project Collaboration

·         Data Quality Score carding

INFORMATICA DEVELOPER 9.1

·         Developer GUI

·         Developer Profiling including:

·         Mid-stream profiling

·         Join analysis profiling

·         Building Data Quality Mapplets and Rules

·         Data Standardization

·         Cleanse, transform and parse data using DQ transformations such as the Case Converter, Merge, Labeller, Standardizer, Parser

·         Address Validation

·         Perform address validation and create AV mapplets and mappings 

·         Matching

·         Group data prior to matching to improve matching performance

·         Perform DQ and Identity Matching to identify duplicate records

·         Develop Matching Mapplets

·         Associate and Consolidate matched data

·         Work with the Data Quality Assistant

·         PowerCenter Integration

·         Parameterization

·         Data Quality Workshop