Venkata Krishna

Hi All ,
i have 4years of expreance in ETL and working in following companies (IBM,Capgemini,Syntel) I am interested to provide training in ETL
I have been working extensively with various informatica modules such as informatica Developer, Repository Manager, Workflow Manager and Workflow Monitor.
? Developed ETL mappings, Transformations and Loading using Informatica 9X

? Actively participate in Design calls by going through design documents and notifying issues in prior and work for the clarifications on the same.
? Updating revised design documents as per the guidelines from onsite upon receiving clarifications.
?
? Developing unit test case scenario’s at various stages of development which involve a keen column level testing both from source side and Informatica side.
? Worked with multiple sources such as Relational Databases, Flat files, for extraction using Source Qualifier and Joiner.
I will cover following concepts:-

Data Warehousing Concepts,Dimensional Data Model,Star Schema,Snowflake Schema,Fact Table Granularity,Fact And Fact Table Types,SCD _TYPE(1,2,3)
,Data Integrity,OLAP/OLTP,Factless Fact Table,Types of Dimension,Data Warehouse Design,informatica architecture,all needed transformations
,advanced informatica concepts
properties of mapping,session and workflow,unix and sql basic if required.
sample real time project