Descrição da Vaga

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


Presencial
Gatineau - Quebec
Vaga Pública

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

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.

Localização

455 Boulevard de la Carrière · CEP J8Y 6V7

Gatineau - Quebec

Ver localização no mapa

Indique alguém para essa vaga

Você pode indicar alguém para esta vaga enviando o currículo da pessoa que deseja indicar para o email abaixo.

Compartilhar essa Vaga

Compartilhe essa vaga em sua rede social.

Sobre Nós

Insi is a consultancy specializing in digital evolution, acting as a strategic partner to organizations on their transformation journey and connecting diagnosis, strategy, and execution to deliver tangible results. With a global presence, more than 2,700 employees across 27 countries, and over 200 clients, the company helps businesses identify opportunities, advance their digital maturity, and implement solutions that drive efficiency, growth, and competitiveness.

Drawing on deep expertise in applied artificial intelligence, Insi runs projects end to end, from assessing scenarios and shaping strategy to delivering solutions powered by intelligent agents. Its service ecosystem puts AI to work to raise productivity, lower costs, and accelerate value creation, combining advanced technology, business fluency, and a human-centered approach that turns complex challenges into measurable results.