ETL Test Engineer:

T Sudheer Reddy

907*******

ac4sgs@r.postjobfree.com

Objective:

To pursue a challenging career in a progressive environment where learning, innovation and creativity are encouraged, where my skills can be developed to their maximum potential and adding to the overall success and growth of the organization.

Summary:

Having around 3.5 years of experience in ETL/DWH Testing and Manual Testing

Good knowledge on Data warehouse concepts

Hands on experience in writing SQL Queries

Hands on experience on Quality Center ALM

Experience on Oracle database

Having sound knowledge on Unix

Extensively used Workflow manager, Workflow monitor in Informatica ETL tool

An exceptional performer with the ability to work in teams as well as excellent communication, analytical, relationship management and problem-solving skills

Technical Skills:

Testing : DWH/ETL Testing

ETL Tools : Informatica 10.0.2

Database : Oracle 12c

Test Management Tools : Quality Centre ALM & TOAD

Languages : SQL

Operating System : Windows, UNIX

BI Tools : Tableau Software, OBIEE

Education:

B.Tech, (ECE) from JNTU University, Anantapur, AP in 2014.

Professional Summary:

Organization Designation Duration

Accenture Software Test Engineer Aug-2014 to Till Date

Professional Experience:

PROJECTS PROFILE:

Project 1:

Project Name: Texas Insurance Data Warehouse

Client : Texas insurance

Environment : Oracle, Informatica

Role : Software Test Engineer

Description:

Texas Insurance is one of the world’s respected players in Insurance industry. It deals with life insurance, home insurance, auto insurance etc. It aids in bringing operational efficiency by providing lowest level visibility on the status of the policy orders. It also reduces manual effort required to gather order status information from multiple tools and systems. It also supports the Operational Reporting Strategic Development from which it is extracting the data through Main Frames, Oracle then Transforming, and Loading into Oracle target database.

Responsibilities:

Involved in functional study of the application

Developed, Reviewed & Executed Test cases and Designed test data

Running the Jobs for ETL process

Prepared and ran SQL queries to verify the data

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

Identified Test Scripts for Regression testing

Defect Analyzing and Reporting in QC

Prepared test cases for validating the data

Project 2:

Project Name : Retail Store Sales Warehouse

Client : Ahold Delhaize, Salisbury, USA

Environment : Oracle 12c, Informatica, Toad, QC

Role : Software Test Engineer

Description:

Ahold Delhaize Retail Food Stores, which is one of the organizations that sells various numbers of products. Ahold Delhaize 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:

Reviewed business requirements documents and technical specifications

Created Test Cases corresponding to business rules and other operating conditions

Wrote the SQL queries on staging tables and data warehouse tables to validate the data results

Responsible for execution of ETL test cases

Interacted with developers, Business & Management Teams and End Users

Participated in regular project status meetings related to testing

Prepared status summary reports with details of executed, passed and failed test cases

Defect Analyzing and Reporting in QC

Project 3:

Project Name : BILL ANALYSER

Client : T-Mobile

Environment : .Net, CSS, Windows XP, Oracle

Role : Manual Tester

Description:

Bill Analyzer is An Web Based Application uses to T-mobile Postpaid customers for Secure & easy access to their billing and usage data over the internet. Monthly bills and call data accurate to the current day can be viewed, filtered, grouped, and sorted interactively in a variety of ways. The data are displayed in both table and graphical Formats and they can be downloaded for permanent storage.

Responsibilities:

Involved in understanding the Functional requirement

Identifying and prioritize manual test scenarios

Involved in Functional Testing, Regression Testing, and identify the defects.

Preparing Weekly status reports & Daily status reports

Participate in daily scrum meetings to discuss about the completed & pending assignments and also to inform about show stoppers if any

Contact this candidate