Experience in extraction, transformation Having 3.
3 years of experience in design
and development of Extraction Transformation Load (ETL) methodology for
supporting data transformations and processing in a corporate wide ETL
Solutions using Informatica Power Center and loading of data directly from
different source systems like Oracle, flat files
Experience on Informatica Workflow Manager Tools like Task developer,
Workflow Designer and Worklet Designer.
Worked on all the Transformations like Lookups, Aggregator, Expression, joiner,
Update Strategy, Sequence Generator, Sorter and Rank Transformations.
Experience of handling slowly changing dimensions to maintain complete history
using Type I, Type II
Expert to develop mappings with incremental extraction and incremental
aggregation.
Knowledge in star and snowflake schemas, dimensional data modeling, Fact and
dimensional tables.
Developed a good understanding of existing business requirements & also
questioned requirements when needed
Excellent attitude towards teamwork
Worked extensively in team oriented environment with strong analytical,
interpersonal and communication skills
Technical Skills:
ETL Tools : Informatica Power Center 8x/9x
Supporting Tools : Toad, Putty and Winscp
Databases : SQL Server 2008, Oracle10g, 11g
Education:
Bachelor’s Degree in Computer Science Engineering from Jawaharlal Nehru Technology
University.
Professional Experience:
Working as Software Engineer in TATA CONSULTANCY SERVICES, Chennai, from August
– 2013 to till date.
Project 1:
Project : CSM Data Mart
Client : Chartered Semiconductor Manufacturing
Technology : Informatica 9.6.1, Oracle, TOAD, Putty, Winscp, Unix
Environment : Unix and Windows