ETL QA Tester

SREELATHA R

Sr. DWBI ETL QA Engineer

Email: ************@*****.*** Contact: 469-***-****

PROFESSIONAL SUMMARY:

Sreelatha is having 8+ years of experience in Data warehouse and Business Intelligence Quality Engineering projects. Worked on various phases of the project's life cycle and worked on multiple technologies such as Oracle, SQL Server, Netezza, Informatica, Business Objects and Tableau. Have extensive experience working on data related projects while serving clients in various domains such as Travel, Utilities, Banking and Financial, and Healthcare.

Extensive experience in executing Test Strategy, Master test plans and Traceability matrix based on business requirements.

Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and developing Test Plan.

Has extensive experience in functional testing methodologies that include Systems Integration Testing, User Acceptance Testing Support, Regression Testing, Release Testing and Postproduction Validations for the ETL/BI systems.

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

Comprehensive knowledge of ETL(Informatica) testing, Reports and Extracts testing, SQL and analysis of relational databases.

Expertise in different phases of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) including methodologies like Agile and Waterfall.

Actively involved in Scrum Methodology for the project from requirements through delivery of the project.

Hands-on experience in the preparation of Test Plans, Test Cases, Test Reports, Requirement Traceability Matrix.

Expertise in performing Functional Testing, Integration Testing and Regression testing.

Good hands-on experience on various test management tools like Jira, HP-ALM and TestRail.

Hands-on experience with all levels of testing viz., Integration, Regression, Smoke, Sanity, Functional Testing, System testing and UAT.

Good Exposure to Testing Life Cycle and Bug Life Cycle.

Performed Database Testing with SQL and automated Data validations.

Conduct test case reviews, provide project related status reporting, coordinate all release planning and lead the testing team through all project phases.

Experience in preparing the Quality Metrics, Traceability Matrix and Testing Summary Reports.

Excellent professional skills by working independently and as a team member to analyze the Functional / Business requirements and to prepare test Cases for Manual Testing.

Ready to take up challenges like working on new Tools and Technologies.

Excellent interpersonal and effective communications skills verbally and in writing.

TECHNICAL SKILLS:

ETL Tools Informatica 6.1, 7.1, 8.1, Ab Initio (GDE 1.14, Co>Op 2.14) and Data Stage 6.x/7.x/8.x

Databases SQL Server 2008 R2, Oracle 9i/10g/11g, Teradata v2, Sybase, MS access and DB2, Netezza.

Programming Languages Java, C, SQL, PL/SQL, T-SQL, XML, HTML, Shell Scripting, Python, Java Script, and VB Script

Bug Tracking Tools Jira, TFS, Test Director 6/7.5/8.0 and Clear Quest.

BI Tools Tableau, Business Objects XIR3/XIR2/6.x

Testing Tools Quick Test Pro (QTP), ClearQuest and Load runner, HP Quality Center 10, QTP, Selenium, CA DevTest, SOAPUI, POSTMAN, TestRail

Scheduler Tools TIDAL, Control-M and Autosys

Operating Systems Windows 2000/NT/XP/Vista, UNIX (Linux, Sun Solaris, IBM AIX)

Other Skills and Tools Salesforce, Mainframe, Ultra Edit, WinSCP, Toad, XMLSpy 4.3/5.0, Putty, VS Code, IntelliJ IDEA, Eclipse

PROFESSIONAL EXPERIENCE:

Client: Prime Therapeutics, Eagan, MN Sep 2021 to Present

Role: Sr. ETL QA/Data Warehouse Tester

Project Description:

This project is to implement EDW and Data Marts for different lines of businesses to support various functions of Health plans and insurance as a single source of truth for analytical needs and sending data to external vendors. ELT integration is done using Netezza and Informatics for at different units called as interfaces where Source can be in the form of Oracle, SQL Server, and Flat files to Target different heterogeneous systems.

Responsibilities:

Worked with the project team (Scrum team) to plan testing, provide estimates, attend requirement/design meetings to understand project and testing scope.

Developed Test Cases for ETL/ Data warehouse changes based on technical specifications and Mapping documents

Performed functional, system, regression, and Integration testing for the stories handled.

Ran informatica workflows & sessions from the informatica workflow manager and captured the run time.

Ran JAWS manifests to load data from source to target, and Test scripts on UNIX and Netezza Aginity during Functional, System Integration and Regression Testing.

Verified data loads between external files to DSL tables, DSL to Dimensional Tables, Fact Tables.

Developed complex queries by joining different Dimensional tables to Fact tables and retrieved the data from source and validated the data against ODW.

Check the naming standards, data integrity and referential integrity. Prepared the test data for incremental loads and Base loads.

Involved in writing complex SQL queries by combining data from multiple tables with various filters.

Validated Informatica extraction, transformation and loading process by writing SQL against Business rules.

Verified record counts, column data types, column values, exceptional handling and SCD1 & SCD2 functionality.

Worked extensively with Database Procedures, Functions, Cursors and Joins to validate data.

Verified extracts files and performed integration testing with external vendors.

Reviewed informatica session logs to find out the performance, session failures & error checks.

Performed detailed requirement analysis, developed and maintained requirements traceability using the Test Management tool – Quality Center.

Prepared Master Detailed ETL (Informatica) and BI Test Plan for the entire Project.

Performed End-to-End testing for the entire ETL and Business Intelligence.

Extensively involved with ETL Informatica Mappings and the testing of Tableau reports.

Analyzed raw points data to ensure the data will meet the business needs.

Verified the data extracted from source and target tables to validate Informatica ETL process.

Tested and validated the ETL mappings in accordance with the business rules.

Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.

Extensively involved with backend testing by writing complex SQL queries.

Worked closely with business analyst and development group during the requirement phase and design phase to find out functional incompatibilities and software issues early in the QA process.

Involved in writing test cases and responsible for executing the test scripts.

Created sub-tasks and opening bugs in Jira for the stories worked and assigned to respective teams for resolution.

Interacted with the Business Analyst and Technical team in providing clear solutions to requirements.

Mapping the requirements to test cases (Tractability metrics) and creating Test Summary reports.

Reviewed the Data mapping documents and the requirements to write Test Cases that would test various scenarios.

Verified source systems, connectivity, tables, and fields, ensure data suitability mapped as per the Informatica mapping specifications.

Validated Complex mappings in Informatica to load the data from various sources using different transformations like Union, Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, XML Source Qualifier, Rank and Router transformations.

Ran Sessions to load the data from the source system using Informatica Workflow Manager.

Validated Target Data Mart (providers, subscribers) by writing SQL against Business rules.

Tested various UNIX Load Scripts and Informatica ETL data Validation.

Environment: Informatica Power Center, Netezza, Oracle 10g, SQL Server 2008 R2, UNIX, Shell Scripts, Flat Files, SQL, PL/SQL, TestRail, Jira, Tableau, TIDAL.

Client: Vizient, Irving, TX Jul 2020 to Aug 2021

Role: Sr ETL QA Tester

Project Description:

Vizient Inc., based in Irving, Texas, is a corporation that serves not-for-profit health system members and their affiliates, including 1,360 acute care hospitals. Founded in 2016, it is a successor company to VGA, Inc., founded as a network of not-for-profit healthcare organizations working in clinical, financial, and operational management. VHA and UHC (University Health System Consortium) owned a supply chain company called Novation and aptitude(R), the industry's first online direct market for local contracting. VHA also owned Provista, the enterprise's supply chain company serving the non-acute market as well as government, education, and business sectors.

Responsibilities:

Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.

Developed test scripts based upon business requirements and processes, in line with defined workflows and use cases. Processed transactions from system entry to exit. Tested functionality across applications and workflows.

Communicate directly with different business owners in the company to understand product and system requirements

Attend Daily Scrum meetings / Defect review meetings

Performed System Testing, Regression Testing, Performance Testing, end-end testing and Production Smoke Test.

Involved in testing, designing and development of the Data warehouse environment.

Implemented SDLC, QA methodologies and concepts in the Project.

Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.

Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.

Involved with ETL test data creation/Identified for all the ETL mapping rules.

Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.

Extensively worked with SCD Type 1 and Type 2 testing scenarios.

Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases

Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.

Involved in extensive DATA validation on data marts by using SQL queries.

Developed test reports and participated in testing prioritization and archived test results and user signoff

Worked on profiling the data for understanding the data and mapping documents.

Used TOAD Software for Querying ORACLE.

Validated Business Objects reports by running the SQL queries based on the business rules.

Wrote Complex SQL queries to validate the standard reports, Dashboards and Business Objects Universes.

Validated BO Reports and Universes against Data warehouse /Data mart Database by writing SQL Queries

Validated BO Reports, Dashboards and Universes like Fields present in the report are as agreed in the specifications, Drill down features, Column headings for business sense and familiarity, Display of units along the column headers, Presence of graphs, Report Descriptions, special features like alerts, filters, extraction criteria.

Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Defect Tracking and reports are done by Rational ClearQuest.

Worked with appropriate business and technology leads to determine the acceptable range for test results and performance.

Performed the tests in both the SIT, QA and contingency/backup environments.

Environment: Informatica Power center 9.1 (ETL), AGILE, HP Quality Center 10, Business Objects XIR2, SQL Server 2012, TFS 2010, QTP, ORACLE 11g, DB2, Teradata 13, UNIX, Autosys.

Client: Wells Fargo, San Francisco, CA Oct 2018 to June 2020

Role: ETL BI Tester

Project Description:

Wells Fargo & Company is an American multinational financial services company with corporate headquarters in San Francisco, California; operational headquarters in Manhattan; and managerial offices throughout the United States and internationally.

Wells Fargo is a diversified, community-based financial services company with approximately $1.9 trillion in assets. Wells Fargo’s vision is to satisfy our customers’ financial needs and help them succeed financially. Founded in 1852 and headquartered in San Francisco. Wells Fargo & Company was ranked No. 41 on Fortune’s 2022 rankings of America’s largest corporations. News, insights and perspectives from Wells Fargo are also available at Wells Fargo Stories.

Responsibilities:

Developed a high level Test Plan / Test Strategy and walkthrough the Test Plan to clients.

Responsible for delivering and reviewing the Test Plan, Test cases and Test results.

Extensive experience in writing and executing SQL for validation and testing the data integrity between source and target database and for report generation.

Developed and performed execution of Test Scripts to verify the expected results.

Responsible for testing new and existing ETL data warehouse components.

Involved in all phases and stages of Software Testing Life Cycle including end-to- end system testing and business requirements analysis.

Involved in identifying defects during the testing, performing defect analysis, suggesting required code changes for fixing defects Supported end users for UAT Testing.

Guided the team members in preparing the data validation scenarios, scripts, defect analysis and the automation test suite for executing the test scripts using existing framework.

Testing database Views and Extracts and performing integration testing with other applications and vendors.

Verified source systems, connectivity, tables, and fields, ensure data suitability mapped as per the Informatica mapping specifications.

Involved in preparing the status reports and also coordinating with offshore and onsite to bridge the gap between onsite and offshore.

Environment: ETL Informatica 9.1, BI Tableau, TOSCA, HP ALM/Quality Center, SQL, Oracle, SQL Server, Agile, EDW, Teradata, CI/CD, UNIX

Client: Health Net, Woodland Hills, CA July 2016 to Sep 2018

Title: ETL/Data Warehouse Tester

Project Description:

Our mission at Health Net is to transform the health of communities, one person at a time. We believe

each person deserves quality health coverage, regardless of age, income, job status, or current state of health. We hire

individuals who share our mission and passion. We have health plans for individuals, families, businesses of every size, and

people eligible for Medicare and Medi-Cal. Health Net also supports members with access to a variety of programs. These

programs offer substance abuse treatment, behavioral health services, and managed health care products related to

prescription drugs. We also support our team members through employee assistance programs.

Responsibilities:

Extensively interacted with developers, business teams to understand the project business requirements and ETL design document specifications.

Defines Test Strategy and creates and updates Test Planning documents.

Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mappings.

Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.

Validating the reporting objects in the reporter against the design specification document.

Validating the data files from source to make sure correct data has been captured to be loaded to target tables.

Created XML request files for test scenarios and test cases for the claims control web services.

Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules.

Tracked the progress of the defects till end of the defect life cycle, used HP Quality Center for defect tracking and maintained the workflows and trail history of bugs using HP Quality Center.

Validating the Archive process to purge the data that meet the defined business rules.

Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union for the transformation rules.

Perform testing on ETL Informatica process for various data loading scenarios.

Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice. Written multiple Test Cases for multiple transactions include 834 and 837 transactions.

Environment: Informatica PowerCenter, QTP, Business Objects, Oracle, Netezza, Flat files, SQL, PL/SQL, Java, XML, Agile, Shell Scripting.

Client: Banc of California, Wilmington, CA Oct 2014 to June 2016

Role: ETL QA Analyst

Project Description:

At Banc of California, your money has values as well as value. We know money deposited in a bank has the power to finance

positive change. So, we are taking action to support activities that help protect the planet, improve people’s lives, and

strengthen communities. We are redefining banking for a better future by focusing on areas where we believe we can have a

real impact: supporting energy transition, helping enable women entrepreneurs, and financing innovative start-ups.

Responsibilities:

Attending the agile/scrum meeting stand-up and present our testing status to scrum master.

Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.

Developed the detailed ETL Test Plan, Test Resource Utilization and Close Down document for multiple products.

Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.

Created and Developed Reports and Graphs using ALM.

Involved in automated Regression Testing using Quick Test Professional (QTP).

Created complex SQL queries for querying data against different databases for data verification process.

Extensively used the Sequential File, Dataset, Join, and Look-up, transformer, Funnel, Xml and Connector stages provided by Informatica to perform transformation and load the data

Develop and execute automation test cases by using Selenium WebDriver and TestNG.

Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.

Tested the extracted data from flat files and oracle database and tested the applied business logic on the transformations.

Tested mappings/Reusable Objects/Transformation/mapplets by using Informatica PowerCenter.

Created automation / manual test cases according to the user stories for different scenarios of functional and regression testing.

Verify the end-to-end ETL flow from source to target and validate the data transformations with different tools like IDQ, SSIS.

Validated the data on Front end applications to reflect the data on the back end using SQL queries

Expertise in planner/designer using mapping, transformations, data validation, oracle data warehouse builder.

Used schemas (XSD’s) to generate /mock request messages and ensured that the response conforms to schema definition and any defined mapping and transformation rules.

Used Filters and Assertions (XPathMatch) to compare the result of an XPath expression to an expected value

Identified critical integration points, data relationships between different operations within a service and other services and systems and developed test strategies & test cases accordingly for Integration testing.

Involved in Testing the Rest services in JSON Requests by using SoapUI.

Importing the WADL’s or (WADL Location URL) to SoapUI and execute the Rest web service.

Configured the DevTest to read the messages from Queues.

Coordinated with different teams involved in the project to get data required for Integration testing.

Using version control systems such as GIT and SVN for maintaining all the automation scripts.

Creation and execution of manual test cases in Quality Center

Tested various mappings in Powercenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformation

Defect tracking and Defect Report Generation are prepared using ALM and Quality Center

Analyzed test cases for automation and created scripts for regression testing using QTP 9.2. Automated Test cases for regression testing.

Worked in AGILE Methodology.

Environment: Informatica PowerCenter9.5, MS SQL Server 2012, Oracle 12c, Netezza, UNIX, Erwin Data Modeler 4.1, Windows 2008, API (Postman), Azure DevOps, SQL Server 2014, Oracle, SSIS, SSRS, Microsoft Office. QTP, XML, Agile, SQL, PL/SQL, Selenium WebDriver, TestNG, POSTMAN.

Education

Master of Computer Applications, Osmania University, India

Contact this candidate