Reference #: 5681
Location: Ottawa, Ontario
Donna Cona Inc. is currently seeking a Database Modeller, Level 2, for one of our key government clients.
Candidate MUST have the following mandatory criteria:
- A valid security clearance at the Reliability Status level or higher;
- Five (5) plus years of experience as a Database Modeller; and
- Experience, within the last five (5) years, delivering projects that include:
- Developing/enhancing extract, transform, load (ETL) processes for data loads exceeding 1M rows; and
- Developing a normalized ‘Big Data’ warehouse using a star schema layout, with a fact table of at least 100M rows.
Candidate should have the following:
- Experience, within the last five (5) years, working on a project with Apache Spark, Hadoop or another ‘Big Data’ processing framework;
- Experience, within the last five (5) years, working on a project that includes implementing ETL processes using SAS Data Integration Studio; and
- Experience, within the last five (5) years, in the development and maintenance of ‘Big Data’ data warehouses with a star schema containing both dimension and fact tables.