SPICT - A.7 programmeur-analyste (développeur ETL) - niveau 2 (IC401464)

Industry Canada is currently in process of delivering on a five (5) year roadmap that will allow the department via the Business Intelligence and Analytics (BIA) project, to develop and implement a unified set of methodologies, processes, procedures, and tools for Master Data Management (MDM) and Business Analytics (BA).

The expected outcomes of the project will produce a data-driven enterprise vision for Industry Canada for the benefit of all lines of business by assisting in increased horizontal usage of data. The vision focuses on pragmatic and strategic solutions for Industry Canada as a whole while acknowledging the uniqueness of some of the lines of business.

As with other organizations, Industry Canada has experienced an increase in the volume of data over the years. This, along with other drivers, has increased the need for better managing, sharing and leveraging of this data horizontally to improve the programs offered to Canadians. MDM will enable data integration and assist with transformation of data to support applications and to perform advanced data analytics in order to enhance the development and delivery of IC policies, programs and evaluation.

SCOPE OF WORK / KEY ACTIVITIES

The ESD Reporting team works with a variety of clients, including developers, database administrators, the service management team, and enterprise architects to support the integration of their requirements into the existing reporting environment. The database contains information from multiple applications using Oracle.

The ETL development team is also responsible for relational database design support. This function consists of providing Oracle database schema analysis and administration for a number of applications, including those residing on the Industry Canada’s primary business and consumer website. The team is also responsible for the software, standards and processes in use to support the data administration function. The tool currently being used is Information Builders (Data Management Console) and will be converted to IBM (InfoSphere DataStage).

The Programmer Analyst/ETL Developer will support the various ESD projects and initiatives in the development of enterprise solutions and will be required to work both autonomously as well as with the rest of the members of the BIA team to ensure that each member of the client community receives timely and high quality service.

Duties and deliverables may include but not be limited to the following:

• Analysis

o Analyze, define and document requirements for data, workflow, logical processes, hardware and operating system environment, interface with other systems, internal and external checks, controls, and outputs;
o Assist Business Analysts in performing investigation, analysis and evaluation to determine business requirements;

• Extract, Transform and Load (ETL)

o Design, develop and maintain ETL data flows, scripts and procedures;

• Data Quality

o Perform data analysis, profiling and cleansing;

• Testing

o Perform testing;
o Provide support and coordination assistance for QA testing;

• Documentation

o Writing technical documentation; and

• Provide updates/status reporting to project team management as required.