We provide IT Staff Augmentation Services!

Etl Qa Tester Resume

3.00/5 (Submit Your Rating)

Jacksonville, FL

SUMMARY

  • Over 7 years of experience in Quality Assurance and Software Testing of various business applications inClient/Server environments, Web - based applications, Data-Warehousing solutions, ETL and Business Intelligence solutions.
  • Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
  • Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
  • Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.
  • Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management)
  • Worked with ETL group for understanding Data Stage graphs for dimensions and facts
  • Expert level skills in testing the Enterprise Data Warehouses using Informatica Power Center, Data Stage, AB Initio and SSIS ETL tools.
  • Experience on UNIX commands and Shell Scripting
  • Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, Recovery Testing and GUI Testing.
  • Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
  • Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture.
  • Have experience in testing reconcile (initial) and delta (daily) loads.
  • Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
  • Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports.
  • Experienced in using the Oracle SQL* Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
  • Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Test Director, Clear Quest.
  • Expert in writing complexSQL queries for back-end testing.
  • Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
  • Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
  • Have experience working in Agile/Scrum Methodology.
  • Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

QA Methodologies: Iterative, Agile, Waterfall and Spiral Methodology

QA Tools: Hewlett Packard (HP) - Quality Center, Test Director IBM / Rational - Clear Quest

ETL Tools: Informatica Power Center 9.x/8.x/7.xData stage 8.x/7.x, Ab Initio 2.x, SSIS

BI/Reporting Tools: Cognos, Micro Strategy, Business Objects, SSRS,OBIEE

DBMS Tools: TOAD, SQL Developer

Operating Systems: Microsoft Windows - Vista, XP, 2000, NT 4.0, OS/2

UNIX: Sun Solaris, HP-UX

Databases: Oracle 10g, 9i, 8i

Microsoft: MS Access, SQL Server 2005/2008

IBM: DB2, DB2/UDB, Teradata V2R6, V2R5

Languages: SQL, PL/SQL

Version Control Tools: Clear Case, Requisite Pro

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville FL

ETL QA Tester

Responsibilities:

  • Designed and Created 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.
  • Created and Developed Reports and Graphs using ALM.
  • Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
  • Interacted with design team to decide on the various dimensions and facts to test the application.
  • Different Data Stage components especially are used effectively to develop and maintain the database
  • Used Quality Center to track and report system defects
  • Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
  • Have tested SSIS packages according to business requirements and data mapping requirement documents.
  • 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 Business Objects Reports for data quality, fonts, headers, footers, and cosmetics.
  • Extraction, Transaction and Loading was done using different Components and different expressions using Data Stage to create test data.
  • Extensively involved in testing theETLprocess of data sources, SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
  • Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
  • Responsible for documenting the process for future references.
  • Extensively used Data Stage for extraction, transformation and loading process.
  • Worked with ETL group for understating Data Stage.
  • Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities
  • Defect tracking and Defect Report Generation are prepared using ALM and Quality Center
  • Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: Data Stage 8.5, Quality Center & ALM 11.0, Business Objects, Rational Clear Case, Rational Clear Quest, Rational RequisitePro, TOAD, JCL, Web Logic, Java, Oracle 10g/9i, SQL Server 2005, PL/SQL, Linux, Win XP

Confidential, Boston MA

Sr. ETL Tester

Responsibilities:

  • Analyzed the Requirements from the client and developedTest cases based on functional requirements, general requirements and system specifications.
  • Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
  • PerformedSmoke Testing, GUITesting, FunctionalTesting, Backend Testing, System Integration Testing, Sanity Testing,andUser Acceptance Testing (UAT).
  • Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
  • Strong in writing UNIX shells scripting. Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
  • Verified session logs to identify the errors occurred during the ETL execution.
  • Created Test Cases, traceability matrix based on mapping document and requirements.
  • Performed complex data validation using SQL queries.
  • Written several complex SQL queries for data verification and data quality checks.
  • Developed test plan with testing scenarios from theend user perspective for User AcceptanceTesting (UAT).
  • Defects found tracked and managed in Quality Center and disposition in defect scrub meetings
  • Used Data Stage Director to run/monitor the ETL jobs and tested the functionality according to data mapping requirements
  • Worked on data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Preparation of System Test Results after Test case execution.
  • Used Data Stage Director to validate, run and monitor the Data Stage jobs.
  • Effectively coordinated with the development team for closing a defect.
  • Extensively used Data Stage for extraction, transformation and loading process.
  • Prepared Test Scenarios by creating Mock data based on the different test cases.
  • Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
  • Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
  • Have tested reconcile and incremental ETL loads for the project.
  • Tested data migration to ensure that integrity of data was not compromised.
  • Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
  • Extracted data through an ETL tool in order to produce an XML file and validated XML and XSD files.
  • Used Rational Clear Quest as defect tracking tool.
  • Before the Load is accepted to test, have performed smoke or shake-out test.
  • Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
  • Tested several ETL job activity for data stage using Data stage designer
  • Done data validation for the Cognos reports.
  • Tested reports in Cognos using Analysis studio, Report studio and query studio.
  • Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 10g, Data Stage 8, Clear Case, IBM Cognos 8.0, Clear Quest, SQL, PL/SQL, UNIX, Putty, TFS Defect tracking tool, Teradata V2R6, Session log files, Flat files, XML, XSD, XSLT, HP Quality Center, Web Services, SQL Server 2008, and TOAD.

Confidential, Arlington VA

ETL/BI Tester

Responsibilities:

  • Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
  • Gone thru the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
  • Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
  • Closely went through and worked on all the stages of SDLC for dis project and designed and executed Functional, Integration, Regression, System (End to End), Backend (Database).
  • Quality Center used for Test Cases development and test execution status tracking
  • Developed and executed test cases and test scripts.
  • Extensively used Informatica Workflow Manager to run the workflows.
  • Monitored the session logs/log files in Informatica Workflow Monitor.
  • Tested theETLInformatica mappings and otherETLProcesses (DW Testing).
  • Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.
  • Involved in testing the batch programs by using the Autosys tool.
  • Worked with the UNIX shell scripts.
  • Used HP Quality Center as test management tool.
  • Tested Cognos Reports according to the business requirements.
  • Exclusively used Analysis Studio and Report Studio to test the Cognos Reports.
  • Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed,Drill down.
  • Prioritized the test cases based on the projected metrics and project deadlines.
  • Worked with Developers on Defects until the test case is passed.
  • Extensively written SQL to confirm the data transfer from source to target.
  • Involved in Testing SSIS Packages, and also involved in Data Migration.
  • Tested the PL/SQL procedures, functions, packages according to the requirements.
  • Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
  • Verified test results (viewing the log files using VI editor, querying the database using the SQL) documenting the defects.
  • Involved in testing the UI screens, reports which was used by the internal business team.
  • Effectively coordinated with the development team for closing a defect.
  • Prepared Test Scenarios by creating Mock data based on the different test cases.
  • Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Informatica Power Center 8.6, Cognos, Rational Clear Case, Rational Clear Quest, Rational RequisitePro, TOAD, JCL, Web Logic, MS Access, Oracle 10g, SQL Server 2008, SSIS, Autosys, DB2, PL/SQL, Linux, UNIX, PuTTY, Flat files, Session Logs, SQL scripts, HP Quality Center.

Confidential, Hartford, CT

ETL Tester

Responsibilities:

  • Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
  • Responsible for review of Functional Requirement Specification and System Design Specification documents for testing
  • Performed extensive manual testing on critical functionalities of the application.
  • TestedETLmappings to extract and load data from different databases such as Oracle, SQL Server and flat files and loaded them in to Oracle.
  • Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
  • Involved in testing the ETL mappings, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do; whether the mapping work correctly in relation to other processes in you're data logistical flow.
  • Tested Informatica mappings for various ETL functions.
  • Experienced in analyzing the issue by checking the log files in the AIX environment.
  • Used Mercury Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
  • Extensive querying using TOAD to run SQL queries and monitor quality & integrity of data.
  • Tested data and cosmetics of MicroStrategy reports.
  • Actively participated in creating requirements Traceability matrices and Test plans
  • Performed Unit and functional testing for all the Mappings and Sessions.
  • Implemented automated Processes & scheduling using Autosys.

Environment: Oracle 9i, SQL Server 2005, Informatica, Micro Strategy, SQL, PL/SQL, Autosys, Rapid SQL, Mainframes, Toad, IBM AIX, MS Access, Web Services, Unix, Mercury Quality Center

Confidential, Chicago, IL

Manual Backend Tester

Responsibilities:

  • Involved in business processes and quality assurance on testing across entire product life cycle stages from requirements to implementation.
  • Analyzed the business requirements, prepared Test Cases and Test Scenarios based on technical requirements.
  • Used Test Director for Test Management and Clear Quest for defect tracking.
  • Reviewed UML diagrams, Use cases, ER and Data models for writing test cases.
  • Have written SQL queries to perform the data validation.
  • Actively involved in Review meetings and walkthroughs.
  • Tested the reports and forms based on report specifications.
  • Prepared test summary reports after executing of scripts from the Test Director.
  • Extensively used UNIX commands for fetching and checking the Log files.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Prepared test summary reports, test readiness review documents and maintain test environment for test execution.
  • Effectively coordinated with the development team for resolving defects.

Environment: Oracle 8i, SQL Server 2003, SQL, PL/SQL, TOAD, IBM AIX, MS Access, Unix log files, ClearCase, ClearQuest, Reports and Forms, Test Director.

We'd love your feedback!