Professional Summary:

Nine years of total IT experience in the Business Requirements Data Analysis, Application Design, Development, and Implementation of ETL Solutions for finance, Insurance Industries.

• Experienced in Data Warehouse concepts, ETL- Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis and Documentation using Informatica PowerCenter 9.1.1, 8.6.1 Designer, Workflow Manager, Workflow Monitor , and Power Exchange.
• Using of Various Transformation of Sorter, Aggregator, Joiner, Sequence generator, look up, Router and Normalizer.
• Experienced in preparing HLD and LLD
• Worked with various sources like Oracle11g, SQL Server2008, DB2, and Flat files.
• Experienced in using the Oracle SQL Loader feature for loading the data from Flat Files to Data Base tables for Bulk Loading
• Automated and scheduled the Informatica jobs using UNIX shell scripting CRONTAB ,
• Worked with mainframe applications
• Extensive experience in error handling and problem fixing in Informatica
• Involved in Relational database design and development of data Warehouse data feeds.
• Very strong in Relational Databases RDBMS , Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying
• Expertise in Data Warehousing development life cycle. SDLC
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in writing stored procedures and functions in Sql Server 2005/2008
• Directly responsible for the Extraction, Transformation Loading of data from multiple sources into Data Warehouse.
• Extensive database experience and highly skilled in Oracle, SQL Server, DB2,Flat Files
• Expertise in configuring and manipulating Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling. Extensive knowledge with Dimensional Data modeling, Star Schema / Snowflakes Schema, Fact and Dimension tables.
• Advanced knowledge in ETL and Data warehousing with OLAP technology.
• Implemented Slowly Changing dimensions Type 1, Type 2 methodology for accessing the full history of accounts and transaction information.
• Ability to handle and interact with Business users, collect and analyze business / functional requirements.
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.

Technical Skills:

• ETL Tools: Informatica Power Center 9.x/8.x, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor FACT Dimensions tables, Physical logical data Modeling.
• Databases: Oracle 11g, IBM DB2, MS SQL Server 2005/2008
• Languages: SQL, PL/SQL, COBOL, JCL
• Office Package: MS-Office 2003, 2007, 2010
• OS: Linux, UNIX, Z/os, Windows XP

Professional Experience

Confidential

Senior ETL Consultant

Responsibilities:

• Understanding the Overall Architecture of CDW system in Existing Technology
• Analysis of existing code Reverse Engineering and Forward Engineering Point of View.
• Identification of Reusable Components of the Code and Job
• Preparation of Mapping Specification document.
• Development of Mappings according to Mapping Specification document.
• Provided Problem-Approach-Solution Approach document to client.
• Preparation of HLD and LLD Documents

Environment: Informatica 9.5, Teradata, UNIX, Control M

Confidential

Senior ETL Consultant

Responsibilities:

• Understanding the Overall Architecture of RPS system in Existing Technology
• Identification and analysis of COBOL programs and JCL involved
• Analysis in Reverse Engineering and Forward Engineering Point of View.
• Identification of Reusable Components of the Code and Job
• Preparation of Mapping Specification.
• Development of Mappings according to Mapping Specification document.
• Creating mappings to format the fields as per business unit requirement, the formatting involves conversion of Raw format data in to meaning full data through parsing, formatting of various fields.
• After the initial conversion is done through ETL, the data is loaded into Test Region for the QA of Business Unit, and various reports regarding data is generated as requested by them.
• Provided Problem-Approach-Solution Approach document to client.
• Preparation of HLD and LLD Documents
• Designing the ETL Process according to the Framework Intuito to accommodate various Capabilities
• Developed conducted unit testing the Informatica mappings/work lets/workflows.
• Handled dimension data modelling so that BI reports could be optimized.

Environment: Informatica 9.5, DB2, Oracle, COBOL, UNIX, Control M

Confidential

Senior ETL Developer

Responsibilities:

• Creating mappings to format the fields as per business unit requirement, the formatting involves conversion of Raw format data in to meaning full data through parsing, formatting of various fields.
• Various functions available in Informatica were used in the code to have the data converted.
• After the initial conversion is done through ETL, the data is loaded into Test Region for the QA of Business Unit, and various reports regarding data is generated as requested by them.
• If the data was loaded as per their requirement, the counties had to go live in Production and data was available for customers.
• Presently the conversion project was in progress for Texas, Wyoming and Tennessee states.
• After going live in production these counties were updated through daily update process.
• Coordinated with database team.
• Provided Problem-Approach-Solution Approach document to client.
• Developed conducted unit testing the Informatica mappings/worklets/workflows and scheduled them.
• Handled dimension data modelling so that BI reports could be optimized.

Environment: Informatica 9.5, DB2, SQL Server.

Confidential

ETL Developer

Responsibilities:

• Conducted analysis of current process running in mainframes and documenting.
• Plan for conversion and implementation.
• Various mappings to implement changes for conversion.
• Instrumental in running the process in Informatica concurrent to the mainframes and verified the results to match with mainframes.

Environment: Informatica 8.x, DB2, SQL Server.

Confidential

ETL Developer

Responsibilities:

• Preparation of technical specification document
• Preparation of LLD Documentation

• Design and Coding of Informatica mappings Integrate Data from various sources
• Extraction and providing the reports required for business users

Environment: Informatica 8.6, DB2, SQL Server, Linux

Confidential

ETL Developer

Responsibilities:

• Analyzing and understanding the business requirement
• Preparation of Technical documentation and mapping specification
• Designing and coding of Informatica Mapping
• Scheduling in workflow manager
• Preparation of reports required for business unit

Environment: Informatica 8.6, DB2, SQL Server, Linux

Confidential

Developer

Responsibilities

• Initial analysis of Data and preparation of initial reports
• Understanding the Business logic received from Business Unit
• Design a flow for Conversion process
• Coding of Cobol programs to process data as per requirement
• Preparation of reports required by the business units

Environment: MVS, COBOL, DB2, JCL, DYL280, and Expeditor.