ETL Tester

Helena Kaplun

Vaughan Cell (***) - ******* E-mail: *********@*****.***

Professional Profile

Over 8 years of IT experience in RDBMS & DWH, experience in design, development, testing, implementation and support of enterprise data warehouse. Strong understanding of Software Development Life Cycle, Data Modeling (Relational, Dimensional). Profound experience in designing, developing, documenting, testing and performance of ETL jobs using Informatica and Oracle PL/SQL. Analytical and problem-solving skills Strong ability to multitasking while managing effectively time and commitments. Communication and interpersonal skills to collaborate with user communities. Ability to work independently and as team player. Responsible, innovative and dedicated.

Computer Skills

ETL:

Informatica 8.6/9.5

Databases:

Oracle 9i/10g/11g, MS SQL Server 2005/2008, MS ACCESS 2007/2010, DB2

BI Tools:

Business Objects (BOXI), SAP Business Objects, OBIEE, Panorama, NECTO, QlikView, OLAP

Languages:

PLSQL, TSQL, MySQL, Teradata

Other Products:

UNIX, EDQ, IBM RQM, TOAD for Oracle, HP Quality Centre, CQ(ClearQuest), HTML, HP ALM Explorer 12.5x

Professional Experience

Senior Quality Assurance Tester Feb 2019 – Sep 2019

Rogers Company, www.rogers.com

Performing Functional, Integration and Regression testing across multiple platforms, application frameworks, GUI and backend applications

Designing, developing and maintaining test plan and test cases utilizing project documentation including business requirements and system design to fully test that the solution satisfies the needs of the business

Ensure issues and defects are logged quickly and accurately while fixed defects are promptly verified and closed

Collaborating with Developers and Data Analyst to ensure that issues and risks are identified, logged and resolved

Providing testing support on UAT and Production issues

Exceptional understanding of black box testing

Strong understanding of database systems, proficient SQL skills, experience with Oracle, MySQL and SQL databases

Experience writing and maintaining manual test plans, test cases and reporting test results independently

QA Analyst Feb 2017 – Jan 2019

Noviur Technologies Company, www.noviurtechnologies.com

Creating and executing test cases and scripts based on business requirements

Creating and maintaining complex and re-usable SQL queries and working with large data flat files

Strong with ETL data validation using ETL environments

Managing and tracking all testing activities, both directly and indirectly with the ability to work on multiple projects at a time

Prioritize testing tasks, scenarios and test cases and track and report on testing activities

Testing experience with a variety of business applications executing in a variety of operating environments (platforms)

Troubleshooting ETL and reporting jobs and follow escalation procedures to resolve the issue

Strong experience with SAP Business Objects, SQL, DB2, Unix shell scripts, Mainframe and Enterprise Service Bus (ESB)

Environment: HP ALM, PL SQL, T-SQL, SAP Business Objects, DB2, Neteeza, Unix shell scripts

BI Technical Analyst / QA Analyst Jan 2016 – Dec 2016

Rogers Company, www.rogers.com

Designing, developing and supporting data warehousing and ETL processes`

Working experience in Developing Mappings, Mapplets, Sessions, Worklets, Workflows

Turning the ETL processes

Working experience in design and development of mappings, transformations, sessions and workflows

Creating of the technical and system specification documents necessary to support ETL processes

Participating in development and execution of unit and system test plans

Experience in profiling data with (Oracle Enterprise Data Quality)

Developing complex SQL queries (PL SQL and T-SQL)

Working experience on UNIX

Creating and executing SQL queries for testing ETL process

Testing Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly

Environment: Informatica 8.6/9.5, UNIX, PL SQL, T-SQL, Oracle EDQ

QA Analyst July 2015 – Jan 2016

Rogers Company, www.rogers.com

Working with Business /Technical Analyst in analysis of functional design specifications

of ETL/Data warehouse applications of Global Direct, Sales Order Processing and Blue Hornet Email for Microsoft & Adobe clients.

Analyzing Source to Stage and Stage to Target mapping document based on Facts & Dimensions and validating the DDL, Counts, Not Nulls,

Duplicates,PK & FK validation, business rules to be applied on target tables.

Testing loading of Source Commerce data (Catalogs/Products, Sites & Companies, Sales Transactions, Invoice, Orders, Payments, Returns,

Shipments,Offers etc) to ERP & EDW target Oracle systems.

Involving in creation of Test Plans, Test Cases, and Test Execution based on mapping specs to validate the platform data.

Using TOAD for Oracle in creating & executing SQL queries for testing ETL process.

Validated Type II SCD for loading current and history of Sale, Fraud Chargeback Reversal, and Chargeback Reversal in placing old and new Order_id's

based on Commerce_Platform_ID

Testing Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done

correctly.

Using RQM 4.02 as test management tool to manage and organize Requirements Coverage,Test Cases, Test Scripts and Creation of defects.

Followed Defect management life cycle and raised the defects based on priority and severity level in RQM.

Environment: Informatica 8.6/9.5, OBIEE, UNIX, IBM RQM 4.02, TOAD for Oracle, CQ (ClearQuest)

BI DWH Developer Aug 2008 – June 2015

Bezeq International Company, www.bezeqint.net

Involved in various aspects of analysis, design and implement of DWH

Designed and developed ETL processes using Informatica

Developed and implemented complex Business rules by creating robust Mappings/Mapplets, reusable Transformations and Tasks

Developed complex SQL queries (Oracle and SQL Server)

Created and executed SQL queries for testing ETL process

Analyzing Source to Stage and Stage to Target mapping document based on Facts & Dimensions, Counts, Not Nulls, Duplicates, PK & FK validation, business rules to be applied on target tables

Gathered business requirements and translated them into design document for BI portal

Experienced in building and retrieving data using Universes, Personal data files, and creating complex Reports using Business Objects (BOXI)

Developed and implemented BO Universes and complex reports based on high-level business requirements

Developed and maintained QlikView Load Scripts across multiple data sources

Identified data sources and prepared data for QlikView applications

Environment: Informatica 8.6/9.5, Business Objects (BOXI), Oracle PL/SQL, MS SQL Server,

Panorama, NECTO, QlikView, OLAP

Education

Bachelor of Science in Computer Science 2001

Champlain College (Vermont, USA), Israel Branch

Practical Engineer Diploma, Major in Computer Systems 1996

The College of Management, Israel

Professional Training

Dundas BI 2017

QlikView Designer - Data Force 2013

Informatica Developer - Aman Computers College 2008

PL/SQL - John Brice College, Israel 2006

Designer Business Objects - John Brice College, Israel 2002

Microsoft SQL SERVER 2000 Database - Hi-Tech College, Israel 2001

Business Objects - FCT Formula College, Israel 2000

Contact this candidate