SUMMARY

• Around 7+ years IT experience with 6 years extensive experience in ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica tools
• Good understanding of Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inman Snow Flake schema methodology.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor).
• Strong understanding of OLAP and OLTP Concepts
• Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like oracle 11g/10g, SQL Server 2008, DB2 10, Flat files.
• Experience in SQL, PL/SQL and UNIX shell scripting.
• Worked with Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
• Strong experience on understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and SDLC (Software Development Lifecycle), Quality analysis.
• Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes with Query optimizations as part of ETL Development process.
• Adept in UNIX operating system commands & Shell Scripting.
• Experienced in Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.
• Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development.
• Strong decision - making and interpersonal skills with result oriented dedication towards goals.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure

TECHNICAL SKILLS

Operating Systems: Windows XP/2000/NT, Unix, AIX

Data Warehousing Tools /ETL: Informatica Power Center 8.6.1/9.1.0

Databases: Oracle 10g/11g, MS SQL Server 2008

Operating Systems: Unix, Windows NT and Windows 2003/XP, Windows 7, Windows Vista, Mainframe

Domain: Telecom, Banking/Insuranceand Web based applications.

PROFESSIONAL EXPERIENCE

Confidential, Camp Hill, PA

Informatica Developer

Responsibilities:

• Business Analysis and Requirements Collection, Interacted with the Users and Business Analysts to gather the requirements.
• Involved in design and developing the ETL code to load large amounts of data from other internal data sources to the system.
• Coordinated with the other vendor teams including infrastructure, operations database, and performance testing as well as release management.
• Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manager). Worked extensively on Informatica transformations like Source Qualifier, Expression Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence Generator, Joiner, XML and Union.
• Informatica mapping and workflow development using all functionality available in the Designer and Workflow Management tools.
• Analyze and document data mapping and business transformation rules as implemented in Informatica.
• Develop ETL scripts and conduct regression testing using Informatica scripts.
• Creating and validating mechanisms for the data, from Source to Target flow.
• Analyzed Informatica ETL Technical Issue/Defect Raised by Business.
• Experience in database development using SQL and PL/SQL.
• UNIX scripting experience.
• Leading the ETL team to resolve any problems in the Informatica mappings and creating workflows based on the requirements.
• Conducted Knowledge Transition meetings to the new people on board.

Environment: Oracle11i,Informatica 9.1, Cognos 8.1, windows XP, Unix

Confidential, King Of Prussia, PA

Informatica Developer

Responsibilities:

• Involved in detailed analysis of requirements and creation of requirement specifications and functional specifications.
• Analyzed business requirements and worked closely with various application teams and business
• Develop ETL procedures that are consistent across all application and systems.
• Involved in Creating Fact and Dimension tables using Star schema
• Built Repositories using Informatica Power Center Repository Manager to store Source, Target, Transformations, Mapplets and Mappings Meta Data Information.
• Worked on Informatica tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed various Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Power Center Designer.
• Extracting and loading of data from flat file, Oracle sources to oracle database (target warehouse) using transformations in the mappings.
• Created Informatica mappings with SQL, PL/SQL procedures and Functions to build business rules to load data.
• Wrote shell scripts and control files to load data into staging tables and then into Oracle base tables using SQL*Loader.
• Performed tuning of sessions in Target, Source, Mappings and Session areas.
• The result of sessions has been track through log files using session manager.

Environment: CRM Siebel 8.1.1.10, AIX 6.1, Oracle 11g, Informatica 9.1.0/ 8.1.1

Confidential, Ashburn, VA

Informatica Developer

Responsibilities:

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where in the changes was made to the existing mappings.
• Testing and debugging the Enhanced mappings.
• Creating the ETL run book.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Importing source definitions from.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Created sessions and batches to move data Confidential specific intervals & on demand using Server Manager
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Involving in extracting the data from Oracle and Flat files
• Responsible for identifying the missed records in different stages from source to target and resolving the issues.
• Extensively worked in the performance tuning for mappings and ETL procedures both Confidential mapping and session level.
• Repository administration like creating folders and grant access to other users.
• Developing, Testing and debugging the mappings in informatica.
• Data validation testing.
• Preparing the documents for test data loading

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, PL/SQL,TOAD, DB2 10, Flat Files, Windows XP, Unix Sun Solaris 2.6, F-Secure, SSH

Confidential, Atlanta, GA

ETL/Backend Test Engineer

Responsibilities:

• Analyze the Test Requirements based on the business requirementsand Application Functionality.
• Scheduled Test Plan and Test script review meetings with the clients and reviewed the test plan document and make sure the test plan has met the requirements in the Functional Design Document
• Report the bugs, E-mail notifications to the developers using the Rational Clear Quest.
• Involved in developing and executing the test scripts using Mercury Quick Test Professional.
• Created and Executed SQL queries against the database to verify the backend data using TOAD.
• Executed PL/SQL scripts to ensure data integrity throughout the database.
• Generating the bug report and attending the Bug Review meeting with developers.
• Exported Test Requirements and Test Cases from Excel to Quality Center.
• Performed System testing and Integration testing.
• Used Quality Center for generating Requirements, Test Sets, and Test Plan and for reporting defects.
• Logged the defects in QC and retested the application after the defects are fixed.
• Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed.
• Executed test cases before and after bug fixes for each build for User acceptance testing.

Environment: Informatica Power Center 8.6.1 Power Connect, Confidential Quality Center 9.2, Rational Clear Quest, TOADQuick Test Professional 9.5,Oracle 9i, XML, SOAP, Web Services, IIS5.0, Windows 2000

Confidential, Houston, TX

ETL Tester

Responsibilities:

• Involved in Defining, and Analyzing the Test Requirements based on the Application Functionality.
• Involved in gathering business requirements, understanding the application.
• Tested the ETL mappings output with the back end by writing test cases and SQL test scripts.
• Performed backend testing by validating data between source and target by developing SQL scripts, and verifying stored procedures.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• End to end data validation, and functionality testing data warehouse projects using Informatics ETL, Oracle Database, and reports.
• Exported Test Requirements and Test Cases from Excel to Quality Center.
• Performed System testing and Integration testing.
• Used Quality Center for generating Requirements, Test Sets, and Test Plan and for reporting defects.
• Logged the defects in QC and retested the application after the defects are fixed.
• Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed.
• Executed test cases before and after bug fixes for each build for User acceptance testing.

Environment: Informatica Power Center 8.6.1 Power Connect, JAVA, TOAD, XML 1.0, PL/SQL, SQL Server 2008.