• 8 years of IT experience in design, analysis, development, documentation, coding, and implementation including Databases, Data Warehouse, ETL Design, Oracle, SQLServer databases, Informatic Power Center10X,9.x/8.x, etc • Expertise in the ETL Tool Informatica and have extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor • Extensively worked with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, Stored Procedure, XML Parser, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, etc. • Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and vice versa • Extensively worked on Relational Databases Systems like Oracle11g/10g/9i, MS SQL Server and Source files like flat files, XML files • Played a key role in creating / managing the Data Quality Process and in the development of DQ Rules, Profiles, Profile Models and Scorecard for various business requirements • Experienced in mapping techniques for Type 1, Type 2, and Type 3 Slowly Changing Dimensions • Sound knowledge of Linux/UNIX, Shell scripting, experience in command line utilities like pmcmd to execute workflows in non-windows environments • Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server, MS Access, Flat Filesetc. • Experience in Data profiling and Scorecard preparation by using Informatica Analyst. • Experience in Migrating Data from Legacy systems to Oracle database using SQL*Loader • Experienced in scheduling Sequence and parallel jobs using UNIX scripts, Linux Scripts,and scheduling tool CA WA Workstation (ESP) • Experience in Performance Tuning of targets, sources, mapping, workflow, and system. • Involved in SDLC- software development life cycle (Water, Scrum/Agile) of building a Data Warehouse on windows and Unix Platforms. • Well versed with onsite/offshore project delivery model and experience in working with offshore teams • Designed Applications according to the customer requirements and specifications. • Excellent Interpersonal and Communication skills coupled with strong technical and problem-solving capabilities. • Excellent analytical, problem solving, technical, project management, training, and presentation skills.