We provide IT Staff Augmentation Services!

Etl Qa Tester Resume

Boston, MA

SUMMARY

  • 7+ years of experience in RDBMS technologies like Oracle 8.x/9.x/10g/11i/11g, DB2, MS SQL Server 2008/2005, and Teradata.
  • Around 7 years of experience in data warehouse concepts and technologies like OLTP, Normalization/Denormalization, ETL, OLAP, Data Models (Star/ Snow Flake Schemas), Datamarts (Dimensions and Facts) and Reporting.
  • Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
  • Good Experience in HIPAA /EDI Transactions and mainly focused on 835/837 and 277/276 Transactions.
  • Strong Understanding of Healthcare Business and have good knowledge of Members, Provider, Enrollment and Pharmacy claims.
  • Strong background in QA/ETL with development and execution of Test Cases and Test Scripts. .
  • Extensive Experience with the Utility Tools like TOAD, Teradata SQL Assistant, DB2 client, SQL Server Management Studio, SQL Developer, SQL* Plus, SQL*Loader, SQL Query Analyzer and Rapid SQL.
  • Experienced with ETL tools like Informatica, Datastage and Ab Initio GDE.
  • Experienced with Test Plan, Test Case, Test Script, Change Request and Defect Request.
  • Extensive experience with Unix commands and VI Editor, Bash Scripting.
  • Extensive experience with Reporting Tools like Confidential, Micro Strategy, SSRS, OBIEE, and Business Objects.
  • Expertise level knowledge in entire software development lifecycle (SDLC) process from business analysis to development, testing, deployment, documenting, maintaining and user training, experience on AGILE and SCRUM design methodologies.
  • Familiar with Excel for developing Requirements Traceability Matrix (RTM) and Capturing and Updating Change Requests.
  • Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
  • Familiar with managing the defects and change requests through Testing Tools like Quality Center/Test Director, Clear Quest and StarTeam.
  • Excellent experience with SQL concepts like DDL, DML, Sub queries, Joins, Set operators and Conditional expressions.
  • Experienced in querying the databases by developing and running SQL and PL/SQL queries using utilities like DB2 client, Toad and SQL Query Analyzer.
  • Documentation of Test Case, Test Scripts and Results using Excel.
  • Experienced with Transformations like Filter, Joiner, Union, Router, Look up and Sorter.
  • Experienced with System, Integration, Regression and User Acceptance Testing.
  • Excellent problem solving, interpersonal, and communication skills.
  • Experienced with data load into EDW tables in QA environment and Production.

TECHNICAL SKILLS

Testing Tools: HP Quality Center 9.2/8.0, Test Director, Clear Quest, HP ALM 11.0

Databases: Oracle 8i/9i/10g/11i, SQL Server 2008/2005, MS Access, DB2 9.7/8.0/7.0/6.0, Teradata 14.0/V2R5/V2R6,Netezza 3.0.5

Utility Tools: TOAD 8.5, Teradata SQL Assistant, DB2 client, SQL Server Management Studio, SQL*Plus, SQL*Loader, SQL Developer and SQL Query Analyzer, Advanced Query Tool, WRQ Reflection, Ultra Edit

ETL Tools: SSIS, Informatica 9.0, DataStage 8.7/8.0/7.1, Ab Initio 3.0.4

Reporting Tools: SSRS, Confidential, Business Objects, Micro Strategy, OBIEE

Operating Systems: Windows 95/98/2000/XP, Vista, 7, Linux and UNIX.

Microsoft Office: Excel, Access, Outlook and Power Point, MS Visio

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, Java, Unix Bash Scripting

PROFESSIONAL EXPERIENCE

Confidential, Boston MA

ETL QA Tester

Responsibilities:

  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Experience working in multiple projects.
  • Prepared Master Test Plan from the Business Requirements and Functional Specifications.
  • Strong Experience in writing Test cases, Test scripts, Test plans and execution of test cases
  • Good understanding of healthcare business process and terminology.
  • Worked with Rollup logics and Very large amount of data of the claims.
  • Experienced in defining, creating and implementing testing process and methodology for onsite/off-shore team.
  • Highly Experienced in HIPAA (Health Insurance Portability and Accountability Act), Health Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing.
  • Experienced in working with Members, Provider, enrollment and Pharmacy claims.
  • Experienced in creating test plan documents and also assisted in writing the test plan that includes Scope, risk, assumptions and test methodologies.
  • Experience in Agile methodologies and Participated in QA scrum meetings.
  • Writing the test cases covering the complete programming logic.
  • Experience in using Teradata SQL Assistant for Writing SQL Queries and executed them for Backend Testing
  • Created complex SQL queries using Teradata SQL Assistant.
  • Creating and executing SQL queries to validate test data using Advanced Query tool.
  • Created and Ran Unix Bash Scripts to validate the flat files.
  • Reviewed the HIPAA EDI transaction based on the implementation guide
  • Validated Prompts, filters, calendars and Cosmetics in reports.
  • Experienced with Unix basic commands like Grep, Awk, Sed and Diff.
  • Experienced with Informatica Workflow Monitor for reviewing session log files.
  • Written test cases to validate the ETL Informatica mappings and map lets.
  • Experienced with Informatica Power Center Workflow Manager for running workflows.
  • Written SQL Scripts to query the Teradata and DB2 database tables.
  • Ran the ETL jobs and reviewed the session log files using Datastage Director.
  • Tested Pre Engine, Post Engine and ETL load files Created using Datastage.
  • Used Inner join, Outer Join, Set operators and Case statements in SQL scripts.
  • Used PL/SQL function to validate some test scenarios.
  • Worked with various EDI transactions like 834,835,837,276,277 in accordance with HIPAA standards.
  • Validated Flat input source extract files by writing Unix Shell Scripts.
  • Tested ad hoc and canned reports for Business objects.
  • Responsible for testing Business Reports developed by Business Objects XIR2
  • Tested Business Objects reports and Web Intelligence reports
  • Implemented the HIPAA privacy and security regulations to enhance the capabilities of the systems
  • Experienced in creating test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center/HP ALM.
  • Written the complex SQL queries to validate the initial and incremental ETL loads.
  • Used Advanced Query tool for Data Analysts to compare DB2 and Teradata result sets.
  • Used Teradata SQL Assistant to write SQL and query the Teradata database tables.
  • Participated in Daily QA Scrum with QA manager to discuss the QA updates.
  • Preparing the QA and defect status report and updating the report in the project status meetings with project managers.
  • Experienced with HP Quality center and HP ALM for managing the defects and querying the Quality center for pulling Defect status reports.
  • Updating the Defect status reports in defect status call with the managers and following up on the defect status.
  • Interacted with developers to resolve the ETL and reports defects.

Environment: DB2 9.7, Teradata 14.0, SQL, Datastage 8.7, Teradata SQL Assistant 13.0, Advanced Query Tool, Ultra Edit, FTP Client WRQ Reflection, Unix bash Scripts, Quality Center 9.2, HP ALM, BI Reports, Business Objects XIR3.

Confidential, Atlanta, GA

Sr. ETL/DWH QA Analyst/Data load specialist

Responsibilities:

  • Working in DW - ETL Testing project, responsible for understanding the Business Requirements/Project Specifications.
  • As a Test member involved in the requirement gathering, effort estimation, planning, execution and implementation.
  • Worked with slowly changing dimensions (SCD), Change data capture (CDC) and Relation database systems.
  • Worked in mainframe environment and actively participated in analyzing the source data.
  • Manually executed the jobs and scripts in UNIX to load the historical data into EDW.
  • Prepared test cases for source to staging and staging to target based on the source to target mapping document.
  • Involved in Validating Slowly Changing Dimension type 1, type2 and type 3 based on the requirement.
  • Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
  • Assisted team lead in developing the Test plan as per the business requirements document.
  • Performed test execution by writing and executing complex SQL queries in TOAD, DB2 client.
  • Prepared test cases related to Data load testing based on different complex scenarios provided by Development team.
  • As per the requirement of the testing team created files in UNIX using VI editor based on the scenarios and loaded them into tables to test the scenarios.
  • Actively involved in analyzing the data load issues and job failures by checking the logs, Source files, Clean and Integration files.
  • Actively participated in Daily status meetings with Development team, DBA’s and business users to understand the requirements and discuss the issues and concerns.
  • Involved in verifying the logs on server and checking the Graphs and logic conditions applied in Ainitio GDE.
  • Executed the graphs from Ab initio GDE and command line.
  • Created number of defects in Clear Quest tool and coordinated with development team for defect fixes.
  • Tested Confidential reports by comparing it with legacy systems reports for data validation.
  • Validated prompts, filters and other features in Confidential reports.
  • Tested functionality and non-functionality of reports developed by Confidential .
  • Coordinated the defect tracking process in Clear Quest tool and provide the test metrics.
  • Reviewing the Test Cases & Execution Logs to ensure the test coverage.
  • Coordinated with the technical team, Business Users and QA team distributed across geographical locations.
  • Involved in preparing daily and weekly status reports and discussing it in the daily and weekly status calls.
  • Worked in Onsite-Offshore model.
  • Prepared Data load and Job failure analysis KT document and explained offshore team members.

Environment: Oracle 10g, DB2, Ab intito GDE 3.0.4, Confidential, Quest TOAD, Clear Quest, SQL, UNIX, Windows XP.

Confidential, MN

Sr. ETL/DWH QA Analyst

Responsibilities:

  • Prepared Test Cases by analyzing Business requirements and Functional Specification Document.
  • Design Specification Document to determine the functionality of the ETL Processes.
  • Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
  • Work with source system personnel on source data delivery issues .Interacted with DBA for setting up test environment.
  • Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
  • Executed SQL queries using SQL Server Management Studio to find useful test data to verify various functionalities of the application and also done the back-end verification.
  • Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
  • Performed database validation according to the business logic by comparing the source to the target in Spreadsheet.
  • Created ETL test data for SSIS Packages to test the functionality of business requirements.
  • Tested several complex reports generated by SSRS including Dashboard, Summary Reports, Master Detailed and Drill Down.
  • Tested T-SQL Packages that transform/load the staging data into schema using business logic.
  • Tested the ETL SSIS Packages by using complex SQL queries.
  • Involved in testing the SSRS reports by writing complex SQL queries.
  • Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
  • Worked with Users to develop Test cases for user acceptance testing.
  • Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD.
  • Involved in preparation of Requirement Traceability Metrics (RTM), Defect Report, and Weekly Status Reports using Quality Center.

Environment: SQL, SSIS, SSRS, SSAS, QTP, SQL Server Management Studio, OLTP, OLAP, SQL Server 2008, Toad, HP Quality Center 9.2, SQL, Windows XP

Confidential, CO

Sr. ETL/BI Tester

Responsibilities:

  • Analyzed Business requirement document to understand the Business process and prepared test cases.
  • Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
  • Used SQL for Querying the database in UNIX environment
  • Developed test cases for ETL process and reporting.
  • Conducted Black Box - Functional, Regression and Data Driven.
  • Involved with Design and Development team to implement the requirements.
  • Developed and Performed execution of Test Scripts manually to verify the expected results.
  • Functionality testing of email notification in ETL job failures, abort or data issue problems.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Involved in Manual and Automated testing Quality Center.
  • Used Informatica Power Center Workflow Monitor to review the session log files.
  • Experienced with Informatica Power Center Workflow Manager for running workflows.
  • Defects tracking, review, analyze and compare results using Quality Center.
  • Defined the Scope for System and Integration Testing
  • Document and publish test results, troubleshoot and escalate issues
  • Experienced with Unix environment and VI editor.
  • Used Toad to write SQL and query Oracle database.
  • Validated prompts, filters and other features in Confidential reports.
  • Tested functionality and non-functionality of reports developed by Confidential .
  • Optimizing/Tuning several complex SQL queries for better performance.
  • Created and executed test cases for ETL jobs to upload master data to repository.
  • Responsible to understand and train others on the enhancements or new features developed.
  • Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
  • Involved in Test Scheduling and milestones with the dependencies.
  • Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.

Environment: SQL, Informatica Power Center 7.1, Quality Center 9.0, Oracle 9i, Confidential, Toad, Unix, Windows XP.

Confidential, MN

ETL/Manual QA Tester

Responsibilities:

  • Exported Manual Test Cases from MS Excel template directly to Mercury Test Director and executed Test Cases in Test Director with Pass/Fail/Blocked status.
  • Performed database integrity checks, index and constraint checks using SQL.
  • Created Test Case documents in MS Excel template from the Test Plan, and the Business Requirements documents.
  • Queried Oracle and SQL Server databases using Toad and Management Studio.
  • Verified correctness of data after the transformation rules were applied on source data.
  • Executed SQL queries to validate the referential integrity rules as per the design specifications.
  • Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
  • Used Mercury Quality Center to document issues found during the test automation process.
  • Run the ETL jobs and reviewed the session log files using Datastage Director.
  • suggested appropriate solutions and prioritized defects for resolution in coordination with the development team
  • Updated QA Manager and Lead weekly with the testing status, which included Test Task Plan, Defect Management, and Test Metrics.
  • Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams.
  • Validated reports like Drilldown and Cross Tab reports developed by Business Objects.
  • Validated business objects reports using complex SQL queries.
  • Tested Drilldown and Cross-tab reports generated from Business Objects.
  • Validated cosmetics like font, color and page layout in Business Objects reports.
  • Submitted weekly defect and test status updates during the Defect Management meetings.
  • Performed Functional, Regression, Data Integrity, and User Acceptance Testing.
  • Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
  • Executed test cases for data validation, link verification, and content verification.
  • Performed the back end testing by using SQL Queries and verified the data integrity.
  • Participated in weekly meeting with QA, developers, analysts and management team.
  • Tested cosmetics like font and color in Business Objects reports.
  • Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Oracle 9i, SQL, Data Stage 7.1,Windows NT/XP/2000, SQL Server 2005, Test Director, MS Office Suite, Business Objects, Unix

Hire Now