Conducting cross-environment validation between QA, UAT, and production, adhering to established Enterprise Quality Assurance Plan and providing feedback and suggestions on improvements
Writing and executing complex SQL queries to perform data validation, reconciliation, and comparison of large datasets across environments
Adhere to established EDW and ETL SDLC and Corrective Action guidelines and provide feedback and suggestions for improvements
Provide assistance/on the job training for querying capabilities to EQA Resources as requested and training support teams on various business processes and developing efficient problem management procedures
Function as Enterprise Quality Assurance Lead on selected projects, operational procedures and release tasks utilizing project management skills
Lead the team in the approval of the Test Approach, Test Criteria, Tasks, schedule for Strategic Projects based on approved requirements
Participating in Peer and Solution review of Business and Technical Specifications effecting designated areas of expertise and provide feedback to improve clarity of the specifications and usability of the functionality
Using SQL, Python or ETL testing frameworks to support regression and data comparison testing
Requirements
Bachelor’s (or foreign educ. equiv.) Degree in Information Systems, Computer Science, Information Technology, or a related field
two (2) years’ experience in the job offered or related occupation
Writing and executing complex SQL queries to perform data validation, reconciliation, and comparison of large datasets across environments
Identify and track defects using ALM or Azure DevOps
Using SQL, Python or ETL testing frameworks to support regression and data comparison testing
Ensuring data transformations comply with HIPAA and PHI
Conducting cross-environment validation between QA, UAT, and production
Analyzing and identifying all issues in requirements and design
Assisting to provide resolution and perform various tests on software to resolve all issues
Training support teams on various business processes and developing efficient problem management procedures
Writing complex SQL queries in Oracle SQL developer