We provide IT Staff Augmentation Services!

Sr. Etl Sql Qa Tester Resume

Denver, CO

SUMMARY

  • Over 7+ years of experience as Quality Assurance Tester in Web applications, ETL and BI reports testing.
  • Hands on experience in functional testing, integration testing, system testing, back - end testing and regression testing.
  • Experience in writing test cases, test plans and test summary reports.
  • Proficient in writing complex SQL, PL/SQL queries and UNIX shell scripts.
  • Well experienced in writing complex SQL queries for extracting data from multiple sources.
  • Experienced in testing BI reports developed on Micro strategy, Business Objects, SSRS and Crystal Reports.
  • Hands on experience in writing SQL queries, Joins, Functions, Procedures, Packages, DBMS, RDBMS, and Triggers in Oracle and SQL Server databases.
  • Experienced in ETLdata validation in Informatica, Abinitio, Datastage, SSISETLenvironments.
  • Good Knowledge of Data Warehouse concepts.
  • Extensively used HP ALM/Quality Center for test cases development, execution, and defect creation, tracking and reporting.
  • Written cases to test application manually in Quality Center and automated using QTP
  • Work experience in testing application built on Java/J2EE, .Net technologies.
  • Good knowledge in Waterfall and Agile SDLCs and Quality Assurance Methodologies.
  • Team player and ability to work independently in a time sensitive environment.
  • Ability to learn and adapt new technologies in short time. Good organizational, communication and writing skills.

TECHNICAL SKILLS

QA Methodologies: Iterative, Agile, Waterfall and Spiral Methodology

QA Tools: HP - Quality Center, Rational - Clear Quest, QTP, JIRA

BI/Reporting Tools: Business Objects, MicroStartegy, IBM Cognos, Crystal Reports, SSRS

Databases: Oracle: 11g, 10g, 9i and 8i,Microsoft: MS Access, SQL Server 2005/2008, MySQL, Teradata13

Query Tools: TOAD, Rapid SQL, SQL Developer, Teradata SQL Assistant, SQL Plus, T-SQL

ETL Tools: Informatica Power Center 9/8.x/7.x, AB Initio, Data Stage 7.x/8.x, SSIS

Languages: SQL, PL/SQL, XML, C, .Net

Operating Systems: Microsoft Windows - 7,Vista, XP, 2000, NT 4.0, OS/2, UNIX - Sun Solaris, HP-UX

Others: MS Office, MS Project, PuTTY

DB Modelling tools: CA ERWIN, ER Studio

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. ETL SQL QA Tester

Responsibilities:

  • Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
  • Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
  • Developed Data warehouse ETL test cases using data dictionary/mapping documents to validate data integrity, data transformation covering mapping, transformations and business rules.
  • Developed reporting test cases using data reporting requirement documents and design mock ups to validate data integrity, data transformation covering mapping, transformations and business rules.
  • Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
  • Exported test cases written in MS Excel to HP ALM/QC using HP ALM Add-in to MS Excel.
  • Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
  • 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 in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
  • Wrote SQL and PL/SQL scripts to validate the database systems and for backend database.
  • Extensively used Data warehouse ETL tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
  • Used Shell scripts extensively for automation of file manipulation and data loading procedures.
  • Developed & executed complex SQLs in TOAD to verify the mapping, transformation of data in source tables to target tables; and all the reports (ad-hoc and standard).
  • Executed test cases and created & tracked defects in HP ALM/QC.
  • Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data.
  • Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects.
  • Executed and monitored workflows for test execution through Data warehouse ETL Informatica Power Center.
  • Generated test cases execution report and defects report in HP ALM/QC and provided daily status reports.
  • Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities.
  • Participated in defect review and project status meetings.

Environment: ETL Informatica Power Center, BI Business Objects, SQL, PL/SQL, HP Quality Center/ALM, Erwin, Ms Excel, QTP, Oracle 10g/9i, Teradata utilities, TOAD 8.0, UNIX, Agile, Windows

Confidential, Minneapolis, MN

Sr. ETL SQL DWH QA Tester

Responsibilities:

  • Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
  • Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
  • Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
  • Managed multiple OLAP and Data warehouse ETL projects for various testing needs.
  • Performed extensive Data Validation, Data Verification against Data Warehouse
  • As a Data warehouse ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.
  • Tested and validated the Business Objects reports by running similar SQL queries against the source system(s).
  • Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
  • Tested several Informatica Mappings to validate the business conditions.
  • Performed Backend testing by writing SQL queries and running PL/SQL scripts in TOAD.
  • Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center
  • Involved in writing Test scripts for various test scenarios using QTP tool and in creation of Automation frame work.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Tested ad hoc and canned reports for Business objects.
  • Identifying duplicate records in the staging area before data gets processed
  • Extensively written test scripts for back-end validations
  • Interacting with senior peers or subject matter experts to learn more about the data

Environment: Informatica 8.6.1, Business Objects, Quality Center, QTP, Teradata 13, Teradata SQL Assistant 6.0, Oracle SQL Developer 9i/10g, PL/SQL, Agile, IBM DB2.

Confidential, Tampa, FL

ETL SQL QA Test Analyst

Responsibilities:

  • Participate as DE team member to understand changes to the design of database to test the optimum throughput.
  • Tested procedures, functions, triggers, log alerts and batch job generated log files, and user errors.
  • Involved in the error checking and testing of the Data warehouse ETL procedures and programs Informatica session log.
  • Validated the Data warehouse ETL Informatica scripts for data conditioning, transformation, validation and loading.
  • Developed test scripts using SQL and PL/SQL according to the mappings and rules specified in mapping document.
  • Tested complex PL/SQL packages and validated data to verify source to destination as per business logic
  • Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data.
  • Tested a number of complex Data warehouse ETL Informatica packages for initial and daily data loads
  • Developed and Executed Test Plan & Test Script in Quality Center.
  • Used Business Objects OLAP Intelligence to natively access and analyze OLAP servers
  • ETL Informatica process was used to extract data from different source systems to loaded one DB system, generated test cases and test plans to test point to point data conversion and counts and column mapping mechanism.
  • Performing smoke test by running QTP scripts.
  • Tested ad hoc and canned reports for Business objects.
  • Experience in working with Logical model of the business flow, and Entity relationships, constraints and build test cases before the release build is ready.

Environment: Informatica Power Center 8.6.1, BI Business Objects, HP Quality Center 9.2, QTP, VISIO, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 9i/10g, .Net, PL/SQL, Agile, IBM DB2.

Confidential, Charlotte, NC

ETL QA Tester

Responsibilities:

  • Coordinated with tem to Design and Create test plan, test scenarios and test cases for Data warehouse and ETL testing.
  • Responsible to translate business requirements into quality assurance test cases
  • Review of test scenarios, test cases and Data warehouse Test Results.
  • Developed test scripts using SQL queries to validate data.
  • Involved in writing Test scripts for various test scenarios using QTP tool and in creation of Automation frame work.
  • Responsible in testing Initial and daily loads of ETL jobs.
  • Interacted with design team to decide on the various dimensions and facts to test the application.
  • Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
  • Extensively usedRational Clear Questto track defects and managed them.
  • Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
  • Extensively tested several MicroStrategy Reports for data quality, fonts, headers, footers, and cosmetics.
  • Tested Informatica mappings for various ETL functions.
  • Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
  • Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities
  • Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: Oracle 9i/10g, PL/SQL, IBM DB2, Informatica Power Center, Erwin, SQL Developer Rational ClearCase, Quality Center, QTP, TOAD, SQL Server 2005, Unix, Win XP

Hire Now