QA Data Tester - ETL / SSIS / Regression Testing

Data Quality Test Engineer Contract

Role can be remote

The Test Engineer will be responsible for ensuring the successful implementation of new features as well as improvement of existing functionality for data architecture projects. This includes Integration testing, Customer Data Quality testing, Data verification testing, Regression testing etc.

This is a hands-on testing position which requires deep knowledge and understanding of all aspects of developing and executing Back-end testing. The Test Engineer must be an advocate for all things Testing and Quality Assurance while driving and implementing best practices. The ideal candidate must possess strong analytical and critical thinking abilities. Data testing skills are required.

Duties and Responsibilities

• Review business requirements, functional specifications, use cases, design, and architecture documents to create effective, value-add test plans.
• Identify and close gaps, by assisting in QA discovery or analysis of a built or process, in order to facilitate requirements refinements.
• Identify issues in data, application configurations and screen designs, report and oversee issue resolution.
• Become an expert in business rules, system functionality and architecture.
• Plan and execute Manual, Functional, and Regression test suite.
• Independently develop, modify, and execute test plans based on requirements and design documents.
• Contribute to and maintain project documentation.
• Provide concise and consistent status reporting.
• Identify, report and track defects and User Experience issues through a system of record.
• Collaborate with external teams on root cause analysis.
• Maintain close interaction with business and technical peers during the project life cycle.
• Ensuring proper traceability from requirements to test artifacts.

Position Requirements

• Bachelor's degree
• At least 3-5 years of testing experience in data or ETL projects.
• Strong experience with writing queries in relational databases like Oracle and SQL server.
• Familiar with SQL server queries including calling stored procedures by passing parameters, functions, views, and indexes to be used during ETL process.
• Possess extensive and in-depth knowledge of developing SQL scripts using SQL functions, grouping operations, sub queries, analytical function and joins to test ETL projects.
• ETL testing using SQL server Integration Services (SSIS) and SSRS.
• Experience in testing database applications to validate source to destination data movement and transformation.
• Knowledge of automated data testing is preferred.
• Hands-on experience in Planning and Manual test execution.
• Experience in Regression Test Strategies, Regression suite maintenance and execution.
• Hands-on experience with Jira, ALM, TFS/ADO or similar systems of record.
• Understanding of Development and Test cycles, including respective best practices.
• Hands-on experience in Agile and Waterfall methodologies.
• Ability to troubleshoot issues, identifying root causes and support development team in development of resolutions.

Strong communication and Client/Business interfacing and interpersonal skills are a must