Summary:

• Over 7 years of experience in development of ETL process for extracting, transforming and loading data using ETL tool Informatica Power Center 8.x/7.x/6.x in various domains like Pharmaceuticals , Banking, Insurance and manufacturing industries.
• Proficiency working with Informatica Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Experience in integrating various data sources with Multiple Relational Databases like Oracle, DB2 and SQL Server,MS Excel, XML, COBOL and flat files like fixed length and delimited.
• Extensively worked with ODS and staging area to perform data cleansing, data profiling, data consolidating, and data standardization process.
• Extensive experience in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, scheduling the Workflows and sessions.
• Designed and developed complex mappings using various transformation logic like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Joiner, Union, Connected/Unconnected lookups, Update Strategy and Normalizer.
• Expert in implementing Type 1, Type 2 and Type 3 Slowly Changing Dimensions as per the business requirements to maintain full historical information.
• Implemented performance tuning of sessions by identifying bottlenecks in Sources, Targets & Mappings, Performed unit testing & used Debugger to debug the complex mappings and fix them.
• Developed UNIX shell scripts for automation of sessions as well used in command task to handle requirements like dropping and building indexes, flat file archiving/dropping process.
• Expert in RDBMS concepts, PL/SQL Stored Procedures, Functions and creating database objects like Tables, Indexes, Views, synonyms and sequences.
• Proficient in understanding Data warehouse concepts for Ralph Kimball & Bill Inmon Methodologies, Star Schema, Snowflake schema and Surrogate keys.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

Education: Bachelor of Engineering

Skill Set:
ETL Tool Informatica Power Center 8.x/7.x/6.x, Oracle 10g/9i/8i, DB2, SQL Server 2000/2005/2008, Teradata, MS SQL, SQL, PL/SQL, Toad ,SQL developer, SQL *Pus, XML, COBOL, SQL loader, Autosys scheduler, Unix Shell Scripting, Erwin 3.5/4.0, MS Office ,Operating Systems Windows, UNIX, and Linux

Project Summary:

Confidential,NJ
Sr. Informatica Developer
Pfizer Inc is the world's largest research based pharmaceutical company which discovers, develops and manufactures & markets the medicines for humans and animals, as well as consumer products.
The purpose of this project was to build sales data mart mainly to assist Sales and Marketing Department to calculate their market share in different segments based on geographical area and there by defining the strategy for each product segment.

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Extensively worked with staging area to perform data cleansing, data scrubbing, data filtering and data standardization process.
• Implemented code using various Informatica Transformations like Source qualifier, Joiner, Union, Expression, Lookup, Aggregate, Filter, Router, Normalizer, XML and Update Strategy.
• Developed SQL overrides in Source Qualifier and Lookup transformations according to business requirements.
• Used connected /Unconnected Lookup Transformation to lookup the values in Flat Files and relational sources and targets.
• Implemented Type 2 Slowly Changing Dimensions to maintain the historical data in sales data mart as per the business requirements.
• Implemented different Tasks in workflows which include Session, Command, E-mail, Event-Wait, Event - Raise, Timer etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets, Transformation and sessions by identifying and rectifying performance bottlenecks.
• Used stored procedures for creating & dropping the indexes before the session run to improve the session performance and rebuild them after completion of session.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduling them to run at specified time with required frequency.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Automation of job processing using Autosys scheduler, establishing automatic email notifications to the concerned persons by creating email tasks in workflow manager
• Tested all the mappings and sessions in Development environment and migrated into Production environment after everything went successful.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2008 ,Teradata, SQL Loader, Toad 8.5, Delimited Flat Files, SQL*Plus, PL/SQL ,UNIX Shell Scripts, Autosys, Solaris 5.8, Windows XP

Confidential,
Informatica Developer
Merrill Lynch is the wealth management division of Bank of America providing corporate finance & investment banking services.
The objective of the project was to build data Warehouse for Customer's Investment Deposit, funding accounts and Corporate Services. The data for Customers, Accounts and Transactional related information were extracted from multiple sources, transformed and loaded into the target database using ETL tool.

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.
• Experience in integration of heterogeneous data sources like Oracle, Sybase, Teradata, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 8.5 , Oracle 10g , SQL Server 2005 , DB2, Teradata ,SQL*Plus, SQL Loader ,SQL Developer, Autosys, COBOL files, Flat files, UNIX, Windows 2000

Confidential, CT
Informatica Developer
Xerox Corporation is the world's largest manufacturer of color & black-and-white multifunction, printer, copier, scanner and fax products and toners.
The entire goal of the project was to build sales data mart for their products and thereby keeping track on stock level & usage rate of Printers & Cartridge which was very useful for providing data for reports and Business intelligence.

Responsibilities:

• Interacted with Business Analyst and DBA to gather the Requirements and Business logics.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server , flat files, DB2 and load the data in to Oracle database
• Extensively worked on Informatica Power Center Designer (Source Analyzer, Warehouse designer, Transformation Developer, Mapping Designer and Mapplet Designer).
• Designed and developed complex mappings using different types of transformations like Source Qualifier, Expression, Aggregator, Joiner, Union, Sorter, Router, filter, Update strategy, and look up, stored procedure.
• Imported XML Source files to Designer, modified groups used in the Mappings and loaded into relational tables and some XML target files
• Involved in moving the Mappings, Sessions and Workflows between development and production environments.
• Written and modify SQL override in Source qualifier transformations in many mappings according to business requirements.
• Implemented Type 2 & Type 3 Slowly Changing Dimensions in mappings to maintain historical data as per the business requirements.
• Created workflows, worklets and scheduled the sessions according to Target Load order also scheduled the workflows for daily, weekly and monthly loads.
• Analyzing the Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Automation of job processing, establishing automatic email notifications to the concerned persons.

Environment: Informatica Power Center 7.1, Oracle 9i, DB2, MS SQL, SQL Server 2005, Flat files, Windows NT, UNIX, Toad, SQL*PLUS, Erwin 3.5,Putty

Confidential,
Informatica Consultant
AAAis a federation of 51 independently operated motor clubs throughout North America. AAA provides services to its members such as travel, automotive, insurance, financial, and discounts.
The Insurance data mart project was developed in an attempt to streamline the entire process of Insurance and to keep track of various financials on a daily, weekly, monthly basis.

Responsibilities:

• Co-ordinate with the Business Analysts and users to understand business and functional needs and implement the same into an ETL design document.
• Extensively worked on Informatica Power Center Designer (Source Analyzer, Warehouse designer, Transformation Developer, Mapping Designer and Mapplet Designer).
• Prepared high-level design specification document, Informatica Mapping specification documents for all the Transformations used in the project.
• Developed Informatica mappings using heterogeneous sources like flat files and different relational databases, Mapplets, Mappings using Power center Designer.
• Implemented Type 2 and Type 3 Slowly Changing Dimensions in mappings as per the business requirements.
• Developed and Implemented UNIX shell scripts through command task to handle requirements like dropping and building indexes, flat file archiving/dropping process etc.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Scheduled Workflows based on demand, run on time, run only once using Informatica Workflow Manager and shell scripts.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
• Extensively worked in the performance tuning for the mappings and ETL Procedures both at designer and session level.
• At session level tuned the mapping by setting the buffer size, cache size, increasing commit intervals.

Environment: Informatica Power Center 6.2, Oracle 9i, Flat files, SQL Server 2000, DB2, SQL *Plus, Windows 98, Sun Solaris, TOAD

Confidential,India
ETL / Informatica Developer
Airtelis a brand of telecommunication services in India. This Project was developed for building a data mart and OLAP reports for order management, strategic testing and tactical call center.
The Project was to extract the system data from order management system database (OLTP) and loading it into the target database to build data mart for historical information about Local, Long Distance, Voice Mail, and Pager Services.

Responsibilities:

• ETL was developed using Informatica to transform and load the data.
• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client toolsSource Analyzer, Warehouse designer, Mapping designer and Mapplet Designer.
• Extracted data form Flat files, Oracle database, DB2 and SQL SERVER and applied business logic to load them in the target database.
• Designed and developed complexmappings using source qualifier, Aggregate, expression, filter, join, Router, Lookup, sequence generator and Update strategy transformation rules.
• Developed schedules to automate the update processes andInformatica sessions and batches.
• Worked on sequential and parallel jobs to run multiple sessions concurrently and parallel to improve performance.
• Identified various bottlenecks and critical paths of data transformation in sessions.
• Migrated folders from development repository to QA repository.
• Created email tasks for reporting the status to entire group.

Environment: Informatica Power Center 6.1, Oracle 8i, SQL SERVER 2000, Flat files, DB2, SQL*Plus, Windows 95, UNIX