ETL Test Engineer,

Project #1 : MIS/FMS
Client : CRIDA, India
Environment : Oracle 11g, Informatica 9.6, windows
Role : Software Test Engineer

Description: This project is developed for National life Insurance is an insurance provider in USA.
This project deals with the company's customer, policies, Claims. In the life insurance Data
warehousing project, data is collected from different locations and convert, extract and cleanse,
process and transforming it and loading in to the target databases. We can have the information
regarding the number of new customers joined, the percentage of growth of customers and also gives
the dropout ratio of customers, polices that are making good business.
Responsibilities:
* Involved in functional study of the application.
* Running the Jobs/Workflow for ETL process.
* Prepared and ran SQL queries to verify Dimensional and Fact tables.
* Verifying the data in target database after ETL process.
* Performed column data mapping between source & target database.
* Prepared test data for testing.
* Verifying the data which is loaded into target database.
* Interactions with BA & Dev teams to resolve the issues.
* Reporting daily testing status report.
* Developed, Reviewed & Executed Test Scripts and Designed test data.
* Identified Test Scripts for Regression testing.
* Defect Analyzing and Reporting in QC.

Project #2 : NRCM
Client : ICAR, NEW Delhi
Environment : Oracle 11g, Informatica, windows
Role : Software Test Engineer
Description: The Indian Council of Agricultural Research (ICAR) is an autonomous organization under
the Department of Agricultural Research and Education (DARE), Ministry of Agriculture, Government of
India. Formerly known as Imperial Council of Agricultural Research, it was established on 16 July
1929 as a registered society under the Societies Registration Act, 1860 in pursuance of the report
of the Royal Commission on Agriculture. The ICAR has its headquarters at New Delhi.
Responsibilities:
* Understanding various Business requirements.
* Involved in writing Test Plan.
* Prepared and ran sql queries to verify Dimensional and Fact tables.
* Verifying the data in target database after ETL process.
* Prepared test data for testing.
* Verifying the data which is loaded into target database.
* Interactions with BA & Dev teams to resolve the issues.
* Reporting daily testing status report.
* Developed, Reviewed & Executed Test Scripts and Designed test data.
* Defect Analyzing and Reporting in QC.