Movojobs
Back to results

Added

Insi

Data Migration Developer (MS Access/VBA → Oracle APEX)

  • Gatineau, QC, Canada
Apply About employer

Applications open in a new tab.

Job details

Apply by
Posting language
English
Posted

Original job description

About The Role

This is the most specialized of the three profiles: an experienced developer who migrates legacy MS Access/VBA and MS SQL Server applications and their data into modern Oracle APEX-based platforms, while keeping the legacy systems running during the transition.

What you'll do

  • Analyze, interpret, and translate legacy source datasets - including MS Excel, MS Access, and other file- or system-based sources - into structures compatible with Oracle database and Oracle APEX environments.
  • Plan and perform end-to-end ETL activities: staging, transforming, validating, and loading datasets from legacy sources into Oracle environments using Oracle SQL, PL/SQL, and APEX utilities.
  • Troubleshoot, debug, and enhance legacy MS Access–based and/or MS SQL Server–based applications to sustain them during migration, using MS Access, T-SQL, and Microsoft VBA as needed.
  • Document data mappings, transformation logic, business rules, profiling results, and data-quality findings for transparency and repeatability.
  • At the discretion of the Technical Authority, may also support broader software development activities: bug and change request development, peer code reviews, testing and test script development.

Must-have

  • Hands-on experience with MS Access and Microsoft VBA in a production/legacy-application context.
  • Experience migrating legacy data (Access, Excel, SQL Server) into a modern platform - ETL design and execution.
  • Working knowledge of Oracle SQL / PL-SQL and, ideally, Oracle APEX.
  • Fluent English, spoken and written, with minimal errors.
  • Must be a Canadian citizen - a requirement for eligibility for the Government of Canada Secret-level personnel security screening this role needs to start work.
  • Able to work on-site at 455 Boulevard de la Carrière, Gatineau, QC, on a primarily in-person basis.

Nice-to-have

  • Already holds an active Government of Canada Secret-level clearance
  • T-SQL experience specific to MS SQL Server legacy applications.
  • Exposure to software testing / test script development.
Apply About employer
More about this job

Responsibilities

Analyze and migrate data from legacy Excel, MS Access, and SQL Server sources into Oracle database and Oracle APEX environments, including planning and executing end-to-end ETL processes. Maintain and troubleshoot legacy applications during the transition, and document data mappings, transformation logic, business rules, and data-quality findings.

Requirements

Requires production-context experience with MS Access and Microsoft VBA, experience migrating legacy data through ETL, and working knowledge of Oracle SQL and PL/SQL; Oracle APEX is preferred. Applicants must be fluent in English, Canadian citizens eligible for Government of Canada Secret-level screening, and able to work primarily on-site in Gatineau.

Skills

  • MS Access
  • Microsoft VBA
  • Data Migration
  • ETL
  • Oracle SQL
  • PL/SQL
  • Oracle APEX
  • MS SQL Server
  • T-SQL
  • Data Transformation
  • Data Validation
  • Data Quality
  • Legacy Application Support
  • Data Mapping
  • Software Testing

Visa sponsorship

Not detected in the job text

Categories

  • Technology
  • Software
  • Data & Analytics
  • Government & Public Sector

Keywords

  • MS Access
  • Microsoft VBA
  • Oracle APEX
  • Oracle Database
  • Oracle SQL
  • PL/SQL
  • MS SQL Server
  • T-SQL
  • Microsoft Excel
  • Data Migration
  • ETL
  • Data Staging
  • Data Transformation
  • Data Validation
  • Data Loading
  • Data Mapping
  • Business Rules
  • Data Profiling
  • Data Quality
  • Legacy Application Support
  • Software Development
  • Bug Fixes
  • Change Requests
  • Code Reviews
  • Software Testing
  • Test Script Development
  • Government of Canada Secret Clearance

Report this job