Senior Secret cleared Data Conversion Specialist to migrate data to a common Oracle database

7 hours ago


Ahuntsic North, Canada S.i. Systems Full time
Our valued Public Sector client requires a

Senior Secret cleared Data Conversion Specialist to migrate data to a common Oracle database (DataHub).

The OAS on BDM project is underway and working towards an implementation target of December 2024. The team is responsible for migrating data from 2 mainframe systems, 2 Oracle databases and 1 SQL Server (MS Dynamics) database into a common Oracle database (DataHub) and then completing the migration into Azure using Azure Synapse. All ETL within the Oracle based DataHub is manually coded.

Tasks: Document

data mapping, transformations, and lineage from source systems to the Datahub. Create

data traceability matrix

, including code table values. Support code table value mapping analysis. Create and execute data analysis queries. Review and provide feedback on SI data migration deliverables.

Must-haves: Experience with creating and executing analysis queries on

Oracle Database with Oracle SQL Developer Experience updating activities in

Azure DevOps (ADO) Experience with

Data Mapping Canadian Post secondary education related to

Information Technology or equivalent. Valid Secret clearance

Nice-to-haves: Experience using Oracle GoldenGate Experience using Oracle SQL Developer Experience using MS SQL Server Experience using SSMS Experience using Visual Studio Apply

  • Ahuntsic North, Canada S.i. Systems Full time

    Our valued Public Sector client requires a Senior Secret cleared Data Conversion Specialist to migrate data to a common Oracle database (DataHub). The OAS on BDM project is underway and working towards an implementation target of December 2024. The team is responsible for migrating data from 2 mainframe systems, 2 Oracle databases and 1 SQL Server (MS...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our public sector client requires a Reliability cleared Senior Database Administrator (Oracle) to prepare infrastructure for the upcoming cloud transformation and improve maintenance efficiency. The client require Database Administrator support services for Oracle environment for in-operations while adhering to the SDLC best...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our public sector client requires aReliability cleared Senior Database Administrator (Oracle) to prepare infrastructure for the upcoming cloud transformation and improve maintenance efficiency.The client require Database Administrator support services for Oracle environment for in-operations while adhering to the SDLC best practices.Responsibilities: Perform...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our Valued Public Sector client is in need of a Senior, Secret Cleared Storage and Backup Systems Administrator (10+ years) to work alongside technical analysts and advisors to execute operational projects and ensure IT solutions are deployed and documented expediently. The Storage and Backup Operations Group within Shared Services Canada is responsible...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our public sector client requires a Reliability cleared Senior Database Administrator ( MS SQL Server ) to prepare infrastructure for the upcoming cloud transformation and improve maintenance efficiency. The client require Database Administrator support services for MS SQL environment for in-operations while adhering to the SDLC best...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our public sector client requires aReliability cleared Senior Database Administrator ( MS SQL Server ) to prepare infrastructure for the upcoming cloud transformation and improve maintenance efficiency.The client require Database Administrator support services for MS SQL environment for in-operations while adhering to the SDLC best...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our Valued Public Sector client is in need of aSenior, Secret Cleared Storage and Backup Systems Administrator (10+ years) to work alongside technical analysts and advisors to execute operational projects and ensure IT solutions are deployed and documented expediently.The Storage and Backup Operations Group within Shared Services Canada is responsible for...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our public sector client requires an Enhanced Reliability Cleared Senior Database Modeller / IM Modeller to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Design, develop and maintain Logical Data Models. b. Analyze proposed changes to databases from the context of the Logical...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our public sector client requires anEnhanced Reliability Cleared Senior Database Modeller / IM Modeller to support the modernization projects as well as the maintenance of its legacy systems in the public sector.Responsibilities:a. Design, develop and maintain Logical Data Models. b. Analyze proposed changes to databases from the context of the Logical Data...

  • Snr. Oracle MFT

    13 hours ago


    Ahuntsic North, Canada S.i. Systems Full time

    Our valued public sector client is in need of a Secret cleared Oracle MFT Developer to lead the implementation of an integrated Oracle MFT -‘Managed File Transfer' solution. The consultant will also help migrate current custom solutions into the new Oracle MFT and all associated Oracle Middleware components. The candidate should have experience in the...

  • Snr. Oracle MFT

    7 hours ago


    Ahuntsic North, Canada S.i. Systems Full time

    Our valued public sector client is in need of aSecret cleared Oracle MFT Developer to lead the implementation of an integrated Oracle MFT -‘Managed File Transfer' solution.The consultant will also help migrate current custom solutions into the new Oracle MFT and all associated Oracle Middleware components.The candidate should have experience in the...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our client is seeking a Senior Data Architec t for an initial 3-month contract (possibility for extension or conversation to a permanent position) in Ottawa. This position will require adherence to the clients hybrid model, 2 days a week on-site downtown Ottawa. As the successful candidate you will help design and architect cutting-edge cloud data...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our valued Public Sector Client is looking for a Senior Secret cleared Business Consultant to support the Workplace Collaboration Services (WCS) Project. The WCS project will transition up to 75,000 legacy lines to the new fully managed VoIP service valued at over $176M. The high-level target business outcomes are: Reduced monthly operational telephony...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our public sector client requires an Intermediate Top Secret Cleared Incident Management Specialist to improve the monitoring and incident handling procedures of several prototype cross domain solutions systems and products in the public sector. Responsibilities: Conduct threat hunting activities on network and system resources, providing written reports...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our valued Public Sector Client is looking for aSenior Secret cleared Business Consultant to support the Workplace Collaboration Services (WCS) Project.The WCS project will transition up to 75,000 legacy lines to the new fully managed VoIP service valued at over $176M. The high-level target business outcomes are:Reduced monthly operational telephony...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our client is seeking aSenior Data Architec t for an initial 3-month contract (possibility for extension or conversation to a permanent position) in Ottawa.This position will require adherence to the clients hybrid model, 2 days a week on-site downtown Ottawa.As the successful candidate you will help design and architect cutting-edge cloud data platforms,...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our public sector client requires anIntermediate Top Secret Cleared Incident Management Specialist to improve the monitoring and incident handling procedures of several prototype cross domain solutions systems and products in the public sector.Responsibilities: Conduct threat hunting activities on network and system resources, providing written reports on...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our public sector client requires an Enhanced Reliability Cleared Senior Database Administrator to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Develop, customize and implement data conversion procedures which extract, transform and load data from source systems to a data...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our Valued Public Sector Client is seeking a Senior Secret Cleared IT Security Systems Operator to create and document Kusto Query Language (KQL) within Azure Sentinel interface in the Public Sector The Cyber Security Division (CSD) is seeking a consultant to craft and document Kusto Query Language (KQL) within Azure Sentinel interface, based on the...


  • Ahuntsic North, Canada S.i. Systems Full time

    Our public sector client requires anEnhanced Reliability Cleared Senior Database Administrator to support the modernization projects as well as the maintenance of its legacy systems in the public sector.Responsibilities:a. Develop, customize and implement data conversion procedures which extract, transform and load data from source systems to a data...