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 teh 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, DB2, MS Access 2000, TOAD

Reporting Tool: Cognos 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, IL

Sr ETL/Informatica Consultant

Responsibilities:

• Extensively worked on fine tuning teh existing ETL process and jobs.
• Reading and processing teh xml messages from teh Middleware WebSphere Message Queues in real-time
• Partitioning teh informatica sessions.
• Worked on Push Down Optimization (PDO), to push teh pipeline transformations logic to oracle database using various PDO Techniques.
• Configuring teh workflows and sessions to run on Informatica Grid Environment.

Environment: Informatica Power Center 9.5.1, Oracle 11g,Websphre MQ 7.5.1, UNIX, Windows, HP ALM, Windows XP, Shell scripting, JSS Scheduling Tool

Confidential, OH

Sr ETL/Informatica 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 teh 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 teh data into teh 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 teh Code from Informatica Power center 8.6.1 to 9.5.1.
• Involved in Folder Migrations from one environment to teh other environments.
• Uploading/downloading teh 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 teh 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 teh parameters
• Developed Parameter files for passing values to teh mappings for each type of client
• Worked with Connected look up and unconnected lookup and configured teh same for implementing complex logic
• Developed mappings and workflows by reading teh data from one database and loading teh data to another database
• Responsible for developing teh Jobsets, installing teh jobsets in CA scheduling tool
• Responsible for running teh jobs from CA Scheduling tool in Dev
• Responsible for checking in teh code to Tortoise SVN
• Responsible for monitoring teh jobs while deploying to other testing environments like SIT, UAT, PERF
• Responsible for updating teh cycle scope documents before start of a test cycle
• Responsible for understanding teh Abinitio graphs and implement teh 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 teh jobs and running teh validations in testing environments
• Involved in PROD release and running teh 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 teh dependency at teh 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

Sr ETL/Informatica Consultant

Responsibilities:

• Involved in Analyzing teh 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 teh 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 teh 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 teh 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 teh observations and defects raised by teh 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 teh Code from Informatica Power center 8.6.1 to 9.1.0.
• Involved in Folder Migrations from one environment to teh other environments.
• Performed extensive Unit Testing on teh developed Mappings and was also involved in teh documentation of Test Plans and testing with teh users (UAT)
• Conducting weekly status meetings to discuss about teh progress in that week.

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

Confidential

Informatica Developer

Responsibilities:

• Involved in analyzing teh 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 teh 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 teh requirements.
• Designed and developed Informatica Mappings to load data from Source Systems to EDH (Enterprise Data Hub) and tan to Data Marts.
• Involved in Mapping, Session and database level optimization techniques to improve teh performance
• Worked on Unix shell scripts used in scheduling Informatica pre/post session operations
• Involved in creating complex workflows which utilize teh 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 teh Workflows.
• Tested all teh mappings and sessions in Development environment.

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

Confidential

Informatica Developer

Responsibilities:

• Involved in Analyzing teh 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 teh 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 teh progress in that week.
• Creating job setup document for job scheduling tool.
• Given Technical clarifications and assigned work to off-shore team and monitored teh 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 teh scripts needed for teh business specifications (BTEQ Scripts).
• Involved in tuning of SQL Queries by identifying and rectifying performance bottlenecks.
• Worked on WLM to automate and Schedule teh Workflows and jobs.
• Tested all teh 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 teh Integration service in Power Center 8.6 to start multiple instances of teh same workflow.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Created Data Breakpoints & Error Breakpoints for debugging teh 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 teh Workflows.
• Tested all teh 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 teh 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 tan 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 teh mappings using various components like Parameter files and Variables
• Integrated teh new and existing tasks and tan 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 teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mappings.
• Developed various Mapplets, Transformations and was responsible for Validating and Fine-Tuning teh ETL logic coded into mappings to improve Data Quality.
• Responsible for validating teh Informatica mappings against teh pre-defined ETL design standards.
• Performed extensive Unit Testing on teh developed Mappings and was also involved in teh documentation of Test Plans and testing with teh 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 teh 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 teh Star schema and populating teh fact tables.
• Utilized DB2 loaders (i.e.) load replace, load append to feed teh data into teh targets.
• Involved in identifying bugs in teh 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 teh sessions
• Coordinated with Developers, Testing team and DBA for teh System testing and Performance testing.
• Have used Autosys Scheduler to schedule workflows and automate sessions in teh workflow manager.
• Creating Low level documents for creating maps to load teh data from teh ODS through teh warehouse.

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