IdentityTechnical Skills
Tools used: Informatica PowerCenter V9.6, Infosphere Datastage 8.5 & 9.1
Operating System: Linux, Windows
Database used: Oracle
Scheduler: Autosys, Crontab
Change Management tool: Service Now
Experience Summary
Working as Software engineer in TATA CONSULTANCY SERVICE. Having an aggregate IT experience of 5 plus years in Data warehouse applications using Informatica Power Center 9 and Oracle10g and SQL Server. Strong analytical, problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction. Worked on Informatica Power Center tool for data Conversion From variety of source systems. Dealt with various transformation logic like Lookup,Aggregator,Joiner,Source Qualifer,Expression,Update Strategy and more. Good exposure to PowerCenter informatica 9.X,10.X , Informatica Cloud (ICS) and Intelligent Informatica Cloud services. Experience in Informatica Power Center client components like Designer, Workflow Manager, Workflow Monitor and Repository Manager. Extensive experience in Extraction, Transformation and loading of Data from Heterogeneous Source System like Flat Files and Oracle.
Job Description
Developed and maintained technical documentation from Source to Target load Process and ETL development.
Created and used different sources, targets and transformations to create mappings for
loading the data into target systems using Informatica.
Used most of the Transformations like Source Qualifier, Aggregator, Expression, Filter, Joiner, Router, Lookup, Sorter, and Update Strategy to load data into Slowly Changing Dimension.
Used Sorter and Aggregator transformations in combination for performance tuning of aggregation used in the mappings.
Validating the mapping as per ETL specification. Involved in Requirement Gathering From the Clients and Preparation of SRS Documents Developing the Session, Workflows and Worklets.
Prepared Unit test cases to meet business requirements and performed unit testing of mappings. Effective coordination with Client and also with Development team to resolve the possible production issues.
