QA Lead

We are seeking a Quality Assurance Engineer to Ensure data integrity, validate migration results, and perform comprehensive testing throughout the database modernization project. Establish quality gates and validation frameworks for the migration process.

Responsibilities

Design comprehensive database migration strategy and roadmap from MSSQL to Aurora PostgreSQLDevelop comprehensive data validation and reconciliation strategiesCreate automated testing scripts for data integrity verificationPerform GPS schema validation and reconciliation activitiesExecute functional testing of migrated database objectsValidate performance benchmarks and optimization resultsEstablish testing methodologies and quality gates for migration phasesCreate test cases for database objects, procedures, and functionsDevelop regression testing suites for ongoing validationImplement automated monitoring and alerting for data quality issuesDocument testing procedures and validation criteriaGenerate data reconciliation reports and validation summariesTrack and report data quality metrics and KPIsDocument defects, issues, and resolution statusMaintain testing artifacts and evidenceProvide sign off recommendations for migration milestonesCreate and maintain database monitoring and alerting

Requirements

Experience3+ years of database testing and quality assurance experience2+ years of experience with data validation and reconciliationExperience with both SQL Server and PostgreSQL platformsExperience with automated testing frameworks and toolsTechnical SkillsStrong understanding of data validation and reconciliation techniquesProficiency in SQL for both SQL Server and PostgreSQL platformsExperience with database testing tools and frameworksKnowledge of automated testing and scripting - Python, SQLFamiliarity with defect tracking tools - JIRA, Azure DevOpsUnderstanding of database performance testing conceptsNice To HaveExperience with test automation frameworks Selenium, TestCompleteKnowledge of performance testing tools - JMeter, LoadRunnerFamiliarity with continuous integration continuous deployment - CI CDExperience with data profiling and data quality tools