PROFESSIONAL SUMMARY:

• About 10 years of Information Technology Experience in Data Warehouse using Tools like Informatica Power Center 9.5/9.1/ 8.6.1/8.1.1 /7. x/6.x/5.x.
• Extensive experience in Insurance, Banking & Financial Services (BFS), Retail, Pharmacy and Healthcare Domains
• Good experience in Full Life Cycle Implementation of applications on multi - platforms.
• Data Processing experience in designing and implementing Data Mart applications using ETL tool and developed ETL mappings and ETL workflows and also monitoring the Production Environment.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Well versed in Extracting, Transforming and Loading (ETL) from different Source systems to Warehouse System.
• Experienced in configuring Nodes and Repositories in Informatica Power Center 9.5/9.1/8.6/8.1.1
• Experienced with ETL tools like Informatica
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping, Session and System in ETL Process
• Creating Triggers and stored Procedures using SQL PL/SQL
• Conducted System, UAT and Functionality testing and investigated software bugs.
• Worked on UNIX shell scripts used in scheduling Informatica pre/post session operations
• Worked with wide variety of sources like Oracle, MSSQL, Sybase, Flat Files, DB2
• Worked with Oracle Stored Procedures, Triggers, Cursors and Indexes and experienced in loading data into Data Warehouse/Data Marts.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5.1/9.1/8. X/7.x/6.2/5.1

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical/Logical Data Modeling

Databases: Sybase 15, Oracle 11g/10g/9i/8i, SQL Server 2000/05/08, DB2MS Access 2000, TOAD

Reporting Tool: Cogno s and Hyperion Brio.

Testing Tools: Test Director, Rational Clear Quest, HP Quality Center

Programming: C, C++, SQL, PL/SQL, HTML, and XML

Environment: Windows98/2000/XP/2003, WinNT4.0, UNIX,Linux

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

ETL/Informatica Lead Consultant

Responsibilities:

• Prepared TSD and ETL Specification documents based on BSD and Mapping document.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor
• Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement the business logic.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner.
• Extensively worked with flat file sources to read data and write the data into the flat files.
• Created Informatica mappings with PLSQL Procedures, Functions to build business rules to load data.
• Worked on Unix shell scripts used in scheduling Informatica pre/post session operations
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Migrated the Code from Informatica Power center 8.6.1 to 9.5.1.
• Involved in Folder Migrations from one environment to the other environments.
• Uploading/downloading the documents to/from sub version
• Extensively worked with various Active transformation like Filter, Sorter, Aggregator, Router, Lookup, Joiner and Update Strategy transformations
• Extensively worked with various Passive transformations like Expression, Sequence Generator, Mapplet Input and Mapplet Output transformations.
• Developed different mappings, workflows for code rewrite from Abinitio to Informatica like Client rewrite, Phone Address Load rewrite, Email Address Load rewrite, Deloitte Extracts Loads and B1B
• Responsible for migrating the jobs from Informatica 8.6 to 9.5 and testing them
• Developed generic mappings and workflows for loading different types of client data by passing the parameters
• Developed Parameter files for passing values to the mappings for each type of client
• Worked with Connected look up and unconnected lookup and configured the same for implementing complex logic
• Developed mappings and workflows by reading the data from one database and loading the data to another database
• Responsible for developing the Jobsets, installing the jobsets in CA scheduling tool
• Responsible for running the jobs from CA Scheduling tool in Dev
• Responsible for checking in the code to Tortoise SVN
• Responsible for monitoring the jobs while deploying to other testing environments like SIT, UAT, PERF
• Responsible for updating the cycle scope documents before start of a test cycle
• Responsible for understanding the Abinitio graphs and implement the logic in Informatica
• Worked with flat files like fixed and de-limited
• Worked extensively with update strategy transformation for implementing inserts, updates and deletes
• Developed test cases, conducted unit tests, monitoring the jobs and running the validations in testing environments
• Involved in PROD release and running the validations in PROD
• Hands on experience on memory management and pipeline partitioning of workflow for better performance.
• Created Mapplets and used them in different Mappings.
• Created various Job Sets in CA Scheduling tool and defined the dependency at the Job Set and Job Levels.

Environment: Informatica Power Center 9.5.1, Sybase 12.5, UNIX, Windows XP, Tortoise SVN 1.6.15, Windows XP, DB Artisan 9.0, Shell scripting, CA Scheduling Tool

Confidential, Mc Lean, VA

ETL/Informatica Lead Consultant

Responsibilities:

• Involved in Analyzing the requirements & Involved in designing and development of Complex Solutions.
• Prepared TSD and ETL Specification documents based on BSD and Mapping document.
• Conducted walk through on TSD internally with the development team and also externally with client technical leads, team leads and Data Architects and DBAs.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor
• Used various Transformations like Joiner, Aggregate, Java, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement the business logic.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner.
• Created Informatica mappings with PLSQL Procedures, Functions to build business rules to load data.
• Developed SCD Type2 Mappings to track the Change Data Capture (CDC)
• Prepared SDLC Document and conducted walk through while moving from Development to Test and Test to Integration Test environments and so forth.
• Co-ordinate with testing team in providing explanations and resolutions to the observations and defects raised by the testers.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Creating job setup document for job scheduling tool.
• Worked on Unix shell scripts used in scheduling Informatica pre/post session operations
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Migrated the Code from Informatica Power center 8.6.1 to 9.1.0.
• Involved in Folder Migrations from one environment to the other environments.
• Performed extensive Unit Testing on the developed Mappings and was also involved in the documentation of Test Plans and testing with the users (UAT)
• Conducting weekly status meetings to discuss about the progress in that week.

Environment: Informatica Power Center 9.1.0/8.6, Oracle 11g/9i, TOAD, Cogno’s 8, UNIX, Windows XP

Confidential

Senior ETL/Informatica Consultant

Responsibilities:

• Involved in analyzing the requirements, designing and development of data warehouse environment.
• Preparing TSD and ETL Specs based on BSD and Mapping document.
• Conducting walk through on TSD with client tech leads, team leads and Data Architects and DBAs.
• Prepared SDLC Work book and conducted walk through before moving to SIT, UAT and Production.
• Conducting weekly status meetings to discuss about the progress in that week.
• Creating job setup document for job scheduling tool.
• Given Technical clarifications and assigned work to off-shore team and monitored their work status daily.
• Worked on Informatica tools like Power Center Designer, Workflow Manager, and Workflow Monitor.
• Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logics while coding a Mapping.
• Developed Informatica Type-1 and Type-2 Mappings based on the requirements.
• Designed and developed Informatica Mappings to load data from Source Systems to EDH (Enterprise Data Hub) and then to Data Marts.
• Involved in Mapping, Session and database level optimization techniques to improve the performance
• Worked on Unix shell scripts used in scheduling Informatica pre/post session operations
• Involved in creating complex workflows which utilize the various tasks like Event Wait, Command, Mail decision and session tasks.
• Extracted data from Flat files and Oracle and loaded them into Oracle.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Worked on WLM Scheduler to automate the Workflows.
• Tested all the mappings and sessions in Development environment.

Environment: Informatica Power Center 8.6.1, Oracle 11g/10g, DB2, WLM, UNIX, Windows XP

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in Analyzing the System requirements, implementation of star schema & Involved in designing and development of data warehouse environment.
• Preparing TSD and ETL Specs based on BSD and Mapping document.
• Conducting walk through on TSD with client tech leads, team leads and Data Archs and DBAs
• Involved in development of the Code and executed Unit Test Cases.
• Prepared SDLC Work book and conducted walk through before moving to SIT, UAT and Production.
• Conducting weekly status meetings to discuss about the progress in that week.
• Creating job setup document for job scheduling tool.
• Given Technical clarifications and assigned work to off-shore team and monitored the work status daily.
• Worked on Informatica tools like Repository Manager, Workflow Manager and Workflow Monitor.
• Extracted data from Flat files, SQL Server and Oracle and loaded them into Oracle.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Worked with complex SQL queries for data validation and reporting in SQL Assistant.
• Written the scripts needed for the business specifications (BTEQ Scripts).
• Involved in tuning of SQL Queries by identifying and rectifying performance bottlenecks.
• Worked on WLM to automate and Schedule the Workflows and jobs.
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production environment after everything went successful.

Environment: Informatica Power Center 8.6.1/8.1.1, SQL Server 2008, Oracle 10g/9i, TOAD, WLM (Work Load Manager), UNIX AIX, Windows XP.

Confidential

Informatica Developer

Responsibilities:

• Working on Informatica tools like Source Analyzer, Mapping Designer, Target Designer, Workflow Manager, and Workflow Monitor.
• Used various Transformations like Joiner, Aggregate, Java, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logics while coding a Mapping.
• Involved in Data Profiling & Analysis on heterogeneous Databases Oracle, SQL Server, flat files.
• Used the Integration service in Power Center 8.6 to start multiple instances of the same workflow.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Created Data Breakpoints & Error Breakpoints for debugging the mappings using Debugger Wizard.
• Worked with complex queries for data validation and reporting using SQL and PL/SQL.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Worked on Autosys Scheduler to automate the Workflows.
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production environment after everything went successful.

Environment: Informatica Power Center 8.1.1, SQL Server2008, Oracle 11g/9i, DB2 8.x, PL/SQL, TOAD, Autosys Scheduler, Windows 2003 Server.

Confidential

Informatica Developer

Responsibilities:

• Responsible for analyzing the Existing Source System, Data nature, Business roles and Involved in Requirement gathering from various business and application experts.
• Extracted data from Sources like Oracle, XML,Flat Files.
• Designed and developed Informatica Mappings to load data from Source Systems to EDH (Enterprise Data Hub) and then to Data Marts.
• Created Complex mappings using Connected & Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating into target table
• Developed (or edited existing) Informatica mappings and sessions to accomplish Data Migrations.
• Involved in Performance Tuning of the mappings using various components like Parameter files and Variables
• Integrated the new and existing tasks and then scheduled jobs using Autosys.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.
• Created Informatica mappings with PLSQL Procedures, Functions to build business rules to load data.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Developed various Mapplets, Transformations and was responsible for Validating and Fine-Tuning the ETL logic coded into mappings to improve Data Quality.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Performed extensive Unit Testing on the developed Mappings and was also involved in the documentation of Test Plans and testing with the users (UAT).

Environment: Informatica Power Center 8.1.1/7.1.4, Oracle 10g, SQL Server 2005, Autosys, TOAD, LINUX, Windows 2003.

Confidential

Informatica Developer

Responsibilities:

• Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
• Worked extensively on Informatica Designer, Workflow Manager and Workflow Monitor.
• Loaded data from OLTP Tables (which are in DB2 Database) to Staging table (ORACLE database) and Staging table to OLAP Tables (ORACLE tables).
• Involved in designing the Star schema and populating the fact tables.
• Utilized DB2 loaders (i.e.) load replace, load append to feed the data into the targets.
• Involved in identifying bugs in the business logic using Debugger.
• Involved in designing and development of pre and post session routines and batch execution routines.
• Implemented Performance tuning by utilizing dynamic cache for Lookups, partitioning the sessions
• Coordinated with Developers, Testing team and DBA for the System testing and Performance testing.
• Have used Autosys Scheduler to schedule workflows and automate sessions in the workflow manager.
• Creating Low level documents for creating maps to load the data from the ODS through the warehouse.

Environment: Erwin, Informatica Power Center 7.1, SQL Server 2005, DB2, Autosys, Flat files, TOAD, Oracle 10g, UNIX and Windows 2003.