SUMMARY:

• Over 6 years of IT experience with strong expertise in design, development and implementation of software applications in Data Warehousing using Informatica PowerCenter 9.1/8.6/ 8.1.1.
• Strong experience in designing, creating of mapping documents for data loading into Data Warehouse.
• Proficient Knowledge in Informatica Power Center tools like Designer, Workflow Manager, Workflow Monitor and Repository Manager for migrating.
• Expertise in implementing complex Business rules by creating robust Mappings / Mapplets, reusable Transformations and Tasks.
• Experience in creating Complex workflows and Worklets using Informatica 9.x & 8.x.
• Implemented Slowly Changing dimensions Type1, Type2 & Type 3 methodology for accessing the current snapshot and full history.
• Experience with SQL Developer as an interface to databases, to analyze, view and alter data.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions and Package.
• Team Player with the ability to communicate effectively at all levels of the development process
• Exceptional analytical and problem solving skills.
• Experienced in Full Life Cycle Development of building applications including analysis, design, development, testing and documentation.
• Extensive experience in Extraction, Transformation and data loading from different heterogeneous source like Oracle, SQL Server, Flat files & XML files.
• Flexible and Versatile can adapt to any new environment and learn fast with excellent communication, interpersonal skills, analytical and problem solving skills.
• Extensive experience in UNIX and shell scripting.
• Extensive experience in Autosys tool for scheduling jobs

TECHNICAL SKILLS:

Operating Systems: Windows 2008/XP, Unix, Linux

ETL Tools: Informatica 9.x, 8.x

Packages: SQL* PLUS, Toad 7.x

Applications: MS Word, Excel and PowerPoint

Web technologies: HTML

Data Bases: Oracle, MS SQL Server

Languages: SQL, Pl/SQL, Unix Shell Scripting

Testing Tools: HP Quality Center

Scheduling Tools: AutoSys

PROFESSIONAL EXPERIENCE:

Confidential, Exton, PA

Informatica ETL Developer

Roles & Responsibilities:

• Involved in client meetings for the development and implementation of the business requirement.
• Preparing the Technical specification document for the mappings, jobs and their reviews.
• Designed and developed the mappings to move the data from the source systems and populate the data tables in the Oracle 11g database.
• Prepared the mapping documents which will represent the mapping rules and business logic.
• Used different type of transformations to implement the business requirement logic correctly.
• Used Workflow Manger, Workflow Monitor to test the mapping in DEV before migrating to different environments.
• Prepared the Test cases and Unit Test plans for the mappings.
• Daily monitoring the scheduled jobs using Autosys.
• Finding the reason for any failure of the jobs and alert the respective teams.
• Maintaining the supporting document for the failure and reviews for the action plans.
• Prepare the required unit test cases for assigned modules.
• Self Review of Unit test cases, Integration test cases of all the assigned modules.
• Do the detailed unit/integration testing.
• Peer to Peer Review of Test Cases.

Environment: Informatica Power Center 9.6.1, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader

Confidential, Wilmington, Delaware

Informatica ETL Developer

Roles & Responsibilities:

• Developed various Mappings with the collection of all Sources, Targets, and Transformations using Designer.
• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Worked extensively with mappings using expressions, aggregators, filters, lookup and stored procedures transformations.
• Partitioned sources to improve session performance.
• Designed and built Data Marts for home and business insurance divisions.
• Migrated the Metadata changes to the Informatica Repository.
• Taking the Backup of Repository on regular intervals depending on the amount of work done.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader and PL/SQL.

Environment: Informatica Power Center 9.1.0, Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader

Confidential, Edison, NJ

Informatica ETL Developer

Roles & Responsibilities:

• Involved in gathering requirements and translating to technical specifications.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Wrote stored procedures, functions, and packages in Oracle PL/SQL along with Informatica ETLs to address data warehousing needs.
• Implemented Oracle partitions to organize data for performance.
• Created Oracle bitmap indexes.
• Involved in star schema modeling and ETL architecture for data warehouse.
• Addressed capacity planning needs and frequent database and ETL tuning requirements.
• Interacting with QA team for testing.
• Worked with the other development team.
• Created mappings to move from Various Systems (CRM, OLTP) to Transaction History database (Reporting Database).
• Used pmcmd command for running Informatica through UNIX shell script and automated using scheduler tools.
• Responsible for creating business solutions for Incremental and Full loads.

Environment: SCO UNIX, Informatica Power Center 8.1.0, Oracle 10g, SQL*Plus, TOAD 8.6.1

Confidential, Edison, NJ

Jr Informatica ETL Developer

Roles & Responsibilities:

• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.
• Used Informatica PowerCenter 6.2 for migrating data from various OLTP servers/databases to the data mart.
• The data migration included identifying various databases where the information/data lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Used relational sources and flat files to populate the data mart.
• Translated the business processes into Informatica mappings for building the data mart.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Used Debugger to test the mappings and fix the bugs.

Environment: Windows 2000, Informatica PowerCenter 8.1.0, Oracle 9i, SQL*Plus, TOAD.

Confidential, Santa Clara, CA

Jr Informatica ETL Developer

Roles & Responsibilities:

• Business Requirements gathering and analysis provided by the client, preparation of functional specifications and design documents.
• Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Informatica Repository Manager and Workflow Manager.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: Windows 2000, Informatica PowerCenter 8.1.0, Oracle 9i, SQL*Plus, TOAD.