SUMMARY:

• Overall 8+ years of IT experience in ETL development that includes Data Extraction, Data Migration, Data Transformation and loading using Informatica tools.
• Extensive experience in Data Warehousing, ETL (Extraction, Transformation, Loading) using Informatica.
• Good understanding of Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inman Snowflake schema methodology.
• Strong experience in Extraction, Transformation, Loading (ETL) of data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor).
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• 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 and Flat files.
• Experience in SQL, PL/SQL and UNIX shell scripting.
• Strong working knowledge of full Software Development Life Cycle (SDLC) processes involving Application Development and ETL/OLAP Processes.
• Good understanding of Business Intelligence, data modeling and Data Warehousing Concepts with emphasis on ETL and SDLC methodologies.
• Working knowledge of Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, Indexes, 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 teams, 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
• Strong analytical skills with ability to multi task.

TECHNICAL SKILLS:

Operating Systems: Windows 7/2003/2008, Unix, AIX

Tools: Informatica Power Center 8.6.1/9.1.0, Erwin, Cognos 10.1, HP Quality Center, AUTOSYS, Control-M

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

Domain: Banking, Healthcare and Web based applications.

PROFESSIONAL EXPERIENCE:

Confidential, Irving TX

Sr. ETL/Informatica Developer

Responsibilities:

• Primarily responsible to convert business requirements into system design.
• Communicate with the Business Analyst and Data Analyst to fully understand requirements, provide feedback, and request clarification, as needed.
• Review and interpret requirements, data and data models.
• Used Informatica Designer tools to design the source definition, target definition and transformations to build mappings.
• Conduct ETL design reviews with the Business Analyst, Data Analyst and DBA to ensure that code meets performance requirements
• Developed the code per tech design by creating mappings using the transformations such as Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Extensively used ETL to load data from sources such as flat files, XML to Oracle
• Monitored Workflows and Sessions using Workflow Monitor
• Used Debugger in troubleshooting the mappings
• Perform DIT testing, coordinate with testing team for SIT and UAT in terms of help create test scenarios, prepare mock up data, run jobs and address defects.
• Make code ready for implementation following configuration and change management processes
• Load the project data elements into the Project Data Central (an internal data elements and Meta data repository).
• Work with Production control team for job scheduling.
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Perform production check out, communicate to the project team, and help business validate data.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experienced inUNIXwork environment,file transfers,job schedulingand error handling.
• Developedshell scriptsfor Daily and weekly Loads.
• Prepare documentation for all mappings and workflows developed/modified as part of the project.

Environment: Informatica Power Center, UNIX, Oracle 11g, SQL Developer, HP Quality Center,Cognos.

Confidential, Thousand Oaks, CA

Sr. ETL (DW) Developer

Responsibilities:

• Interaction with Business and Operations teams for converting the business requirements into proper technical solutions.
• Analysis of data feeds and understanding data relationships.
• Work closely with Domain SMEs and tech leads to get the right data and fix data issues.
• Extraction, Transformation and Loading of the data using Informatica power center.
• Design the target load process based on the requirement and design documents.
• Enhancing the existing mappings per tech design.
• Develop Mappings and Workflows to Import source definitions, load the data into Oracle tables, generate staging files.
• Unit Testing and debugging the Enhanced mappings.
• Develop various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, tasks, events using Workflow Manager.
• Created sessions and batches to move data at specific intervals & on demand using Server Manager.
• Load the project data elements into the Project Data Central (an internal data elements and Meta data repository).
• Responsibilities include creating the sessions and scheduling the sessions.
• Recovering the failed Sessions and Batches.
• Data analysis, validation and testing.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experienced inUNIXwork environment,file transfers,job schedulingand error handling.
• Developedshell scriptsfor Daily and weekly Loads.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Preparing the documents for test data loading and help testing team for SIT testing.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Ensure metadata repository is accurate and updated regularly.

Environment: Informatica Power Center 8.6.1, Oracle 11g, SQL, TOAD, UNIX Flat Files, Windows XP, Agile, IBM Mainframe.

Confidential, Fort Worth, TX

Informatica Developer

Responsibilities:

• Created Technical Design Specifications, Unit test document based on functional design specifications provided by Business Analyst
• Designed and developed ETL Processes based on business rules, job control mechanism using Informatica Power Center.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, Lookup, update strategy, stored procedure transformations, etc.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Re-engineered some of the existing mappings to support new/changing business requirements.
• Monitored production jobs on a daily basis and worked on issues relating to the job failure and restarted failed jobs after correcting the errors.
• Developed reusable transformations, mapplets, sessions, work lets to make code very modular and reuse as required
• Used mapping variables, parameters, workflow variables & parameter files to support change data capture and automate workflow execution process to provide 24x7 available data processing.
• Involved in writing UNIX shell scripts (Pre/Post Session commands) for the Sessions & wrote shell scripts to kickoff workflows, unscheduled workflows, get status of workflows.
• Performed Informatica administration like user, privileges, migrations, starting, stopping pmrep /PMserver, Backup and restore repository service.
• Performed unit testing, system integration testing, and supported user acceptance testing.
• Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data loading to meet defined SLA.
• Compared actual results to expected results and suggested changes to mappings owned by others.
• Supported Informatica code migration between environments (DEV/QA/PRD)
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.

Environment: Informatica Power Center 8.1, PL/SQL, Oracle10g, Control-M, SQL Server 2008, DB2, Agile, UNIX

Confidential, Pleasanton, CA

Informatica Consultant

Responsibilities:

• Developed various kinds of mappings by using different transformations like Source Qualifier, Expression, Filter, Router, Lookup, and Update Strategy for populating target table in efficient manner.
• Written SQL overrides in Lookup Transformation to fetch according to business requirements.
• Supported over 350 mappings for enhancements and issues. The scope includes projects from different domains like Marketing Analytics data used for campaigns, Document Management System.
• Used Oracle, SQL Server, Flat Files as sources and SQL Server 2008 as target.
• Understood complex business requirements and converted them into technical requirements.
• Involved in all phases of SDLC - requirement gathering, design, development, testing and implementation and post-production support.
• Collaborated with business, technical architect groups, development teams, unit testing and QA teams to ensure that the business requirements are implemented correctly.
• Responsible for Informatica code deployment/migration from development to production.
• Analyzed Mapping, session and system bottlenecks to improve performance of various ETL jobs.
• Provided post-production support and prepare support documents.
• Authored and maintained all technical documentation.
• Participated in the project status meeting and providing weekly status.
• Liaised with production team to analyze bugs and resolve issues.
• Established best practices standards and ensured adherence to them.

Environment: Power Center 7.5, MS-SQL Server 2008, SQL, PL/SQL, Teradata, ORACLE, DB2, UNIX scripting

Confidential, Florida

ETL / Backend Test Engineer

Responsibilities:

• Analyze the test requirements based on the business requirements and application functionality.
• Reviewed Test Plan and Test script review meetings with stake holders and 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 Quality Center.
• Involved in developing and executing the test scripts using Quality Center.
• 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 to generate Requirements, Test Sets, and Test Plan and for reporting defects.
• Executed test cases before and after bug fixes for each build for User acceptance testing.

Environment: Informatica Power Center 9.1 Power Connect, Teradata, HP Quality Center 9.2, TOAD, Oracle.

Confidential, Plano, 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 to generate 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 to prioritize the defect fix and update the status once they are fixed.
• Executed test cases before and after the fix for each build for User acceptance testing.

Environment: Informatica Power Center 8.6.1, Teradata, HP Quality Center, JAVA, TOAD, PL/SQL, SQL Server 2005.