Project Testing

Hari Mobile: +91-720*******

Email: *******.***@*****.***

Experience Summary

3.6 years of experience in Informatica, ETL Testing

Excellent knowledge of Manual Testing, Datwarehousing concepts

Excellent knowledge in ETL Tool Informatica

Good exposure in Test Planning, Test Case documentation, Test Execution and Test Analysis.

Good Knowledge in Database Testing, Report Testing

Hands-on experience on UNIX, SQL, Knowledge in pl/sql

Experience in Quality Center

Good exposure on SDLC,STLC

Technical Skills

Testing : ETL Testing

Business Integration Tool : Informatica 8.x

Test Management Tool : Quality Center 9.x,

RDBMS : Oracle

Documentation Tool : MS-Office

Operating Systems : UNIX and Windows

Professional Profile

• Working as ETL Tester in Tavant Technologies India Pvt. Ltd., Bangalore from April 2009 to till date.

• Worked as Data Stage Developer in Aris Global Software Pvt. Ltd in Bangalore from Aug 2008 to March 2009

Professional / Academic Qualifications

M.C.A From Sri Venkateswara University

B.Sc from Sri Venkateswara University

Project Summary

Project : Integrated Banking System (IBS).

Client : Universal Bank, California

Environment : Informatica 8x, Oracle 9i

Duration : June 10 to till date

Role : ETL Tester

Description

The IBS project has been developed to provide the Online Customer services (OCS).It maintaining the customer details, storing their transaction details and generating reports and provide online services. The IBS is mainly divided into 3 modules such as Maintenance, Transactions, and Reports

Responsibilities

Involved in ETL- Data warehousing Testing.

Involved in preparing test case design documents.

Involved in writing queries for aggregate functions.

Involved in writing for queries for source and target

Involved in integration testing, Data quality, Regression testing, user acceptance testing.

Detecting, classifying and reporting bugs through Quality Center 9.x.

Involved in Reviews, and Bug status meetings.

Project 2

Project Name : Health care Medicines

Client : CARLSON Medical Systems, Chicago Environment : Informatica 8.x, Oracle

Duration : April 2009 to May 10

Role : ETL Testing

Description:

Carlison, full service health Benefits Company with three major lines of business. The organization working on Group health, Workers compensation and public sector. The primary objective of the project is to develop the healthcare system making extensive use of Data marts. The objective is to extract data stored in different databases and load into oracle system

Responsibilities:

Involved in ETL- Data warehousing Testing.

Designed test cases based on Software Functional Specifications and Uses cases.

Executed Test Cases and Gathered Test Execution Results.

Involved in Functional testing, System testing, System integration testing, Regression testing,

Detecting, classifying and reporting bugs through Quality Center 9.x.

Involved in Reviews, and Bug status meetings.

Project 3

Project Name : Integrated Accounting System

Client : Bank of Montreal

Environment : Informatica 8.x, Oracle 9i,

Duration : Aug 2008 to March 2009

Role : ETL Developer.

Description:

BMO Financial Group (TSX, NYSE: BMO) is a highly diversified financial services organization. BMO Financial Group is the fourth largest bank in Canada by deposits. BMO Financial Group serves more than 10 million personal, commercial, corporate and institutional customers in North America and internationally. Our operating groups – Personal and Commercial Banking, BMO Bank of Montreal in Canada and Harris in the United States; Private Client Group, our wealth management business; and BMO Capital Markets.

Roles and Responsibilities:

Involved in Extraction, transformation and loading of the data from different Data

Sources like Flat files, Oracle to the Data Warehouse.

Developed mappings using Informatica Power Center Designer to load data from various source systems to target databases.

Responsible to design, develop and test the mappings.

Used various transformations like Source Qualifier, Aggregators, Connected and Unconnected Lookups, Filters, Routers, Sequence generator, Update Strategy, Expression.

Contact this candidate