QA Engineer

Job Title: QA Engineer

Work Location:Toronto, Ontario (Hybrid)

Role Summary

• Seeking an experienced QA Engineer to ensure seamless and accurate database migration from DB2 LUW to Amazon Aurora PostgreSQL on AWS cloud

Responsibilities

• Analyze source to target mappings data models transformation logic and business requirements for DB2 to AWS PostgreSQL migration
• Analyze and validate stored procedures functions triggers and database objects to ensure accurate business rule implementation during migration
• Design and execute migration testing including SIT Regression activities
• Perform schema validation data migration validation and reconciliation testing
• Validate full load increment alload and deltaload migration processes
• Execute source to target data validation using record count field level aggregate and business rule checks
• Develop and execute complex SQL queries for data validation analysis and defect investigation
• Validate data quality transformation logic referential integrity and data consistency across source and target systems
• Perform parallel run testing to ensure consistency between legacy and target platforms
• Validate data completeness and accuracy across migration cycles
• Prepare test evidence reconciliation reports validation summaries and quality metrics
• Mentor junior team members and drive testing best practices standards and process improvements
• Collaborate with business development DBA and migration teams to ensure successful project delivery

Mandatory Skills
DB2 PostgreSQL Advanced SQL Data Migration Testing ETL Testing Data Reconciliation SourcetoTarget Mapping Validation Stored Procedure Analysis Data Quality Testing Schema Validation SITRegression Testing JIRA Agile