We provide IT Staff Augmentation Services!

Etl Qa Tester Resume

North, CarolinA

PROFESSIONAL SUMMARY:

  • Over 8 +years of experience in the field of Information Technology with emphasis in Banking Industry, Telecom, Health Care Domain
  • Good knowledge on Actimize, a software tool for risk, compliance, and fraud prevention, working for financial institutions and government regulators
  • Extensive knowledge of understanding Software Development Life Cycle (SDLC), High Level Document (HLD), Test Script and Requirement Gathering.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting
  • Experience in SDLC and Agile methodologies such as SCRUM.
  • Extensive experience in preparing Test Plan, Test Cases and Test Scripts, QA status reports based on User Requirements and System Requirements Documents for Functional, Backend, Regression, Integration and end - to-end testing.
  • Good understanding of software Testing Methodologies like AGILE (SCRUM) and Waterfall.
  • Involved in System Testing, User Acceptance Testing (UAT), Black Box Testing, Stress Testing, Integration Testing, Database Testing and Data Driven Testing.
  • Expertise in testing Client/Server, GUI applications and Internet based business applications including development and implementation of test plans, test cases and test scripts.
  • Solid Experience on tools like Quick Test Pro (QTP), Quality Center, SharePoint and Clear Quest.
  • Experience in Writing automation scripts for various QTP Add-ins (Web, Java, Visual Basic, Flex,) and integrated the scripts with Test Director/Quality Center to manage the entire Automation testing process
  • Experience on writing complex SQL queries, sub queries to extract data from various source tables to perform database backend testing.
  • Created ETL test data for all ETL mapping rules to test the functionality
  • Tested the ETL mappings and other ETL Processes
  • Strong in Database Testing and writing the SQL queries. Good and Solid knowledge in the ETL Process
  • Skilled in data manipulation using SQL Queries, executing SQL procedures in database editors like TOAD, My SQL Server.
  • Experience in using Automation Tools such as QTP (HP), and Quality Center (HP). Expertise in testing web services using SOAPUI.
  • Extensively involved in data driven tests and parameterization and used multiple positive and negative data for same scripts.
  • Good team player and also have ability to work independently in a time sensitive environment. Strong verbal communicator, with analytical problem solving skills.
  • Ability to interact with developers, business analyst and product analysts regarding testing status and maintain detail QA documentation.

TECHNICAL SKILLS:

Testing Tools: TOAD, SQL*Plus, QTP, Quality Center, SOAP UI, XML Spy, HTML

Databases: Microsoft SQL Server Management studio, Oracle Database, DB2,SQL Developer

Browser: Internet Explorer, Safari, Mozilla Firefox, Chrome

Operating Systems: Windows 2000, Windows 2003

Web Services: XML, HTML, Soap UI

PROFESSIONAL EXPERIENCE:

Confidential, North Carolina

ETL QA Tester

Responsibilities:

  • Worked with business to understand the requirement and provide input from QA perspective.
  • Performed extensive back end testing on ORACLE and MS-SQL Server Databases using PL/SQL AND MS-SQL SERVER queries.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Used SQL effectively to set up test data conditions and analyzed test results. Used Quality Center for preparing the Test scripts.
  • Contribute and adhere to requirements Tractability Matrix ensuring quality delivery.
  • Performed End-to- End testing of application to cover source and partner system dependencies.
  • Worked extensively with Quality Center for requirements, Preparing Test cases, Executing, Defect openings and closings. Involved in defect triage meetings to discuss issues arising out of testing.
  • Involved in writing Test plans, Test cases and responsible for executing the Test Scripts.
  • Performed Smoke, Integration, Functional, Regression, and System testing.
  • Developed Test Scenarios from Functional Specifications Document (FSD) and Business
  • Requirement Document (BRD).
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
  • Worked closely with offshore and onshore development teams, Business Analysts on attaining testing goals, defect logging process and UAT support.
  • Use of tools including Autosys Scheduler and Work Load control center to perform job execution, Quality center for development and execution of test cases.

Confidential, Minneapolis, MN

ETL QA Tester

Responsibilities:

  • Involved in gathering and analyzing the Business & Technical Requirements.
  • Prepared the High Level Test Case design document. Involved in drafting the Test Plan.
  • Responsible for validation of complete end to end ETL process.
  • Responsible for writing the test cases using BRD and the mapping documents. Extensively used mapping documents for writing the sql queries.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Performed different validations on data to make sure the data between source and target are matched and also validated the counts to make sure data is not dropped off during ETL process.
  • Validated the staging tables along with target tables successfully.
  • Responsible for loading the inbound files (i.e. Extracting and Loading the data), setting up the metadata and test data preparation.
  • Extensively used Informatica client 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.
  • Responsible for validating the data transformation rules to make sure all are implemented correctly as per BRD.
  • Extensive knowledge of transformation rules verification processes and data comparisons. Extensively used Quality Center for creation and execution of test cases. Also created execution reports using QC Dashboard
  • Logged the defects in HP Quality Center.

Confidential, Phoenix, AZ

ETL QA Tester

Responsibilities:

  • Developed Test Plans, Test Cases, Test Scripts based on the Functional Requirement Specifications.
  • Extensively used ALM for scheduling test and defect tracking.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • Validate that all test case input sources and test case output results are documented and can be audited.
  • Analyzed ETL process Source to Stage and Stage to Target Mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied and target tables
  • Responsible for validation of complete end to end ETL process.
  • Responsible for writing the test cases using BRD and the mapping documents. Extensively used mapping documents for writing the sql queries.
  • Performed different validations on data to make sure the data between source and target are matched and also validated the counts to make sure data is not dropped off during ETL process.
  • Document any problems, and work with the project team to resolve problems identified during the tests
  • Sign off on all test cases by signing the completed test worksheets.
  • Developed SQL queries for Back-end testing/Database testing and participated in end to end testing
  • Accept the results on behalf of the relevant user population
  • Validated the source system data with the staging data using SQL scripts
  • Recognize any changes necessary to existing processes and take a lead role locally in ensuring that the changes are made and adequately communicated to other users
  • Performed manual and data validation testing.
  • Extensively testing all the services which were involved with multiple projects.
  • Experience in testing Web Services through XML
  • Responsible for setting up a project in SOAPUI using WSDL.
  • Selecting or Identifying areas for Automation
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • Designing & Implementing Test Automation Strategy.
  • Worked in an Agile environment
  • Involved in Daily & defect status review meetings
  • Performed Integration, Regression and UAT testing.
  • Attended daily Standup meeting with team members of Web team and developers to evaluate the project progress.
  • Used Windows SharePoint services for maintaining and uploading the Project Documentation (Requirements, Test Plan, Test Cases etc) and reporting the Weekly status report to the SharePoint Portal.
  • Coordinated closely with the developers during the testing life cycle and detecting bugs and raising the defect and assigning them to the developers.
  • Preparing daily status report and Test Close down Report.

Confidential, Windsor, CT

ETL QA Tester

Responsibilities:

  • Analysis and review of requirements specifications and technical design documents.
  • Development and maintenance of test strategy, test plan, test case design, traceability matrix and its execution using Quality center.
  • Performing Manual testing execution
  • Involved in Daily & defect status review meetings.
  • Created test plans and reviewed and updated all test cases in Excel and SharePoint, and managed the Requirements Traceability Metrics (RTM)
  • Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
  • Interaction with Business Consultant, Technical Architect, development team and multiple support groups for the technical data collection of testing data.
  • Development and maintenance of deliverables as per Target quality processes and policies.
  • Identifying and analyzing the test scenarios to be automated.
  • Execution of existing automated test cases using QTP.
  • Collecting Test Data for Data Driven Testing using QTP.
  • Debugging and Running Testing using Automation Tool QTP
  • Analyzing Test Results of the Automation Test Scripts.
  • Modifying Tests and performing RE & Regression Testing using the Automated Tool QTP.
  • Defect logging, tracking and management of defects through Quality Center.
  • Attending Iteration kick off meetings & Updating story cards as per the status for every month.
  • Preparing BAS (Business Assurance Strategy) document for all the releases

Confidential, Charlotte, NC

ETL QA Tester

Responsibilities:

  • Work as a QA Analyst on different projects for the Web based application written in Java
  • Analysis of mappings based on Facts & Dimensions from Source to target tables for directs moves and indirect moves based on transformation rules & lookup tables using ETL Process
  • Used MS Sql server Management studio for Creating & executing SQL queries for testing the conversation of the data
  • Performed GUI, Integration, Regression, and Negative testing on multiple projects
  • Created appropriate test cases and test scenarios and logged defects in Quality Center
  • Worked with the developers and Business group involved in production testing, was engaged in full cycle of testing from start to end
  • Communicated timely project status to appropriate levels of management
  • Worked in an Agile environment
  • Executed high risk testing in production environment on release day
  • Assured customer satisfaction with proper documentation and reports

Confidential

QA Tester

Responsibilities:

  • Reviewing business and technical requirements for completeness and testability.
  • Wrote detailed, comprehensive test cases based on marketing requirements using QC.
  • Performed manual testing to verify the functionality of the application by using positive and negative test data.
  • Involved in various project related discussions with developers and provided feedback about enhancing the application to meet future anticipated requirements.
  • Logging defects, issues and defect tracking.
  • Positive and Negative Testing was performed for the applications.
  • End to end testing for a major product release.
  • Responsible for providing status reports and final report of testing to the QA Manager.

Hire Now