• Category
    Information Technology - Database Developer
  • Job type
  • Location
    Ottawa, Ontario

Adecco is currently recruiting for an Architecture - ETL Developer – Intermediate for a 10-Months contract with our Crown Corporation Client in Kanata, ON. The successful candidate must hold a valid Reliability Security Clearance or be eligible for it.

The Architecture - ETL Developer – Intermediate will have the following responsibilities:

  • Develop and test ETL processes to interface data from multiple internal and external systems;
  • Develop ETL jobs that satisfy identified data model and business requirements;
  • Translate complex business requirements into technical solutions;
  • Perform data analysis and data modelling to create functional design documents and source to target mappings;
  • Load target data bases using complex transformations that come from many systems.
  • Monitor loads and troubleshoot any issues that arise;
  • Meet with ETL Design and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues.
  • Participate in the design sessions;
  • Collaborate in the planning, design, development, and deployment of new functionality, and enhancements;
  • Develop test scenarios and perform in-depth unit tests, including end-user reviews;
  • Define ETL job sequence and dependencies including error logging and restart processes as well as develop ETL run book;
  • Understand and develop ETL processes based on BRD (Business Requirements Document);

The Architecture - ETL Developer – Intermediate must meet the following mandatory requirements:

  • 3 to 5 years of relevant experience required;
  • 3+ year experience in IBM infosphere tool suite (DataStage & Quality Stage);
  • 3+ year development with database technologies. 1+ year experience with data warehousing methodologies.;
  • 1+ year experience in PL/SQL development. Preference will be given to people with experience on Teradata and Infosphere suite (DataStage / Quality Stage / FastTrack / IDA in particular).

If you are interested in applying to our Architecture - ETL Developer – Intermediate position, please submit your resume as soon as possible by clicking on the 'Apply with Adecco' button.



  • Apply with Adecco

Reference number CA_EN_1_027616_12138223

Accommodation will be provided in all parts of the hiring process as required under Adecco’s Employment Accommodation policy. Applicants will need to make their needs known in advance to their Adecco representative.

Someone from Adecco/Roevin just contacted me, how do I tell if it’s legit or a scam? Here's how to protect yourself →