This is a hands-on position with a primary focus on leading and executing testing in conjunction with the project team and project business owner. This position will be responsible for performing all facets of data testing: quality standards, controls, and procedures. The Quality Assurance Senior Specialist will have the technical knowledge to support quality assurance aspects of all ETL (extract, transform, load) platforms and coding in registry data projects. The position selectee must function as a team member, and work to maintain a positive work environment.
This position is based in Washington, DC where we have a hybrid work environment (average of 2 days a week in office).
Major Duties and Responsibilities:
- Create and execute test plans and scripts that will validate the project's data quality and data integrity as the data is transitioned through the ETL data warehouse process.
- Analyze documentation and technical specifications to ensure that quality assurance activities allow the ETL process to meet business requirements and systems goals, fulfill end-user requirements, and identify existing or potential issues
- Test the compliance of information flows and data stores against data quality standards.
- Provide risk assessment during project planning and development
- Create and maintain test documentation and test plans, plus work with the project team to create a suite of test data to exercise data validation and ETL functionality
- Create and execute SQL queries as needed to validate that test results match expected results
- Identify and log defects and when necessary, use SQL to narrow down the root cause of the defect issue
- Work closely with the scrum team to analyze, debug and resolve any issues
- Effectively communicate test progress, test results, and other relevant information to project stakeholders and management
- Enforce and monitor adherence to quality standards
- Create and execute regression test scenarios
- Other duties as assigned
Desired Qualifications:
- Bachelor’s Degree in information technology, computer science, statistics or similar technical degree
- Five + years of testing/development experience using SQL Server with the following highly desired
- Data warehousing and data modeling
- Strong knowledge of aspects of Data validation testing
- Strong experience testing data exchanges with XML
- Strong knowledge of aspects of ETL program testing
- Experience writing and executing complex SQL queries using views/tables
- Detail-oriented, with excellent organizational skills and able to manage multiple issues simultaneously
- Excellent diagnostic, problem-solving and debugging skills.
- Knowledge of applicable data privacy practices and laws a plus.
- Experience with the Altova Suite of products
- SSIS (SQL Server Integration Services) development and testing experience
- Exposure to and experience using automated data test tools such as Selenium and Eclipse
- Strong written and oral communication skills; strong interpersonal skills.
- Self-directed and proactive; thinks beyond the immediate problem.
- Flexibility, ability to change priorities quickly, and capacity to handle multiple tasks.
- Experience working both independently and, in a team-oriented, collaborative environment.
- Experience in Healthcare IT or Support environment a plus