SUMMARY

• Over 8+ of years experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica PowerCenter.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience working with Agile, RUP, Scrum, Waterfall testing methodologies
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Strong business understanding knowledge of Financial and banking, Health Insurance, Manufacturing and Pharmaceutical Projects. Very good at bug - reporting and bug-tracking using the test management tool like Test Director and Bugzilla.
• Created ETL test data for all ETL mapping rules to test the functionality of theInformaticagraphs.
• Proficient in backend testing with using Oracle & SQL on Windows operating systems.
• Extensive Data Warehouse experience using Informatica Power Center / Power Mart (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as ETL tool on Oracle Database.
• 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.
• Have strong knowledge ofhealthcare terminologyand extensive experience working on healthcare projects. Specialized experience in healthcare insurance domain. Profound understanding of insurance policies likeHMO and PPOand proven experience with HIPPA 4010/5010 EDI transaction codes.
• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• Tested UNIX shell scripts written for ETL Processes to schedule workflows on Autosys.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions. Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Experience inData Analysis, Data Validation, Data Cleansing, Data Verificationand identifying data mismatch.
• Exceptional Analytical, Programming and Debugging Skills.
• Hands on experience in writing test plans, test cases, developing and maintaining test scripts.
• Experience working with open source testing tools and technologies
• Excellent Communication and Leadership skills. Self-motivated, quick learner.

TECHNICAL SKILLS

Technologies: XML, XSL/XSLT, UML, Hibernate, SQL, SOA and Web Services

Project Methodologies: Agile, RUP, Scrum, Waterfall

Testing and bug tracking: Mercury Quality Center, Quick Test Pro, Test Director, LoadRunner, Bugzilla, Clear Case, Clear Quest, and JIRA.

ETL Tools: Informatica 9.1,8.6, Abinitio, and Datastage 7.0 and 8.0, IDQ

Scripting Languages: VBScript, Shell Script

Databases: DB2,Oracle 10g, Oracle 8i/9i, MS SQL, VSAM,MySQL and Teradata

Web Servers: Apache, IIS

Application Servers: Web Sphere 6.1, Web Logic 6.1, Tomcat 5.x, JBoss 5.2.x

Operating System: Linux/Unix, Solaris, Windows NT/XP/server 2003

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr ETL Developer

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Interacted with the Business Analysts and key stakeholders and clarified the requirements that were inconsistent and ambiguous.
• Tested various Reusable ETL Transformations, which facilitate Daily, Weekly & Monthly Loading of Data.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Developed ETL mappings, transformations using Informatica Power center
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Written Test Cases for ETL to compare Source and Target database systems.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels
• Validated data in between source and target after running Mappings by the Informatica developer team.
• Used Agile-testing methodology for achieving deadlines in UAT.
• Involved in manually testing various modules of the application to ensure application stability and functionality.
• Scheduling and automating jobs to be run in a batch process.
• Validated the whole application in QA Production Environment.
• Validated whether user interface is functional: buttons working, page flows correct, data viewable.
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, Alerts Cascading Prompts and User Defined Objects.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• IntegratedQualityCenterwith external sources such as Excel, Requisite Pro, Word, etc.
• Performed Cross-Browsing testing to verify if the application provides accurate information in different (IE, Netscape, Firefox, Safari) browsers.
• Extensively used SQL Queries to perform Back End Testing.
• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports.

Environment: HP Quality Center 10, Informatica 9.1 (Power Center/ Power Mart), SQL, PL/SQL, Business Objects, UNIX, Shell Scripts, Oracle.

Confidential, Malven,PA

Sr. Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica workflow Manager.
• Extensively used ETL to load data from wide range of source such as flat files, oracle and XML to ORACLE.
• The project involved extracting data from various sources, transforming the data from these files before loading the data into target (warehouse) SQL server tables.
• Informatica Metadata repository was created using the Repository Manager as a hub for interaction between the various tools. Security and user management, repository backup was also done using the same tool.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner and Update Strategy.
• Workflow Manager used for creating and maintaining the Sessions, Monitor, edit, schedule, copy, abort and delete the session. messages and status reports using Workflow manager.
• Involved Working on Functional testing, Integration/ System testing, Regression testing, And User Acceptance Testing.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Extensively used un-connected Look-Ups for minimizing the run time and add to the performance of the server, while making sure to avoid duplicates of data from other source systems.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Created different types of reports, such as Master/Detail, Cross Tab and Chart Using BO.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts, test matrix and test cases for manual and automated testing.
• Improving each step in online loan application process to make it more effective for both customers and business users.
• Conducted Use Case Review sessions with business stakeholders.
• Created Test plans and performed manual testing of the application to test the system for both the functional and business requirements for positive and negative scenarios using HP Quality Center.
• Performed Manual Testing on different Modules of the Application by executing the Test Cases.
• Created test scenarios, test data according to the test cases.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Executing ofManual Scripts. Defect logging and Bug Tracking through an interface withHP Quality Center.
• Involved in all phases of (Unit, Integrated and UAT) testing Informatica mappings
• Validated both Wachovia and Confidential application
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Created mapping documents to outline data flow from sources to targets.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the datamarts and feeder systems in the aggregation effort.
• Validated whether Account history data is coming correctly from Hogan system.
• Validated whether account balances are displayed from Hogan system.
• Validated whether account number is in closed or open status in Hogan.
• Created Test data and Test Scenarios in UAT Environment.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules
• Validated the whole application in UAT and Production Environment.
• Documented the errors using HP Quality Center and tracked them to completion by communicating and co-coordinating with the development as well as the support group.
• Manually manipulate data directly from Oracle database using SQL.
• Performed database testing to validate database using TOAD.
• Reviewed data from Back End to Front End of the application using SQL statements.

Environment: Informatica Powercenter 8.6/8.1, Windows XP, UNIX, Oracle 9i, SQL server, PL/SQL, ERwin, Business Objects, Autosys, HP Quality Center 9.2, Quick Test Pro, MS-Office, MS-Project.

Confidential, Groton, CT

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Client tools - PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata
• Developed complex mapping using Informatica PowerCenter tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Experience in converting SAS scripts to informatica.
• Good understanding on SAS functions.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA).
• Experience developing and supporting complex DW transformations
• Excellent understanding of Star Schema Data Models; Type 1 and Type 2 Dimensions.
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed work-flow dependency in Informatica using Event Wait Task, Command Wait.

Environment: Informatica PowerCenter 9.5, Oracle 11i, SQL Server 2008, MS Access 2010, SQL*Loader, UNIX, Erwin 7.2, SQL, PL/SQL.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Involved with all the phases of the life cycle starting from gathering requirements for designing DS systems, data modeling involving in the design of the logical and physical databases, Data warehouse design with decision support in mind and development.
• Involved in designing the Dimensional Data Model of the Data warehouse by using Erwin 4.1 to identify the business process, grain of the data representation, dimensions and fact tables with measured facts.
• Identified all the confirmed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designerTransformation Developer, Workflow Manager and Monitor
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and used mapping designer to map the source to the target.
• Extensively used transformations like Source Qualifier, Lookup, Expression, Aggregator, Joiner, Router, Normalizer, Filter, Sequence generator, Expression, Sorter, and Update Strategy to create Mappings.
• Mapplets and Reusable Transformations have been part of the mappings since different data types conversions have to be dealt multiple times which are similar and also most of the lookups have been similar.
• Wrote Informatica ETL design documents, established ETL coding standards, developed Informatica mappings and perform reviews of the same.
• Created reusable email tasks in workflows to send post session and suspension emails as per user requirements.
• Created and maintained folders in the repository manager to logically organize all the metadata in the repository including mappings, schemas and sessions.

Environment: Informatica Power Center 8.1.1, Oracle 9i, PL/SQL Developer, SQL Server 2005, UNIX

Confidential, New York City, NY

ETL Developer

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica workflow Manager.
• Extensively used ETL to load data from wide range of source such as flat files, oracle and XML to ORACLE.
• The project involved extracting data from various sources, transforming the data from these files before loading the data into target (warehouse) SQL server tables.
• Informatica Metadata repository was created using the Repository Manager as a hub for interaction between the various tools. Security and user management, repository backup was also done using the same tool.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner and Update Strategy.
• Workflow Manager used for creating and maintaining the Sessions, Monitor, edit, schedule, copy, abort and delete the session. messages and status reports using Workflow manager.
• Involved Working on Functional testing, Integration/ System testing, Regression testing, And User Acceptance Testing.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Extensively used un-connected Look-Ups for minimizing the run time and add to the performance of the server, while making sure to avoid duplicates of data from other source systems.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Created different types of reports, such as Master/Detail, Cross Tab and Chart Using BO.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts, test matrix and test cases for manual and automated testing.

Environment: Informatica Powercenter 8.6/8.1, Windows XP, UNIX, Oracle 9i, SQL server, PL/SQL, ERwin, Business Objects, Autosys

Confidential

Jr .ETL Developer

Responsibilities:

• Interacted with Business analyst and Project Manager to identify the business requirements. Walkthrough the Work Force Management and project architecture and scopes.
• Based on the requirement documents estimated efforts for Informatica design, development, integration testing, UAT testing, bug fixing, Control M Job design, migrating code with sub version tool.
• Worked with Kimball's Data Modeling concepts including data modeling, data marts, dimensional modeling, star and snowflake schema, fact aggregation and dimension tables, slowly changing dimensions and surrogate keys.
• Load operational data from SQL Server, flat files, Excel Worksheets into various data marts.
• Extensively developed various Mappings which perform Extraction, Transformation and Loading of Source data into the OLAP Schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner etc.
• Created Mappings in mapping designer with Call count by each 15-minute time interval for each store, date and time. Created reusable sessions, worklet’s and workflows in Workflow manager. Header and Trailer worklets used to found out the target file name and number of records in a session.
• Created PL/SQL procedures to truncate the tables in Oracle before Informatica job runs.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Involved in Unit Testing and Integration Testing of the application.
• Scheduled the Control-M jobs and Manual loads on daily, Weekly and monthly basis.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.

Environment: Informatica 8.1.1, UNIX, PUTTY, Oracle, SQL Server, Control-M, MS-Access, SQL Developer