We provide IT Staff Augmentation Services!

Senior Etl Qa/data Warehouse Tester Resume

Clevland, OH

SUMMARY:

  • Extensive experience in Software Quality Assurance and ETL Testing with strong knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Experienced in large enterprise organizations such as Confidential, Confidential, and Rent - A-Center.
  • Experience with Web application testing, Functional testing, Integration testing, data centric testing, System testing, Regression testing, coordinating User Acceptance Testing (UAT) and End to End testing.
  • Experience in Agile, Waterfall and V Model SDLC Methodologies.
  • Expertise in creating/developing Test cases, Test scenarios using standard and modular approach.
  • Expertise in writing simple and complex SQL, PL/SQL using TOAD, SQL Navigator and performed extensive Data analysis on the same.
  • Experienced working with Customer Information Data Mart for business reporting through MDM and Reference Data.
  • Experience in processes in implementing data quality, ETL and Meta data management.
  • Experience with Black Box testing, White Box testing, smoke testing, system integration, regression, acceptance and usability testing of ETL jobs.
  • Expertise in working with fixed length, delimited flat files and also worked with large volume of data in the database/data warehouse.
  • Experienced in testing Data warehousing integration services involving SSIS, Reporting Service: SSRS and SSAS and BI systems using Crystal Reports.
  • Extensively worked with batch scheduling tool Autosys to run and monitor the ETL and batch jobs.
  • Strong knowledge of Oracle utilities like and Export/Import Utility.
  • Expertise in Business Intelligence Applications using Business Objects, crystal reports.
  • Experience in testing/validating the Source, Stage and Target (End-to-End) data systems.
  • Experienced in working with Quality Center to store Business Requirements, Test Cases, Test Runs, and Test Results for every iteration and store defects and link them back to the requirements.
  • Expertise in Defect Tracking, Defect management and Bug Reporting using tools like HP ALM, Clear Quest, Test Director, Quality Center.
  • Experience in End-to-End testing of an application/process. Performed backend testing using SQL Queries and UNIX scripting.
  • Performed manual and Selenium testing of web based application.
  • In Depth knowledge of Logical/Physical data models involving facts and dimensions in Star and Snow Flake Schemas.
  • Worked With slowly Changing Dimension (SCD1, SCD2 and SCD3).
  • Ability to work as independent and team member in challenging and cross platform environment.

TECHNICAL SKILLS:

Testing Tools: HP ALM 11.0, HP Quality Center 10.0/Test Director, QTP

Databases /RDBMS: Oracle11g/ 10g, SQL Plus,PL/ SQL, SQL Server 2012/2008, SQL*Loader, Scrum, Agile, and Traditional Waterfall model, IBM MDM, IBM ISC.

Operating Systems: UNIX, Linux, Windows XP/2003 server, AIX

ETL Tools: Informatica 9.x/8.x/7.1, SSIS, Data Stage

BI Tools: SSRS, SSAS, Cognos, Business Objects, Crystal Reports

Other tools: Erwin, ER Studio, Info sphere Data Architect, MS Office, Excel, VBA, Visio

Languages: UNIX Scripting, Java Script, VB Script, Perl, SQL, MySQL, XML,SOA,Fitnesse.

Packages: MS Word, MS Excel, MS Access, and MS PowerPoint, TOAD, SQL Navigator

PROFESSIONAL EXPERIENCE:

Confidential, Clevland,OH

Senior ETL QA/Data Warehouse Tester

Responsibilities:

  • Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using Oracle SQL Developer.
  • Developed QA project plan, Test Plan, Test cases for the QA Phase of the global data warehouse.
  • Responsible in planning, controlling and monitoring and also managing the assigned project to meet project objectives.
  • Tracked the defects using HP ALM tool and generated defect summary reports.
  • Attended Daily Stand Up meetings and provided QA status updates on different user stories.
  • Actively participated in discussions with the onshore and offshore development teams, Business and Delivery manager, to make sure the testing efforts are covering change of scopes, updated user stories and other functional requirements and modifications.
  • Performed database testing including validating stored procedures, jobs, triggers and other DB objects
  • Perform full manual regression testing of MDM.
  • Prepared status summary reports with details of executed, passed and failed test cases.
  • Created project status dashboards and coordinate UAT signoff activities
  • Understand business transformation rules which are involved in developing the source to target mappings.
  • Developed and performed test cases for END to END testing using HP ALM and SQL.
  • Developed strategy to test development based testing & connect story card to collaborate system test work flow.
  • Detailed understanding of below apps. Which support automatic payment functionality.
  • SBR -Online Agency application, DAQ -Direct Sales online quoting application PolicyPro (Policy administration system -Enrollment & Policy servicing)
  • Responsible to Create Extract File for IDL claims data.
  • Worked in Regression suite for ISC(IBM Stewardship Center) manual Testing .
  • Automated test cases by using scripts or advanced tools like DBFIT / Fitness.
  • Responsible for complete End-to-End/User Acceptance testing activities.
  • Co-ordinate with Data Warehousing developers who extensively used Data stage to design mapping to move data from source to target database using Stages to do the functionality.
  • Created Test Cases and developed Tractability Matrix and Test Coverage reports.
  • Independently performed end to end testing for Claims and loyality eligilibility Level.
  • Performed front end, back end, GUI, Functionality, Security testing on the application.
  • Report UAT Test results to the management and business team with recommendations
  • Worked with non-transactional data entities of multiple data feeds for reference data and Master Data Management (MDM)
  • Responsible on Testing based on Change Requests and Defect Requests.
  • Co-ordinate with SME's to understand use cases & workflow of policy initiation & servicing process
  • Tested Extracted data from Customer SQL and migrated into Customer Hub(MDM).

Environment: Informatica 11.5x HP ALM, Oracle 11g, MS-Project,SQL/PLSQL, UNIX, Flat Files, SQL Server Integration Services(SSIS), XML Files, Shell Scripting, Fitnesse, SQL * Loader, Applications(DAQ,SBR,PolicyPro), IBM MDM.

Confidential, Plano, TX

Senior ETL/Data Warehouse Tester

Responsibilities:

  • Review and understand the ETL processes, functionality & identify test requirements and coverage.
  • Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica components.
  • Used SQL Developer to run SQL queries and validate the data loaded into the target tables.
  • Testing data migration.
  • Executed various PL/SQL stored procedures for dropping and recreating indexes on target tables and validating the same.
  • Developed Test Plans, Test Cases, and Test Scripts for SIT.
  • Created staging tables necessary to store validated customer data prior to loading data into customer interface tables.
  • Created Test Cases and developed Tractability Matrix and Test Coverage reports.
  • Extracted data from Oracle and migrated into SQL Server using SSIS.
  • Participated in developing the file management and FTP process for transmitting the files, also scheduled the daily batch process.
  • Worked from beginning of the project such as of Statement of Work (SOW) to post implementation of SDLC process.
  • Used Batch files for loading database tables from flat files using SQL*loader.
  • Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target tables.
  • Used Agile-testing methodology for achieving deadlines in UAT.
  • Worked on SQL scripts to load data in the tables in Test environment.
  • Tested ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Worked with data validation, constraints, source to target rows count.
  • Performed database validation according to the business logic by comparing the source to the target in Spreadsheet.
  • Tracked the defects using HP ALM tool and generated defect summary reports.
  • Validated that the data movement and transformations were done correctly.
  • Worked closely with team to create test scripts using IBM Rational Functional Tester and Rational Manual Tester.
  • Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
  • Prepared status summary reports with details of executed, passed and failed test cases.
  • Preparing the SQL script to verify data and validating data from source and target Through Toad.

Environment: Informatica 9.x, HP ALM, Oracle 11g, SQL/PLSQL, UNIX, Flat Files, C++ SQL Server Integration Services(SSIS), XML Files, Shell Scripting, TOAD, SQL * Loader.

Confidential, St. Louis, MO

Senior ETL/Data Warehouse Analyst

Responsibilities:

  • Analyzed Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
  • Prepared Test Plan from the Business Requirements and Functional Specification.
  • Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing
  • Worked with iterative development environment using Agile Methodology.
  • Tested different ETL process for various data loading scenarios.
  • Did testing on multiple Informatica mapping for data validation and data conditioning.
  • Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
  • Work with source system personnel on source data delivery issues and interacted with DBA for setting up test environment.
  • Validated Business Objects dashboard reports by writing several complex SQL queries based on reporting logic.
  • Worked with PERL scripts for data parsing, text processing and connecting to database.
  • Developed UNIX scripts to load extract files in to staging tables using SQL*Loader.
  • Executed SQL queries using TOAD to find useful test data to verify various functionalities of the application and also done the back-end verification.
  • Tested PL/SQL Packages to transform/load the staging data into schema using business logic.
  • Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
  • Performed database validation according to the business logic by comparing the source to the target in Spreadsheet.
  • Interacted with QA and Development Engineers to learn about work flow, analyzed the test process, and helped develop strategies for testing products and services in an agile environment.
  • Attended Bi-Weekly Defect Review and Defect Status meeting. Provide update to management on testing status and some other issues.
  • Worked with Users to develop Test cases for user acceptance testing.
  • Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
  • Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, and Weekly Status Reports using Quality Center.
  • Perform Data Quality integrity testing (completeness, conformity, consistency, accuracy, duplicates).
  • Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
  • Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
  • Understand business /transformation rules which are involved in developing the source to target mappings.
  • Verified data in target table populated correctly by writing complex SQL queries.

Environment: Informatica 9.x,HP Quality center10.0, Oracle 11g, Business Objects, SQL Plus, UNIX, Flat Files, XML Files, Shell Scripting,, XML, TOAD, SQL * Loader.

Confidential, Suffolk, VA

Sr ETL Quality Analyst

Responsibilities:

  • Reviewed the business requirements and ensure the testability of these requirements.
  • Developed QA project plan, Test Plan, Test cases for the QA Phase of the global data warehouse.
  • Responsible for coordinating off-shore and on-shore test resources.
  • Reported defects and status of the defects in HP QC.
  • Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files to SQL Server Database.
  • Validated the data transformations developed by Oracle stored procedures and Informatica.
  • Developed complex SQL queries to verify the data loaded into the target tables. Validate the test data using MS access, TOAD, UNIX & MS Excel.
  • Connect to telnet to the UNIX environment and download, transport test data files.
  • Coordinated and participated in generating the test data required for various test activities.
  • Generate QA progress reports on a daily, weekly and monthly basis.
  • Communicated risks and escalated issues to supervising Manager as required.
  • Built and performed test cases for END to END testing using JIRA and SQL.
  • Conducted walk through meetings with various teams in understanding the QA processes, bug life cycles, QA documentation.
  • Created test planning and participated in execution of Data centric testing and API testing using Test harness tool.
  • Performed database integrity check using SQL and Unix Shell Scripts
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
  • Involved in backend testing with SQL, check the data integrity and referential integrity.
  • Involved in validating various SSIS and SSRS packages according to functional requirements.
  • Gathered feedback from the manager to in corporate changes as required for the QA process documentation.
  • Escalated database downtimes and any issues that could potential create hindrance to testing progress.
  • Conducted pre-release meetings and documentation approvals.
  • Train users and help in conducting UAT.

Environment: Oracle 10g, SQL Developer, SSRS, PL/SQL, Informatica-9.1, UNIX, XML Files, HP Quality Center 10,Jira,MS Excel.

Confidential, San Francisco, CA

ETL QA Analyst

Responsibilities:

  • Involved in Data Validation using SQL queries.
  • Performed negative testing, to make sure validations are done properly.
  • 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
  • Involved in Data Validation with Business Team.
  • Used DATASTAGE as an ETL Tool for Developing the Data Warehouse.
  • Creating and executing SQL queries tco perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
  • Extensively involved in Extracting, Transformation and Loading of data to target oracle warehouse database.
  • Was responsible for Creating Job, Job Sequencers and Shared Containers.
  • Create Crystal Reports, which would facilitate decision-making. The Crystal Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc.
  • Worked with Data Warehousing developers who extensively used Informatica to design mapping to move data from source to target database using Stages to do the functionality.
  • Involved in writing complex SQL queries for extracting data from multiple tables.
  • Review the test cases written based on the Change Request document.
  • Performed manual and Selenium testing of web based application.
  • Testing has been done based on Change Requests and Defect Requests.
  • Preparation of System Test Results after Test case execution.
  • Used Test Director, to manage the entire process and log in defects
  • Effectively coordinated with the development team.
  • Created critical scenarios for each change request and defect request.

Environment: Oracle 10g, Crystal Reports, Informatica 8.1, SQL Plus, C++, UNIX Shell Scripting .

Confidential, Chicago, IL

Requirement Analyst

Responsibilities:

  • Interacted with Business Team, Business Requirement Gaps Analysis, Customer Experience and Impact Analysis of application.
  • Contributed to and monitored test planning, test preparation and scripting, and test execution according to define best practices, standards and procedures.
  • Interfaced regularly with peers and management regarding test related topics including the coordination of test related initiatives with QA Test Leads, Project Managers, Development Managers, and other QA Core team members (SDLC Team).
  • Assessed risk to quality service based upon results of verification and validation. Monitored adherence to established test standards and procedures. Standardized QA Process using Testing Methodology, Process Improvement.
  • Provided QA consultation services to support users of related test processes.
  • Managed verification and validation activities for production modifications in production enhancement, interact with user, involved in automation of health check of application.
  • Maintained document template libraries and internal project documentation like QA Test Plan, Local procedure, QA Test Results, etc.
  • Organized and/or facilitates team member training sessions in each new application to implement process.
  • Participated in both internal and external process improvement projects like QA, SIT, UAT Testing with business & Marketing and External Vendors team.
  • Knowledge of relational databases like Oracle Database 10g to validate data testing in back end using complicated SQL script using Oracle functions.

Environment: Oracle 10g, SQL, PL/SQL, Informatica-8.5, UNIX, TOAD, XML Files, VSAM Files, HP Quality Center 10, Shell Scripting

Hire Now