etl tester

D.Rajasekhar

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

Mobile: +91-805*******

SUMMARY:

V Having 2+ years of experience in Software Testing

V Experience on ETL/DWH & Manual Testing.

V Hands on experience on writing SQL queries

V Good knowledge in Data Warehousing Concepts.

V Hands on experience on Oracle database

V Hands on testing experience in Informatica Power Center.

V Hands on experience on Quality Centre

V Quick learner & excellent team player with ability to meet

deadlines & work under pressure.

V Excellent communication and inter-personal skills.

SKILLS:

|Testing |ETL/DWH testing & Web application testing |

|ETL Tools |Informatica Power Centre 8.6.2 |

|Database |Oracle & SQL Server |

|Test Management|Quaity centre 9.2, TOAD |

|& Other Tools | |

|Languages |C, SQL |

|Operating |Windows family, UNIX |

|System | |

EDUCATION DETAILS:

V B.Tech in Electrical and Electronics Engineering from JNTU, Anantapur in

2010.

PROFESSIONAL EXPERIENCE:

. Working as Software Test Engineer for Wipro Technologies, Bangalore

from augest 2010 to till date.

Project#1 : Lord & Taylor warehouse

Client : Lord & Taylor

Environment : Informatica 8.6, Oracle 10g

Role : Test Engineer

Project Description:

Lord & Taylor Retail Food Stores, which is one of the organization that

sells various numbers of products. Lord & Taylor have various stores

across USA, which maintains Sales, Profits with lots of historical data.

This project was to create Sales Data Warehouse and generate reports using

Reporting services. The aim of sales data Warehouse is to analyze the sales

and profit in month wise and year wise. The data gets refreshed yearly and

is maintained historically. This Data warehouse plays a major role in

enabling various stores to view the data at a lowest level and help them to

make decision to bring more revenue to company with new policies.

Responsibilities:

. Involved in functional study of the application

. Running the Jobs/Workflow for ETL process

. Prepared and ran SQL queries

. Designed & Executed test cases

. Verifying the data in target database after ETL process

. Performed column data mapping between source & target database.

. Prepared test data for testing

. Defect Analyzing and Reporting in QC

. Interactions with BA & Dev teams to resolve the issues.

. Reporting daily testing status report

Project#2 : HUMANA HEALTH INSURANCE (HIMS)

Client : Humana Health Insurance Company

Environment : Informatica 8.6.2, Oracle9i, Toad, Quality Centre, UNIX,

Windows

Role : Test Engineer

Project Description:

Humana is a one of the top most insurance company in USA, IT stated in

1961. Humana has become one of the most recognized names in the markets and

administer health Benefit consumer service. It is also recognized as

largest Fortune 500 companies headquarter is in comm.--wealth of Kentucky

with $21.4 billon.

For creating a better health care system and for taking better decision for

the sales and promotion. It helps to achieve health and financial security

by providing easy access to cost-effective, high-quality health care. The

goal of the project is to develop strong database technology that will

extract and transform the Insurance data is collected in ODS and load into

DWH .To take proper decision in each level with proper data.

Responsibilities:

. Understanding the customer requirements

. Designed High level test scenarios and test cases

. Executed test cases in QC

. Run the Informatica Workflows for ETL Process

. Validated data in Target database according to business rules

. Prepared SQL queries and executed to validate the ETL processed data in

target database.

. Verifying the column mapping between source and target databases

. Worked closely with Dev team

Project#3 : Acosta

Client : Acosta Sales & Marketing

Environment : Dot net, SQL Server

Role : Test Engineer

Project Description:

Project Caters the needs of Business Analysts in Decision Support Systems.

Reports are generated based on subject area like Purchasing, Sales &

Marketing, Transportation, etc., Project is spanned across three phases.

Preparing Report Specification Documents, Mapping Documents and Report

development-using Report Net according to new user requirements based on

template, Report Net Guidelines, abbreviations list and also resolving

performance tuning issues.

Responsibilities:

. System Study

. Developed, Reviewed and Executed Test Scripts

. Test Activities included Functional Testing and Regression Testing.

. Defect Analyzing and Reporting.

Contact this candidate