SUMMARY:

• 7 years of ETL and Data Integration experience in Designing, Developing and Supporting ETL Objects in Informatica PowerCenter.
• 7 years of experience in all Phases of Data Warehousing and Application Development Lifecycle including Requirement Gathering, Documentation, Analysis, Designing, Development, Testing, Deployment, and Supporting.
• Experience working in Business Intelligence Technologies - Business Objects Reports and Ad Hoc Query extracts.
• Proficient in Informatica Complex Mapping, followed practice of using Mapping Parameters and Variables, SQL overrides, Pre / Post session commands, Partitioning.
• Expertise in creation and maintenance of Database Objects like Tables, Views, Materialized views, Indexes, Sequence, Synonyms etc. in SQL Server, Oracle, Teradata, and DB2.
• Experience in maintenance of Stored Procedures, Functions and Packages for Change requests.
• Expertise in ETL Optimization - Transformation level, identifying and creating Reusable components, using indexes, Partitioning at DB level and Informatica level, Query optimization and reducing unnecessary DB resources utilization.
• Proficient in analyzing Conceptual, Logical, Physical, Relational and Dimensional Data Models.
• Expertise in developing Star Schema, Snowflake Schema, Galaxy Schema and OLAP.
• Working knowledge with Data Modeling: Both Reverse and Forward Modeling using Erwin.
• Experience in Creating, Scheduling and Supporting Batch using Unix Codes and Unicenter Autosys.
• Experience in working with Flat Files, XML and Unstructured data using Infa B2B.
• Working knowledge of Informatica Meta Data Manager and Power Exchange.
• Experience working in populating the Data Warehouse tables using SQL Loader, TPUMP, MULTILOAD, FASTLOAD, Oracle Packages, and Stored procedures.
• Skilled in creating Process Flow Diagrams, Data Flow diagrams and High level Documents.
• Excellent Communication, Analytical and Interpersonal skills.
• Quick learner and adaptive to new and challenging technological environments.
• Highly motivated to work in cross functional team or independently with the ability to contribute and be a productive team member.

SKILL SET:

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Project Detail: Northeast Item File Integration:Confidential had acquired Bompre o Stores North East Region that contains all of Item File information in a legacy system SAD . The purpose of this project is to provide a solution for Integrating North East Item file Data to Wal-Mart's Online Item File Database through an Initial Load process. After post Initial Load, the Item Sync process at Online Item File OIF for NE Item creation/maintenance is required to integrate the two system into one legacy system.

Responsibilities:

• Worked with Business Analysts, Architects and Team Leads for gathering Functional and Technical requirements.
• Assisted Architects to create Process Flow Diagrams, Data Flow Diagrams and High Level Documents.
• Assisted Team Lead to prepare Mapping Design Documents and ETL Designs, Mapping Templates, etc.
• Involved in Designing and Developing ETL processes using Informatica to process the data from IBM MQ server - XML source files, staging at SQL server database, Parsing it and performing transformation activity and load into Oracle database.
• Designed and Developed Mappings with Reusable Transformations and Mapplets considering Functional and Non-Functional Requirements.
• Developed Complex Mappings for Data Integration based on Business Requirement and Logic.
• Performed Unit Testing and helped SIT/UAT team to setup the Data for Testing.
• Profoundly worked on Analyzing and Fixing the 'Code Defects' raised by SIT/UAT team.
• Closely worked with the Database Developer to ensure the database changes are implemented as per the requirement.
• Participated in daily stand-up calls with team members located in Brazil and India to discuss daily progress, plans, and technical issues.
• Developed complex transformations like 'transaction control', Java, XML parser, calling Sync services through WSDL.
• Extensively worked on data validation and error handling process within the Informatica.
• Worked on Optimizing the ETL and Database level.
• Involved in migration of ETL Objects and Database changes from DEV to SIT and UAT environments and preparing Release Notes.

Environment: Informatica PowerCenter 9.5, SQL Server 2012, Oracle, DB2, XML, HPALM.

Confidential

EDW ETL/SQL Developer

Project Detail: Claims Redesign

IBM Seterus is one of the leading specialty loan servicing companies. The goal of Claims Redesign EDI Project is to build the system that supports to complete the claim processing via Electronic Data Interchange EDI to enhance the efficiency and effectiveness of mortgage claim processing. EDW is the centralized Data Warehouse built on SQL Server integrated and standardized to provide a consistent and integrated view for the business to generate and analyze report data.

Responsibilities:

• Actively Participated in Business/Technical Discussions to understand changes and to gather Business/Technical Requirements
• Created Technical and ETL Design Documents with details of Database Objects and Transformation logic
• Involved in migration of Informatica Mappings/Sessions/Workflows from Development to QA, UAT and Prod environments
• Used MD5 Hash functionality for CDC/Incremental Loading to simplify the Transformation level Coding and enhance the Performance.
• Extensively worked on Re-creating ETL code that loads SCD tables focusing the performance of Nightly Batches.
• Eliminated Mapping Bottlenecks by identifying it first through thread statistics from session logs.
• Worked on creating and setting AutoSys jobs to run the Informatica Workflows in automated manner including Nightly Batch Processes.
• Was responsible for preparing the Release Documents and worked with Release Management to Release Codes/Objects to SQA and UAT environment.
• Fixed issues and bugs identified by SQA and UAT team.
• Actively involved to find the impact to EDW and downstream applications due to upstream enhancements/changes
• Performed Source System Analysis to make sure Source Data is aligned with EDW Data Mode

Environment: Informatica PowerCenter 9.1/9.5, SQL Server2008r2/2012, DB2 v9, Flat File, AutoSys.

Confidential

Informatica Developer

GE Energy is the nation's leading manufacturer and service provider in the sector energy. This project was implemented for GE Energy headquarters in Schenectady, USA. The primary objective of this project was to enhance the existing ETL environment by adding new ETL code consolidated the underlying ETL migration architecture. Served as an ETL Developer for GE Energy Business Intelligence Group served in multiple projects including building of new data marts, producing data required for Business Analytics and other teams, etc.

Responsibilities:

• Worked on Mainframe/COBOL data by using Normalizer Transformation.
• Extensively worked on Change Data Capture/Incremental loading of SCD Type I/II.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources flat file feeds from various sub divisions and market segments
• Worked with various business teams to understand Business Requirements and involved in Source System Data Analysis for discovery phase
• Prepared Technical, ETL Design, and Error Handling and Audit Strategy Documents
• Worked closely with Architects and Data Modelers to understand and respond changes occurred due to ETL migration and new requirements.
• Developed complex Informatica Mappings and performed Unit Integration Testing
• Involved in Improving the performance of the ETL by using several techniques like Indexing, Caching and DB Partitioning
• Responsible for 'Best Practices' like naming conventions, performance tuning, and error handling.
• Worked on the Database Triggers, Stored Procedures, Functions, and Database Constraints and the developing the applications using SQL Programming DDL, DML and DCL .
• Worked with Tivoli Work Scheduler team for the scheduling changes and modifications
• Responsible for Unit testing and Integration Testing of Database Objects, Mappings and Workflows

Environment: Informatica Power Center 8.x/9.x, Oracle 11g , IBM Tivoli, Sun Solaris, UNIX Shell Scripts, Erwin, TOAD

Confidential

ETL Developer

Department of Public Welfare is servicing the public welfare programs and products such as health, home, food, and personal benefits to eligible members. The main aim of the project was to consolidate the data from various sources into one Central Repository. Served as an ETL Informatica Developer supportingData and Report Generating for Public Benefit Programs.

Responsibilities:

• Responsible for converting Business Requirement Documents BRD's and Functional Requirements into Technical Specifications/Templates.
• Developed Slowly Changing Dimension Mappings to keep track the history of changes for public beneficiary personal, demographic and other data.
• Developed the Incremental Loading mappings using Mapping Variables and Parameter Files.
• Heavily worked on the Database Objects including Triggers, Stored Procedures, Functions and Database Constraints.
• Designed SSIS Packages to transfer data from flat files and to SQL Server using Business Intelligence Development Studio.
• Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Extensive Data Modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake Modeling, and FACT and Dimensions Tables.
• Worked on Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc
• Worked on Debugging and Troubleshooting the Data issues by reported by users of all environments in all phases of Data Warehousing Life Cycle

Environment: Informatica Power Center 8.6, Business Intelligence Development Studio BIDS , SQL Server 2008r2, Flat Files, SQL Server 2008 R2, Business Objects,

Confidential

ETL Informatica Developer

Bayer Healthcare is one of the leading enterprises in the area of producing medicines and medical products. Bayer Enterprise Data Warehouse implemented large scale business process reengineering project for their distribution and retail division. Bayer Enterprise data warehouse consists of more than 5 years of data, which was derived from different data marts with different formats. The data warehouse was built in Oracle database. The sources for this warehouse were SQL Server, Oracle, XML and flat files. These sources were loaded into Oracle data warehouse with Informatica.

Responsibilities:

• Extensively used MS Visio for Data Modeling
• Extensively worked on dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS
• Performed the Unit Testing for developed ETLs and Data Testing to align with Business Requirements
• Worked on SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies in SQL Server
• Worked with Teradata loaders within Workflow manager to configure FastLoad and MultiLoad sessions. Build ETL's with Teradata as the target for the Data Marts
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Implemented Slowly Changing Dimensions methodology to keep track of Historical Data.
• Developed complex Informatica Mappings to load the data from various sources into the Data Warehouse/Data Marts.
• Written Detail Design Documentations to describe program development, logic, coding, testing, changes and corrections.
• Worked directly with technical lead to convert Technical Documents to ETL Designs.
• Created reusable Transformations and Mapplets to use in multiple mappings.
• Used Crystal Reports to generate reports
• Debugged issues and resolved time-to-time technical problems
• Scheduled the ETLs as periodical jobs as per business SLAs
• Developed and implemented the UNIX shell script for the start and stop procedures of the session

Environment: Informatica Power Center 8.x, SQL Server2005/2008, Flat files, Teradata v12, Visio, UNIX Shell Scripting, Crystal Reports

Confidential

Informatica Developer

Nepasoft is a Leading Software house which develops various national and Outsourcing Projects from International Companies The requirements are handled through a variety of software business applications, databases and scripting methods. Worked as an Informatica Developer at Nepasoft that supporting Data Warehouse work for variousClient organizations.

Responsibilities:

• Extensively used Informatica Power Center for extracting Data from Relational Tables and Flat Files and loading it back to Relational Tables
• Developed the Informatica Mappings using different Transformations like Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, and Rank in the Informatica Designer
• Wrote PL/SQL and T-SQL codes to Create/Alter/Drop Database Objects required to complete ETLs
• Designed, developed, managed database star schema, snowflake schema, and various hierarchical and lookup tables
• Extensively worked on Excel Pivot Table
• Generated Full client Reports from Different Data Providers in Business Objects using Oracle Database
• Involved in writing and executing Test Cases and Test Scenarios

Environment: Informatica Power center 7.1, Oracle 9i, SSIS, SQL Server, Business objects, Excel, Windows XP