Sign in

ETL/Dwh Testing, Oracle, SQL, PL/SQL, Hp Alm/QC, Toad, Unix

Bengaluru, Karnataka, India
February 19, 2018

Contact this candidate


Ananda Shatty (ETL Tester)


Mobile: +91-855*******, +91-974*******.

Career Objective

Seeking a challenging career to work in dynamic organization that extends opportunities for extensive learning and skill enhancement in Software Testing (ETL, DWH Testing) and Quality Assurance Engineering where my abilities as Software Test Engineer can be effectively utilized.

Professional Summary

Presently working as a Software Engineer in HCS Technologies Pvt Ltd, Bengaluru from Aug - 2015 to till Date.


Having around 3 Years of Experience in Software testing which includes ETL/DWH Testing and Web application testing.

Hands on Experience in ETL/DWH testing.

Hands of experience with HP ALM/QC.

Good Exposure to Data Warehousing concepts using Fact tables, Dimension tables, star schema and Snowflake schema Modelling.

Hands on experience in writing and executing SQL Queries.

Expertise in testing initial and delta loads.

Extensively used Workflow manager & Workflow monitor in Informatica ETL Tool.

Experience in testing surrogate keys and slowly changing dimensions.

Have Knowledge on understanding & creating source and target definitions, Mappings, Sessions, Workflows and Transformations.

Experience in the ETL (Extraction, Transformation & Load) techniques, Dimensional Schema Models (Star, Snow-Flake).

Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases and Execution.

Involved in the Designing, Preparing, Execution and Maintenance of the test cases.

Having knowledge on UINIX.

Having knowledge on Defect Life Cycle.

Education Profile

B.E (ISE) from JSS Academy of Technical Education, Bengaluru with an aggregate of 61.16%.

Diploma from Govt, Polytechnic College, Raichur with an aggregate of 69.23%.

SSCL from Govt. High School, Raichur Dist, With an aggregate of 70.88%.

Technical Skills

Software Testing : ETL/DWH testing & Manual Testing.

ETL Tool : Informatica Power Center 9.5

Languages : SQL Plus, MS SQL.

Test Management Tool : Quality Center/HP ALM 11.0.

Database : Oracle 10g, Oracle 11g

Operating systems : Windows, Unix

Data Access Tool : TOAD, Oracle SQL Developer 4.0.

Reporting Tool : QlikView 11.0

Project Details

Project # 2 :

Project Name : BooksBeka

Client : Booksbeka Online Solutions Pvt Ltd.

Period : Dec-2016 to till date

Team size : 8

Role : ETL Tester

Environment : Oracle 11g, Informatica 9.5, Toad, ALM, QlikView, Windows.


This online bookstore application that acts as a central database containing various books in stock along with their title, author, cost, description and etc., this project is website application that acts as central book store. This web project is developed using java scripting languages and SQL as a back-end. The user may select desired book and view its price. The user may even search for specific books on the website. Once the user selects a book, he then has to fill in a form and book is booked for the user. The database stores various book related information/details. The aim of sales data Warehouse is to analyse the sales and profit in Quarterly wise and yearly wise. The data gets refreshed yearly and is maintained historically. This Data warehouse plays a major role in enabling BA to view the data at a lowest level and help them to make decision to bring more revenue to company with new policies.


Requirement Analysis

Worked with HP ALM/QC for test case uploading and mapping them to test lab and executing test cases

Involved in functional study of the application

Test case documentation.

Test Data preparation to validate all possible Test scenarios/Test cases

Running the Jobs/Workflow for ETL process in Informatica Power Center

Verifying the ETL data in target database

Verified column mapping between source and target

Interacted with BA & Development teams to resolve the issues

Reporting daily testing status

Defect Analyzing, Preparing test plan documentation and Reporting in QC/HP ALM.

Project #1:

Project Name : Asset Management System

Client : Microchip Pvt ltd.

Period : Aug - 2015 to Nov – 2016

Team size : 8

Role : Tester

Environment : Oracle 11g, Informatica, Toad, HP ALM, Windows.


Asset management, broadly defined, refers to any system that monitors and maintains things of value to an entity or group or ethnic groups. Asset management is a systematic process of deploying, operating, maintaining, upgrading, and disposing of assets cost-effectively. Finance Department is responsible to maintain Master Data related to Products, Suppliers and Manufacturers, Employee and their level of authority information. The goal of the project is to develop strong database technology that will extract and transform the data collected and load into DWH .For decision in each level with proper data.


Analysed Requirement Specification documents

Prepared Test Scenarios & Test cases and executed Test cases

Involved in System Testing.

Running the Jobs/Workflow for ETL process in Informatica Power Center

Verifying the ETL data in target database

Source and Target data Mapping

Interactions with BA & Development teams to resolve the issues.

Defect Analyzing, Preparing test plan documentation and Reporting in QC/HP ALM.

Personal Details

Date of Birth : 18-Oct-1992

Languages Known : English, Hindi, Kannada, and Telugu.

Address : RajajiNagar 2nd Block, Shivanagar, Bengaluru-10.

I hereby declare that the above Information given by me is true to the best of my knowledge.


Place: Bengaluru.

(Ananda Shatty).

Contact this candidate