ETL - MANUAL TESTER - 6.11 Yrs

ABINASH MAHALIK
(QA ETL_MANUAL) Mob : +91-9448516649

Email id : abinash.m2013@yahoo.com
Objective:
To seek a responsible and challenging position within the organization that

gives the scope to update my knowledge and skills in accordance with the latest
trends to facilitate continuous career growth that works towards growth of
organization.
Profile Summary:
 Having 6.11 years experiences in ETL Testing & Manual Testing.

 Hands on experience in SQL.
 Experienced in Integration Testing, Regression testing of various applications.
 Well acquainted with Software Development Life Cycle & Software Test Life
Cycle.
 Involved in test planning documentation, writing Test cases and executing the
test cases.
 Involved in Functional, Integration, System, Smoke and Sanity Testing.
 Extensive experience in Black Box Testing.
 Good experience in Test Case Development and Execution.
 Effective in Defect tracking and Bug Reporting in Bug Tracking tool.
 Innovative mind and Interest in learning new concepts, skills and
implementing.
 Good knowledge on Data Warehouse and ETL process.
 Experienced on waterfall and Agile Methodologies.
Knowledge Details:
Testing DWH/ETL testing ,Manual testing

ETL Tools Informatica Power Centre 9.6,
Database Oracle 11g, SQL server
Test Management & Other Tools HP ALM 11.0 , HP QC 8, JIRA
Operating System Windows 7, Windows 8, Windows 10
.
Employment Details:
 Currently I am working as “SOFTWARE Test Engineer” in “EMREC

TECHNOLOGIES PVT.LTD” from May, 2016 till date
Educational Details:
 B.E in Mechanical from KIST, Khurda under Biju Patanaik University &
Technology, in 2012.
Project Experiences:
Project # 4
===========
Project Name : National life Insurance
Client : American National life Insurance company, USA
Environment : Oracle 11g, Informatica 8.6, windows 7, windows 10
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 # 3
==========
Project Name : EDW – Enterprise Data warehouse
Client : Philip Morris, USA
Environment : Oracle 10g, Informatica, windows 7, windows 10
Description :
Philip Morris is a tobacco production company, who deals with various

cigarette companies and retailers located in USA. This project is for RETAIL SALES
ANALYSIS DWH covering the consumer products. Data Warehouse designed for the
purpose of Sales Analysis that basically helps the decision makers to analyze the
sales as Product Wise, Brand Wise, Category Wise, Company Wise, Customer Wise,
Supplier Wise, Area Wise, City Wise, State Wise, country wise, Time Wise, etc. and
analyze the sales and profit in month wise quarter wise, and year wise.
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.
PROJECT # 2
============
Project Name : E-Banking
Client : American Express, USA
Technology : PHP, HTML, JQuery
Role : Associate Test Engineer
Description :
The proposed system is an Internet banking web portal and the main aim of
this project is to implement a online banking system through which users can
perform the basic banking transactions by sitting at their office or at homes through
PC or laptop. The customers can access the banks website for viewing their Account
details and perform the transactions on account as per their requirements. With
Internet Banking, the brick and mortar structure of the traditional banking gets
converted into a click and portal model, thereby giving a concept of virtual banking a
real shape. Thus today's banking is no longer confined to branches. E-banking
facilitates banking transactions by customers round the clock globally. The primary
aim of this software is to provide an improved design methodology, which envisages
the future expansion, and modification, which is necessary for a core sector like
banking. This necessitates the design to be expandable and modifiable and so a
modular approach is used in developing the software. Anybody who is an Account
holder in this bank can become a member of online banking. He has to fill a form
with his personal details and Account Number.
RESPONSIBILITY:
 Understanding the software requirements.

 Knowing how the end user will use the application.
 Creating test cases from the user stories or from test scenarios.
 Execute the test cases
 If any defect found, report it to developer and fix it.
 Perform the task again where the defect was found to make sure that the
application is defect free.
 Send the test reports to the test lead.
PROJECT # 1
===============
Project Name : Simplixity
Client : Simplicity, US
Environment : ASP net, SQL Server, Quality Centre
Description :
Simplexity is the Internet's leading authorized seller of cell phones and wireless
services based in Reston, Virginia Simplexity business include comprehensive
inventory and rate plan management, order processing, automated activation,
online merchandising, high-level customer care and customer relationship marketing
Wirefly is Simplexity shopping and comparison site for consumers, bringing online
shoppers an unprecedented selection of cell phones and service plans from all the
top-rated US carriers with the convenience of automated application processing and
cell phone activation
RESPONSIBILITIES:
 Involved in functional study of the application
 Involved in test case Development based on user stories
 Involved in test case execution
 Identified Test Scripts for Regression testing
 Defect Analysing and Reporting in QC

ETL - MANUAL TESTER - 6.11 Yrs

Uploaded by

Copyright:

Available Formats

ETL - MANUAL TESTER - 6.11 Yrs

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

ETL - MANUAL TESTER - 6.11 Yrs

Uploaded by

Copyright:

Available Formats

ABINASH MAHALIK

(QA ETL_MANUAL) Mob : +91-9448516649

To seek a responsible and challenging position within the organization that

 Having 6.11 years experiences in ETL Testing & Manual Testing.

Testing DWH/ETL testing ,Manual testing

 Currently I am working as “SOFTWARE Test Engineer” in “EMREC

Philip Morris is a tobacco production company, who deals with various

 Understanding the software requirements.

You might also like