About this role
Job Summary
Seeking a QA Engineer with 8to 10 years of experience to ensure seamless and accurate database migration from DB2 LUW to Amazon Aurora PostgreSQL on AWS cloud
Location Canada
Exp 8 to 10 years
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 fullload incremental load and delta load 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 Source to Target Mapping Validation Stored Procedure Analysis Data Quality Testing Schema Validation SIT Regression Testing JIRA Agile Mandatory Skills : AWS Cloud data Testing, Cloud migration and Platform modernization Testing, ETL / Datawarehouse testing
Good to Have Skills : Data Testing (SQL, Data Base, ETL, DW)
Immigration pathway
ON • Express • onsite • TEER 1