PROFESSIONAL SUMMARY:

• 8 years of IT experience, in Data warehousing and various technologies, with domain knowledge of Marketing, Pharma, Retail, Finance, Telecommunications, Automotive, Mortgage and Consulting Services.
• Implemented various Data warehouse projects and supported them by using Ralph Kimball and Bill Inmon methodologies.
• Experience in Extraction, Transformation and Loading (ETL) of Data into Data Warehouse using Informatica PowerCenter 9.x, 8.x, 7.x versions.
• Experience in Designing the Workflows, Mappings, creation of Sessions and scheduling them using Informatica Power Center 9.5, 9.1, 8.6, 8.1 and 7.1.
• Experience in configuring Power Exchange DB2 sources and ORACLE CDC sources.
• Experience in developing Real time Power Exchange - Power Center mappings.
• Experience in Designing and developing the complex mappings from various Transformations like Source Qualifier, Joiner, Aggregator, Router, Filter, Expression, Lookup, Sequence Generator, Java, Update Strategy, Custom Transformation etc.,
• Experience in Debugging sessions and mappings; Performance Tuning of the Sessions and mappings, implementing the complex business rules, optimizing the mappings.
• Experience in data warehousing techniques for Data cleansing, Slowly Changing Dimensions
• Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, XML, Excel) to load into data warehouse/data mart targets.
• Implemented data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon’s (SCD) and Change Data Capture (CDC).
• Experience with SQL Query Tuning SQL Server/Oracle RDBMS.
• Experience with UNIX Shell Scripting.
• Experience in working with Terabyte Size Source Target Databases like Netezza & Teradata.
• Extensive development experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing and Business Intelligence.
• Knowledge on Microsoft SQL Business Intelligence Tools.
• Knowledge on Business intelligence tools like Business objects, Crystal Reports, OBIEE
• Prepare/maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.
• Worked with Business Objects XI R2 for generation of reports.
• Knowledge on Data Modeling Tools Erwin, Sybase Power designer
• Excellent oral/written/interpersonal communication skills, quick learner, willing to adapt to the team/organizational environment.

TECHNICAL SKILLS:

Data Warehousing Tools: Informatica Power Center 9.x/8.x/7.x,Informatica Power Exchange 9.5, Informatica Data Explorer 9.1 Business Objects, Crystal Reports, SSIS, First Logic Data Quality (DQ), Sales force.

Data Modeling Tools: CA Erwin, Sybase Power designer 15, MS Visio.

Programming Languages: TSQL,PL/SQL,SOQL,C.

Operating Systems: Win Windows 95/98/NT/2000/XP, UNIX, Linux, MS-DOS.

Databases: Oracle 11g/10g/9i, SQL Server 2012/2008, Netezza, Teradatav14, DB2 UDB.

Scripting Languages: UNIX Shell Scripting, Korn Shell Scripting (Kshell), VB Scripting.

Tools: Toad, Aginity, MS Visio, MS-Office, Tortoise CVS, Citrix Tidal scheduler, Filezilla, Putty,Zeke, Sales Force Workbench.

PROFESSIONAL EXPERIENCE:

Confidential, NC

Sr. Systems developer

Responsibilities:

• Generated the data as per the Clients specifications using mappings and transformations.
• Developing well-tuned Mappings using Informatica Designer Tool which involves identifying and rectifying the bottle necks at various levels like Source, Target, Mapping, Session and System
• Development of Exception Handling and Error Handling Process.
• Minimize the data source errors by using Informatica Data Virtualization.
• Entirely responsible for building various Subject areas containing information from various upstream and manipulate and present it in the way business requires.
• Tuning the Informatica mapping, session performance by using various techniques like pushdown optimization and Optimizing Target, Source and even at the Database level.
• Meet the SLA at all times and improved the Performance of loading data from Key Data sources.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Coordinated with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives
• Generated the data as per the Clients specifications using mappings and transformations.
• Developing well-tuned Mappings using Informatica Designer Tool which involves identifying and rectifying the bottle necks at various levels like Source, Target, Mapping, Session and System
• Development of Exception Handling and Error Handling Process.
• Minimize the data source errors by using Informatica Data Virtualization.
• Entirely responsible for building various Subject areas containing information from various upstream and manipulate and present it in the way business requires.
• Tuning the Informatica mapping, session performance by using various techniques like pushdown optimization and Optimizing Target, Source and even at the Database level.
• Meet the SLA at all times and improved the Performance of loading data from Key Data sources.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Coordinated with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives

Confidential, VA

Sr. Informatica ETL Consultant

Responsibilities:

• Generated the data as per the Clients specifications using mappings and transformations
• Developed well-tuned Mappings using Informatica Designer Tool which involves identifying and rectifying the bottle necks at various levels like Source, Target, Mapping, Session and System
• Development of Exception Handling and Error Handling Process.
• Implemented Mapping template using power center mapping architect using Visio.
• Meet the SLA at all times and improved the Performance of loading data from Key Data sources.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.

Environment: Informatica Power Center 9.5, Oracle 11, Flat Files, UNIX, XML

Confidential, FL

Sr. Informatica ETL Consultant

Responsibilities:

• Generated the data as per the Clients specifications using mappings and transformations.
• Maintained Meta Data For Auditing, Logging and Error Handling.
• Developing well tuned Mappings using Informatica Designer Tool which involves identifying and rectifying the bottle necks at various levels like Source, Target, Mapping, Session and System
• Development of Exception Handling and Error Handling Process.
• Minimize the data source errors by using Informatica Data Profiling.
• Entirely responsible for building various Subject areas containing information from various upstream and manipulate and present it in the way business requires.
• Tuning the Informatica mapping, session performance by using various techniques like pushdown optimization and Optimizing Target, Source and even at the Database level.
• Meet the SLA at all times and improved the Performance of loading data from Key Data sources.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Coordinated with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives
• Involved in analyzing, defining, and documenting data requirements by interacting with the client and Salesforce team for the Salesforce objects
• Worked on the Source to Target Mapping documentation by identifying the business rules, basic business process flow and sub-flow for the concerned business activity flow steps
• Data validation was done using GUI TOOLS and on Salesforce.com
• Maintained Meta Data For Auditing, Logging and Error Handling.
• Involved in Debugging and Performance Tuning at various levels from sources to the mappings and to the Targets, session level and at workflow levels.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Built ETL Code to maintain history for Sales Tracker for contracts that have been posted
• Involved in running UNIX Shell scripts and scheduling in Zeke.
• Meet the SLA at all times and improved the Performance of loading data from Key Data sources
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Coordinated with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives

Environment: Informatica Power Center 9.5, Teradata v14, Flat files, Oracle 11, CDC, Mainframe, SQL Server 2008, Unix, Sales force workbench, SOQL, Salesforce.com

Confidential, NC

Sr.Informatica Developer

Responsibilities:

• Generated the data as per the Clients specifications using mappings and transformations.
• Configured Power Exchange to capture the changes to be processed on the source AS400 (DB2) & Oracle.
• Configured Real Time Power Exchange mappings to replicate source data into Stage
• Maintained Meta Data For Auditing, Logging and Error Handling.
• Involved in Debugging and Performance Tuning at various levels from sources to the mappings and to the Targets, session level and at workflow levels.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Involved in running and scheduling UNIX Shell scripts, Informatica jobs.
• Design and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Meet the SLA at all times and improved the Performance of loading data from Key Data sources
• Maintained facts and Dimensions using Star Schema and Snowflake Schema.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Coordinated with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.5, Teradata, Flat files, Oracle 11, CDC, DB2, AS400.

Confidential, MA

Informatica Developer/Database Developer

Responsibilities:

• Generated the data as per the Clients specifications using mappings and transformations.
• Implemented a process for Generating Dynamic Parameters file.
• Maintained Meta Data For Auditing, Logging and Error Handling.
• Involved in running and scheduling UNIX Shell scripts, Informatica jobs using Tidal.
• Meet the SLA at all times and improved the Performance of loading data from Key Data sources
• Maintained facts and Dimensions using Star Schema and Snowflake Schema.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Wrote TSql Procedures for Incremental Loads in SQL Server.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Coordinated with campaign and reporting team for the change requests and availability of Data
• Coordinated with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives

Environment: Informatica PowerCenter 8.6.1, TOAD Flat files, TIDAL ENTERPRSIE Scheduler 5.3.1 CItrix Web Interface, MS SQL Server 2008, Tortoise CVS, power designer,.NET.

Confidential, MA

Informatica Developer/Database Developer

Responsibilities:

• Identify unique consumers utilizing Confidential ’s best in class Customer Data Integration (“CDI”) processing
• Manage consumer-level communication ps (opt-in/out, products of interest, communication frequency p, etc.) and serve as the centralized opt in/out repository
• Track outbound activity and related responses
• Include 3rd party response data
• Track P Center consumer interactions (opt-in/out, registrations, sweepstakes entries, profile updates, etc.)
• Store web/online purchase data for Burt’s Bees consumers
• Include engagement level data such as ratings and reviews from Bazaar Voice
• Involved in Meta Data Management For Auditing, Logging and Error Handling.
• Involved in Debugging and Performance Tuning at various levels from sources to the mappings and to the Targets, session level and at workflow levels.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Involved in running and scheduling UNIX Shell scripts, Informatica jobs using Tidal.
• Maintained facts and Dimensions using Star Schema and Snowflake Schema.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Wrote TSql Procedures for Incremental Loads in SQL Server.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Coordinated with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives

Environment: Informatica PowerCenter 8.6.1, TOAD Flat files, TIDAL ENTERPRSIE Scheduler 5.3.1 CItrix Web Interface, MS SQL Server 2008, Tortoise CVS.

Confidential, MA

ETL Informatica consultant

Responsibilities:

• Implemented a mapping for Generating Dynamic Parameters
• Maintained Meta Data Management for Generation of Parameters
• Automation of Informatica Jobs using Tidal
• Coordinated with all the Urban Team Members for ETL Automation and created dependencies
• Generated the data as per the Clients specifications using mappings and transformations.
• Involved in Debugging and Performance Tuning at various levels from sources to the mappings and to the Targets, session level and at workflow levels.
• Generated the reports as per the Clients specifications using SSRS.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Involved in running and scheduling UNIX Shell scripts using Tidal.
• Design and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Maintained facts and Dimensions using Star Schema and Snowflake Schema.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Coordinated with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives

Environment: Informatica PowerCenter 8.6.1, Microsoft SQL Server Reporting Services 10.0.2531.0 (SSRS), TOAD for ORACLE version 9.6.1.1 TIDAL ENTERPRSIE Scheduler 5.3.1 CItrix Web Interface, MS SQL Server 2008/2005

Confidential

ETL Informatica consultant

Responsibilities:

• Involved in designing and building data marts for provider division.
• Loaded data to the stage tables in oracle from multiple data sources using informatica.
• Designed data transformation from staging to fact and dimension tables in the warehouse.
• Implemented aggregate, filter, join, expression, lookup and update strategy transformations.
• Implemented variables and parameters in transformations for incremental data extraction and complex transformation logic.
• Created mappings between source and target using Informatica power center designer.
• Used mapping and mapplet designer to generate different mappings for different loads.
• Created transformations like source qualifier, joiner transformation, filter, update strategy, lookup transformation, rank transformations, expressions, aggregator and sequence generator to load the data from staging area to ODS and to DW in oracle.
• Created, scheduled and monitored sessions and batch process based on demand and run only once using Informatica server manager.

Environment: Informatica PowerCenter 7.1, Oracle 9i, Windows 2003 Server.