We provide IT Staff Augmentation Services!

Etl Qa Tester Resume

Wilmington, DE

SUMMARY

  • Over 7 years of IT experience in various phases of IT projects such as Development, Testing, deployment and application support.
  • Hands on experience with all phases of Software Testing Life Cycle (STLC)
  • Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to functional QA requirements.
  • Expertise in creating Test plan documents and Test strategy documents.
  • Expertise in designing the test scenarios and scripting the test cases in order to test the application.
  • Expertise in QA process and different levels of testing like Functional, Regression, and Integration testing with business scenarios.
  • Strong experience with ETL systems, and having expertise with tools Informatica and Data stage.
  • Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
  • Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema
  • Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
  • Experience in maintaining Full and Incremental loads through ETL tools on different environments..
  • Experienced in Defect Management using ALM, HP Quality Center
  • Good experience in writing SQL in order to data validation in migration as part of backend testing
  • Good exposure with databases like Oracle 10g, DB2, SQL Server 2012
  • Good expertise in using TOAD, SQL*Plus and Query Analyzer.
  • Worked with different data sources ranging from VSAM files, flat files, and DB2, oracle and SQL Server databases.
  • Experience in debugging the issues by analyzing the SQL queries.
  • Good experience in working with UNIX scripts in executing and validating logs for the issues.
  • Experience with testing reporting tools (Cognos/Business Objects).
  • Excellent communication skills and Ability to work in - groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 9 / 8.6

Reporting Tools: IBM Cognos 8.1/Business Objects XI R2/R3

Database: Oracle10g/9i, SQL Server 2012 / 2005, IBM DB2, Sybase, Teradata 13 and MS-Access

Utilities: Toad, Citrix server, Oracle SQL Developer, SQL Advantage, Putty

Testing Tools: HP Quality Center 9.2 / 10 / ALM, TFS, JIRA, Clear Quest, Rational Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

ETL QA Tester

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 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
  • 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 document.
  • 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, Dash boards 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 Clear Quest.
  • 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.0 (ETL), AGILE, HP Quality Center 10, Business Objects XIR2, SQL Server 2012, TFS 2010, QTP, Toad for Oracle, ORACLE 11g, DB2, Teradata 13, UNIX, Autosys.

Confidential, Providence, RI

ETL QA Tester

Responsibilities:

  • Involved in the entire Testing Life Cycle of the projects from Initiation to Implementation.
  • Create test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.
  • Created and executed detailed test cases with step by step procedure and expected result. Maintained the test logs, test reports, test issues, defect tracking using Quality center 9.2.
  • Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify my test cases. Verify defects and Perform database functional, integration and regression testing as needed to minimize defects. Responsible for gathering requirements from the Subject Matter Expert (SME).
  • Performed execution phased: Executing test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
  • Participated in Risk Management to help determine best use of development and testing resources. Used Quality center, to manage the entire process and log in defects. Provide update to management on testing status and some other issues
  • Carried out and oversee test execution for Business scenario, User acceptance and Regression testing. Performed database validation according to the business logic by comparing the source to the target. Tested Data Warehousing application on Oracle Database.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Tested the data which loads from Source to staging.
  • Involved in SCD2 type dimension testing with start date and end date logic.
  • Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
  • Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
  • Written several complex SQL queries for validating Cognos Reports.
  • Good experience in validating the Adhoc and OLAP cube
  • Validated Cognos Standard Reports created based on Frame work manager and Cube.
  • Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
  • Tracked bugs using Quality Center and generated the defect reports for review by the client and the management teams.
  • 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.
  • Participate in weekly meeting with the management team and walkthroughs
  • Participated in various meetings and discussed Enhancement and Modification Request issues
  • Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

Environment: Oracle 10g, DB2, Teradata, Sql Assistance, AGILE, TOAD, Cognos8.1, Oracle 10G, Quality center 9.2, Informatica 8.6, UNIX.

Confidential, Richmond, VA

Backend tester / Data tester / ETL QA

Responsibilities:

  • Created Test Plan and developed test strategies.
  • Created Manual Test Suites for various modules.
  • Tested stored procedures & views.
  • Written SQL queries in order to data validation in migration as part of backend testing.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Extensively used SQL to verify and validate the data load.
  • Worked with developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Writing the test scripts for manual testing.
  • Worked on environment issues, Compatibility checks after post migration of applications to Unix to Linux
  • Worked with UNIX scripts in executing and validating logs for the issues.
  • Reported bugs and tracked defects using Quality Center 8.0 (Test Director)
  • Used FTP and Telnet protocols in order to migrate files to heterogeneous Operation systems like UNIX, Linux and windows.
  • Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
  • Involving in Functional testing, End to End testing and Regression Testing
  • Preparing and supporting the QA and UAT test environments
  • Understanding of Functional Requirement Specifications and System Requirement Specifications.
  • Responsible for creating Test Plans, Test cases, Test data based on functional and non-functional requirements (i.e. Interfaces) to test the Cognos reports
  • Tested reports from Cognos data warehouse system and used HP Quality Center for test cases execution and defect tracking.
  • Responsible for ETL batch jobs execution using UNIX shell scripting to load data from core database to Staging and Data mart tables.
  • Wrote Complex SQL queries to verify report data with the source and target system (data warehouse) data.
  • Assisted business users to execute UAT test scenarios and test data as part of Validation Testing
  • Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
  • Validating the data against staging tables and target warehouse
  • Find report defects and subsequently validating the fix, repeating the process until done.
  • Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
  • Perform system testing to ensure the validity of the Report requirements and mitigation of risks prior to formal acceptance.
  • Performed Interface and Integration(SIT) Testing
  • Extensively use SQL queries for data validation and backend testing.
  • Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
  • Preparing the SQL queries to fetch the data from databases

Environment: Informatica Power center 8.6, Oracle 9i/10g, TOAD for Oracle, Quality Center, Windows XP, UNIX

Confidential, Minneapolis, MN

QA Engineer

Responsibilities:

  • Was responsible for manual testing of the application.
  • Involved in writing Test Plans, Test Cases and Test Scripts.
  • Analysis of Physical Data Model for ETL mapping.
  • Worked as a team member for design and development of Finance Data Mart and integrating it with Global Data Warehouse.
  • Worked extensively with mappings using expressions, aggregators, filters, lookup and procedures to develop and feed Data Mart.
  • Worked with batch jobs and validated the reports.
  • Participated in System, Regression and Acceptance Testing.
  • Developed sample test data to be used for executing the tests.
  • Wrote SQL queries, PL/SQL procedures to ensure database integrity
  • Tracked defects and assigning bugs to developers for bug fixing.
  • Worked with all levels of management and resolved the issues found.
  • Discussed extensively with developers, customer care in depth about the problems in design, functionality to make the application more robust and user friendly
  • Communicate and work with people of all technical levels in a team environment.
  • Maintain excellent performance and exceed Client's expectations consistently throughout project.

Environment: Informatica Power Center 7.1, Oracle 9, TOAD for Oracle, Quality center, XML, SQL, PL/SQL, Stored Procedures, UNIX

Hire Now