We provide IT Staff Augmentation Services!

Datawarehouse Tester Resume

NJ

SUMMARY

  • Over 6 years of IT experience in various phases of IT projects and experience with all phases of Software Testing Life Cycle (STLC)
  • Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
  • Knowledge in Dimensional Data Modeling using Star and Snow Flake Schema
  • Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
  • Expertise in creating Test plan documents and Test strategy documents.
  • Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
  • Good experience in writing SQL in order to data validation in migration as part of backend testing
  • Experience in maintaining Full and Incremental loads through ETL tools on different environments.
  • Good exposure with databases like Oracle 10g, DB2, SQL Server 2005
  • Experience in debugging the issues by analyzing the SQL queries.
  • Good expertise in using TOAD, SQL*Plus and Query Analyzer.
  • Experience with testing reporting tools (Cognos/Business Objects).
  • Expertise in QA process and different levels of testing like Functional, Regression, and Integration testing with business scenarios.
  • Expertise in designing the test scenarios and scripting the test cases in order to test the application.
  • Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to functional QA requirements.
  • Experienced in Defect Management using HP Quality Center
  • Experience in analyzing defect severity, priority and documentation and scheduling for the fix.
  • Experience in release management and defect control management.
  • End to End responsibility to close the defects and fixes.
  • 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 Tools: Informatica Power Center 8.6/ Datastage 8.1

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

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

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

Testing Tools: HP Quality Center 10/9.2/Test Director, Clear Quest, Rational Clear Case

Programming Lang: SQL, PL/SQL, C, C++

PROFESSIONAL EXPERIENCE

Confidential, NJ

Datawarehouse Tester

Responsibilities:

  • Developed Test Strategies and Test Plans and implemented all the test scripts
  • Designed the Test Plan/Test Cases according to the Business Requirements.
  • Analyzed data and ensured the data is accurate.
  • Expertise in setting up testing environments for Data Warehouse applications.
  • Proficient knowledge of Datawarehouse and Datamart concepts.
  • Compared record counts between the Source, Staging and Target in the Datawarehouse and the rejected records as a part of ETL Testing.
  • Validated business rules/ Transformation logics based on mapping documents.
  • Expertise in writing Complex SQL Queries to validate the data in the datawarehouse.
  • Check for the CDC applied to the tables in the Database.
  • Managed all loading process and data transformations
  • Performed different types of testing’s like System Testing, Regression Testing and Unit Testing.
  • Extensively Used Informatica power center tools (Designer, Repository Manager, Workflow Manager and Workflow Monitor)
  • Verified the internal mappings between the databases.
  • Tested the data in Database daily, weekly and monthly.
  • Used Infoview to get the reports for the data from the Datawarehouse and Datamart load.
  • Performed Databases Restores and Backups for testing purpose
  • Documented all the issues and bug fixing and the results for the data.
  • Follow up with developers on the issues that were causing problems in testing.
  • Conducted Walk-through sessions with Project Manager and the Team to get approved of the Test Plan documents and Strategies used to test

Environment: SQL Server R2, Oracle 11g/ Informatica Power center 9.1 tools, Infoview, MS office Suite. HP Quality Center 10, Windows 7, Business Objects

Confidential, Denver, CO

Datawarehouse Tester

Responsibilities:

  • Communicate directly with different business owners in the company to understand product and system requirements
  • Performed system testing, Integration testing, and Regression testing.
  • Performed data validation and data accuracy tests for the data both for the historical load and incremental load.
  • Used SQL queries to extract data from the target tables to prove the data mapping.
  • Validated Data in Database using SQL queries
  • Validated business rules by using SQL.
  • Defect Tracking and reports are done by JIRA/Quality Center.
  • Involved in extensive DATA validation on data marts by using SQL queries.
  • Expertise in writing SQL Statements in database to make sure whether the data is populated in DataMart/Data warehouse according to Business Rules.
  • Involved in SCD2 type dimension testing with start date and end date logic.
  • Validated Business Objects reports by running the SQL queries based on the business rules.
  • Experienced in Defect Management using HP Quality Center
  • End to End responsibility to close the defects and fixes.
  • Participate in weekly meeting with the management team.

Environment: SQL SERVER 2008,Business Objects XI R3,Microsoft Visio, Microsoft Outlook, Office Communicator, MS Office Suite, HP Quality Center 10,Jira Defect Tracking System, WINDOWS 7.

Confidential, Greenwood, CO

Datawarehouse tester

Responsibilities:

  • Involved in the entire software development and Testing Life Cycle of the projects from Initiation to Implementation.
  • Create test plan and test cases for manual 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 10
  • 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.
  • 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, Staging to warehouse and warehouse to mart.
  • Involved in SCD2 type dimension testing with start date and end date logic.
  • Test the data which loads Weekly and Monthly.
  • 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.
  • 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.
  • 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.
  • 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
  • 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: HP Quality center 10, Datastage 8.1.1/8.5, Oracle10g, Cognos8.1/10, DB2 8,Toad, Windows NT/2000/XP, UNIX, MS Office Suite 2010

Confidential, Ashburn VA

Datawarehouse tester

Responsibilities:

  • 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.
  • Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
  • Communicate directly with different business owners in the company to understand product and system requirements
  • 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.
  • 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 Datawarehouse/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.
  • Rational Clear case is used to Controlling versions of all files & Folders (Check-out, Check-in)
  • Performed the tests in both the SIT, QA and contingency/backup environments

Environment: Informatica Power center 8.6 (ETL),HP Quality Center, Rational Clear Quest, Rational Clear Case, Business Objects XIR2, QTP, Toad for Oracle, ORACLE 9i, Unix, Autosys, Windows XP.

Hire Now