Reference #: TC2019036
Location: Ottawa, Ontario
Type: Sub-contract

Donna Cona Inc. is currently seeking a Technology Architect (Data Warehouse), Level 2, for one of our key government clients.

Candidate MUST have the following:

  • Security clearance at the level of Secret;
  • Five (5) years of experience, within the last 10 years, working as a Technology Architect in a Data Warehouse development environment;
  • Five (5) years of experience, within the last 10 years, implementing data warehousing in an Extract, Transform and Load (ETL) environment;
  • Three (3) years of experience, within the last 6 years, using IBM InfoSphere DataStage (8.0) or higher as the primary tool to acquire data from a Database Management System;
  • Three (3) years of experience, within the last 6 years, scripting within a Unix environment;
  • Three (3) years of experience, within the last 6 years, with the IBM DB2 RDBMS (Relational Database Management System) in an IBM Infosphere DataStage environment; and
  • Three (3) years of experience, within the last 6 years, shredding XML data types into a Data Warehouse environment.

Candidate should have the following demonstrated experience:

  • Working as an IBM Infosphere DataStage ETL Architect in a Data Warehousing environment developing complex ETL jobs, scripts and/or routines to feed relational and dimensional (star schema) data repositories and resolving ETL performance issues (complex is defined as a job, script or routine which: Has two or more join stages or transformer stages, Has data sources with two or more transformation rules;
  • ETL Architect defining source, target and staging data repositories;
  • ETL Architect defining data transformation processes;
  • ETL Architect defining volumetric, hardware and software requirements and configurations;
  • Developing ETL coding standards and ETL development best practices;
  • Using ETL Source to Target Mapping documentation, and ETL High Level and Detailed ETL Design documentation, and IBM Infosphere DataStage job documentation; and
  • Has obtained the following certifications: IBM Certified Specialist – PureData System for Analytics and IBM Certified Solution Architect.
  • To apply for this position please complete the form below.
  • Please note that these must be in one document, and can be in .docx, .doc, .pdf or .rtf formats