ETL QA Tester
Company: Goahead Solutions
Posted on: January 14, 2019
GoAhead Solutions has an immediate need for an ETL Tester in Richmond, VA. This would be a Twelve-month contract to start out. We have several openings for this position.
-We*re looking for an ETL Tester responsible for creating an end-to-end test plan; executing the plan and managing all activities in the plan to ensure that all the objectives are met and that the solution works as expected. The solution should be tested in terms of functionality, performance, reliability, and stability.
-Ensure testing is well defined, planned, and executed; and that any potential issue is identified and fixed before the product goes live.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.
-Develop test plans, test cases, test scripts, and test reports on multiple projects of varying size.
-Execute and evaluate manual or automated test cases and report test results.
-Experience on ETL testing, and ETL tool and process
-Knowledge on basic Database objects and relational data model
-Experience on SQL query and script
-Testing experience with different file types
-ETL test validations and checks / Quality checks
-Test automation experience is huge plus
-Data profiling is plus
-Understanding of ETL requirements (source-to-target mappings)
-Experience on test data preparation/sampling
-Writing basic SQLs to check record counts, data truncation, invalid datatypes, NULLs and data integrity
-Basic test cases for a ETL process (for a ETL process that loads data from files to SQL database and vise versa)
-How ETL testing is different from functional testing
-Hold and facilitate test plan/case reviews with cross-functional team members.
-Ensure that validated deliverables meet functional and design specifications and requirements.
-Isolate, replicate, and report defects and verify defect fixes.
-Involved in the design of product and project requirements / user stories
-Experience working in a Agile development environment
-Identify test approaches, coverage, requirement gaps and risks and risk remediation
-Ensures quality measures are included in the initial project design.
-Writes detailed test strategies and plans, making full use of different test estimation techniques in assessing best balance of coverage and efficiency for a project or sprint
-Writes detailed test scripts to functionally and regression test the functionality of the proposed system and supported applications.
-Ensures requirements traceability and identifies areas for improvement.
-Preparation and management of complex test environments and test data conditions.
-Focuses on solution-oriented approach and identifies complete regression testing needs involving multiple parts of a product and system.
-Manages the validation test phase including executing scripts, logging and tracking problems found, and regression testing any changes made to the system.
-Able to design and manage automated test approach for tests and ensure that manual tests are automated using suitable tools and framework for the product.
-Reviews and approves and executes the Integration Test Plan and Procedures
-Validates the completion of Integrated Testing. Consults with development engineers in resolution of problems and suggest functional solutions.
-Develops, executes and analyzes the output from scripts that capture application and platform quality metrics.
EDUCATION AND/OR EXPERIENCE:
-Bachelor's Degree or equivalent experience in related field required.
-Experience in Quality Management Software and Processes.
-Knowledge and experience in technical aspects of software solutions.
-Backend database testing in Microsoft SQL environment.
-Strong organizational, planning, analytical, and communication skills.
-Excellent interpersonal skills necessary to interact with all levels of personnel.
-Business process understanding.
-Other related skills and/or abilities may be required to perform this job.
-5+ years Quality Assurance and/or systems / regression testing experience is required.
-Understanding and experience with platform and operating system / SQL DB architecture.
-Experience in working with Test Management and Defect Management Tools.
-Test automation experience or expertise in any scripting languages would be required.
-Developer in test experience
-Medicare Advantage Experience
-Experience related to Centers for Medicare and Medicaid Services (CMS) Regulations
-Experience with JIRA and Confluence - provided by Dice ETL Tester, QA, Informatica, Healthcare, SQL Database, SQL Query, Jira, Confluence
Keywords: Goahead Solutions, Richmond , ETL QA Tester, IT / Software / Systems , Richmond, Virginia
Didn't find what you're looking for? Search again!