We provide IT Staff Augmentation Services!

Sr.etl Qa Tester Resume

Denver, CO

Professional Summary:

  • 7 years of Professional Experience in Software Quality Assurance and Testing in Data Warehousing and Client - Server applications.
  • Extensive experience wif test plan, test cases, test scripts and defect management.
  • Extensive experience in all phases of testing like System testing, Functional testing, Integration testing, Regression testing, Performance testing and User Acceptance Testing (UAT).
  • 5+ years of experience wif Data Warehouse tools and technologies.
  • Excellent experience in analyzing Business Requirement Document (BRD) and Functional Requirement Specification (FRS).
  • Extensive experience wif RDBMS like Oracle, Teradata, SQL Server, DB2 and Sybase.
  • Experience wif ETL tools like Informatica Power Center, IBM Data stage and SSIS.
  • Experience wif Business Intelligence (BI) tools Business Objects, Cognos and SSRS.
  • Extensive experience wif database utilities Toad, SQL Server Management Studio, SQL Assistant, SQL Developer, SQL Plus and CDBS Studio.
  • Involved in Agile and Waterfall SDLC methodologies.
  • Experience wif SQL skills like inner, outer joins and set operators.
  • Experience in UNIX commands and shell scripting.
  • Extensive experience in reviewing Test Cases and Test scripts wif stake holders.
  • Experience in Performance Tuning of SQL queries using explain plan.
  • Excellent analytical, programming, written and verbal communication skills.
  • Experienced wif coordinating between offshore and onsite teams.
  • Experienced wif testing database and Front end applications.
  • Experience in Communications, Healthcare and Financial industries.
  • Experience in Data Models using Star and Snow Flake Schema.
  • Extensive experience wif ALM / HP Quality Center modules Requirements, Test Plan, Test Lab and Defect.
  • Experience wif test execution and Defect reports from Quality Center.
  • Experience in interacting wif users and supporting UAT.
  • Extensive experience in reviewing the release notes for both ETL and BI migrations.
  • Experience in developing SQL queries and PL/SQL functions.
  • Experience wif Teradata utilities Bteq, Fast Load, Multi Load and SQL Assistant.
  • Experience wif FTP tools like Putty and WinSCP.
  • Experience wif MS Office tools Word, Excel, Access, Outlook and Project.
  • Extensive experience wif creating and customizing the test data.
  • Extensive experience in finding the bugs and analyzing the root cause.
  • Experience in testing financial data warehouse applications.
  • Experience wif share point and client tools Remedy and Jira.
  • Strong analytical, programming, Problem Analysis and Resolution skills.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/NT/2003/2000, Linux and UNIX.

Databases: Oracle 11i/10g/9i, MS SQL Server 2008/2005/2000, IBM DB2 10.5, Teradata V2R6, MS Access 2008

ETL Tools: Informatica Power Center 9.1/8.6.1, Data Stage 8.5

Programming Languages: SQL, PL/SQL, Shell Script, C.

Testing Tools: HP Quality Center (ALM), QTP, Test Director, Rational Clear Quest

BI: Business Objects XI R3, Cognos, Micro Strategy, OBIEE

MS office: Excel, Word, Access, Outlook and Project

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr.ETL QA Tester

Responsibilities:

  • Analyzed business requirements and functional specifications.
  • Responsible for coordinating between ODS and EDW testing teams.
  • Tested Informatica job schedules and execution in UC4 client.
  • Developed test cases and scripts in Quality Center.
  • Reviewed test cases wif business analyst, developers and other stakeholders.
  • Performed Data Analysis for complex test scenarios.
  • Developed test plans and manually executed ETL and BI test cases.
  • Created and customized test data for validating few test scenarios.
  • Designed and kept track of Requirement Traceability Matrix.
  • Extensively used ms project to monitor and track tasks and resources.
  • Attended daily Agile Sprint meetings and updated the QA status.
  • Used Informatica Power Center Workflow Manager to run Workflows.
  • Used Informatica Workflow Monitor to monitor workflows and review session log.
  • Tested the ETL Informatica mappings using complex SQL queries.
  • Tested the performance of ETL jobs for several incremental loads.
  • Involved in automation of test cases using QTP.
  • Extensively written complex SQL queries involving Inner and Outer join.
  • Worked wif the co-testers closely in determining both medium and high severity defects, dat would potentially affect the downstream systems before the release of the project.
  • Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
  • Executed the test cases in Test Lab module in Quality Center.
  • Used Quality Center for creating and tracking the defects.
  • Performed data quality on source tables using SQL queries.
  • Extensively used Toad for Oracle and SQL Assistant utilities.
  • Developed test cases for Business Objects reports in Quality Center.
  • Experienced wif requirement Traceability Matrix (RTM).
  • Used Unix basic commands and vi editor for manipulating files.
  • Used commands like ls, wc, chmod and grep in UNIX environment.
  • Written SQL queries involving joins and aggregate functions to test the Business Objects reports.
  • Tested reports like Drill Down and Cross-Tab developed from OBIEE.
  • Tested cosmetics in OBIEE reports like page layout, color and font.
  • Tested OBIEE reports like Summary, Detailed, charts and dashboards.
  • Created Test Execution reports from ALM and reported to project team.
  • Interacted wif Business Analyst and developers in agile environment.
  • Performed function testing, regression testing and involved in UAT.

Environment: Informatica Power Center 9.1, Oracle 11i, Teradata V2R6, IBM DB2,Toad for Data, SQL, Analysts, SQL Assistant 13, MLOAD, Putty, Share Point, HP Quality Center 10, ALM, PLSQL, OBIEE 11.1, UNIX, Agile, MS Office, Remedy, Windows XP.

Confidential, Denver, CO

ETL QA Tester

Responsibilities

  • Attended regular meetings wif the team on Overview, Architecture and project plans.
  • Worked in an agile environment attending daily scrums and weekly meetings.
  • Actively participated in daily scrums and sending out weekly status updates.
  • Worked on a Global Direct project wif SAP as the main source.
  • Developed test cases, test scripts and validated data for different scenarios.
  • Worked on a project wif source and target data in different databases and environments.
  • Prepared test data for validations dat required supporting source data.
  • Used Informatica Power Center Workflow Manager to run the sessions and workflows.
  • Used Infromatica Power Center Workflow Monitor to monitor workflow status.
  • Experienced wif reviewing session log files in workflow monitor.
  • Used Toad for Oracle to prepare test scripts and execute them.
  • Worked wif complex SQL queries involving JOINS, Sub Queries, CASE statements, Filters and Set Operators.
  • Raised defects and documented them in Clear Quest.
  • Updated defects status in clear quest from time to time.
  • Worked wif ETL developers and Data Architects to resolve the defects in the SYS environment.
  • Developed test cases and SQL queries for OBIEE reports.
  • Tested font, color and headers in OBIEE reports.
  • Attended and presented my test cases in test review sessions.

Environment: Oracle 10g/11i, TOAD 10.5, Clear Quest, Windows 7, SQL, Informatica 8.6, OBIEE, Excel, Outlook, MS Office Communicator.

Confidential, Minneapolis, MN

ETL QA Tester

Responsibilities:

  • Participated in business requirement and design walk through and analyzed requirements.
  • Created test cases in excel and exported them to Quality Center.
  • Linked test cases wif requirement id in Quality Center for Traceability.
  • Worked wif business Analyst for change requests and new requirements.
  • Updated the test cases in Test Plan module for change requests.
  • Analyzed the data model Start Schema and developed test cases for data marts.
  • Worked wif ETL architects for understating ETL rules for audit columns.
  • Used Data stage Director to run and monitor the ETL job status.
  • Reviewed log files for ETL jobs in Data stage Director.
  • Testing Data stage ETL jobs using complex SQL queries.
  • Validated ETL jobs using complex SQL and PL/SQL queries.
  • Validated referential integrity between dimension and fact tables.
  • Executed the test cases status in test Lab module in Quality Center.
  • Involved in testing the Health care Claims Systems and EDI transaction sets.
  • Participated in Defect Meetings which included Project Management, QA and Development.
  • Executed Linux scripts from Unix environment and reviewed log files.
  • Used Unix for accessing and manipulating files for validating stage tables.
  • Reviewed Linux and bteq log files for session failures and workflow failures.
  • Customized the test data, executed ETL and validated test scenarios.
  • Written several complex SQL queries for validating Cognos Reports.
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Detailed, Drill Down and Cross-Tab.
  • Written several complex SQL queries for validating Cognos Reports.
  • Compared SQL result and report data in excel spreadsheet.
  • Worked wif business team to test the reports developed in Cognos.
  • Tested the performance of reports wif different volumes of test data.
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
  • Used Quality Center Defect module for creating and tracking defects.
  • Used Quality Center to track the defects and create test execution reports.

Environment: DB2, Oracle 10g/9i, Data Stage 8.5, Cognos, SQL, Teradata V2R4, Mload, Bteq, XML, UNIX, Toad, SQL Assistant, DB2, SQL Server 2008, MS Office, Share Point, Putty, Windows XP

Confidential, Durham, NC

ETL QA Tester

Responsibilities:

  • Involved in developing detailed test cases and test scripts using Quality Center.
  • Executed test cases in Test Lab module in HP Quality Center.
  • Reviewed the Source to target mapping document and analyzed the transformations.
  • Reviewed the test cases wif project stake holders and updated them as per their suggestions.
  • Involved in Design review meeting to understand the process flow of ETL Informatica Mappings.
  • Developed SQL queries based on source to target mapping document.
  • Designed and kept track of Requirement Traceability Matrix.
  • Used Informatica Power Center Workflow Manager to run Workflows.
  • Used Informatica Workflow Monitor to monitor workflows and review session log.
  • Reviewed the session properties and statistics in Informatica Workflow Monitor.
  • Tested the ETL Informatica mappings using complex SQL queries.
  • Used toad for running SQL queries against Oracle database.
  • Developed validations for stage tables against source files.
  • Used UNIX for accessing counting number of rows in source files.
  • Developed and executed test cases for financial data mart tables.
  • Participated in code migration meetings from dev to QA environments.
  • Tested Slowly Changing Dimension in type 1 and type2 based on the requirement.
  • Written SQL queries for validating data between stage and data marts.
  • Executed SQL queries in Toad and analyzed the data results.
  • Involved in time estimates for developing and executing the validations for ETL and reports.
  • Developed test cases and SQL queries for Business Objects reports.
  • Tested font, color and headers in Business Objects reports.
  • Tested data in Drill Down and Cross-Tab reports using SQL queries.
  • Validated several Business Objects reports like Summary, Detailed and Dashboards.
  • Submitted daily testing and defect status report to Project Manager.
  • Submitted Weekly QA status to QA manager.
  • Created and managed defects using Quality Center tool.
  • Created Test Execution reports using Quality Center.
  • Followed agile methodology and attended sprint meetings.
  • Involved in Functional testing, End to End testing and Regression Testing.

Environment: Informatica Power Center, Oracle 9i, SQL Server 2008, MS-Office, SQL, PL/SQL, Quality Center, XML, UNIX, Business Objects, Windows, Putty

Hire Now