Avanciers is seeking a highly skilled Data Migration Engineer (Oracle to Snowflake migration) to join our team for an exciting 14 weeks contract with one of our esteemed Fortune 500 clients, based in Toronto, ON. This is a REMOTE role

ESSENTIAL SKILLS

• Migration Planning & Execution: Proven hands-on experience in planning and executing data and application migration projects, including in-depth analysis of source and target environments (at least 1 project).
• ETL & Data Transformation: Strong proficiency in ETL processes, including data extraction, transformation, and loading techniques (minimum 2 projects).
• Scripting & Automation: Experience utilizing scripting languages such as Python, Shell, or PowerShell to automate migration-related tasks and workflows (minimum 2 projects).
• Data Validation & Quality Assurance: Competence in validating migrated data, performing data reconciliations, and ensuring data quality and integrity throughout the migration lifecycle.
• Technical Documentation: Ability to produce and maintain comprehensive technical documentation detailing migration processes, procedures, and outcomes.
• Oracle to Snowflake Migration: Direct, hands-on experience with Oracle to Snowflake data migration, including schema conversion, data transformation, and performance tuning.
• Data Transformation: Practical experience in implementing complex data transformation logic during migration efforts.

NICE-TO-HAVE SKILLS

• Cloud-Based Migration: Exposure to cloud migration projects, particularly involving platforms such as AWS or Snowflake.
• Application Modernization: Familiarity with application modernization initiatives, including re-platforming or transitioning legacy applications to modern architectures.

Please refer the Job description for details