Login


New to IMS? Register Now

Forgot Your Password?

Programmer-Analyst (PL/SQL)

Quebec
Job Order: BP-6918

Job Title: Programmer-Analyst (PL/SQL)

                                                                  

Job Details:

  • Analyze user needs with the participation of relevant stakeholders including the Data Warehouse Architecture Advisor, Data Modeler, Process Architecture Architect, and DBAs
  • Perform the required analyzes with regard in particular to the processing, impacts on the data model and the required disk space
  • Carry out unitary and integrated tests and record the results of such tests in a report
  • Make corrections, if required, following acceptance testing
  • Provide support following production, for a period of two weeks after the loading of the relevant source into production
  • Cleaning and processing
  • Set up target tables in the data warehouse as well as links to target tables
  • Prepare, in accordance with Revenue Québec standards, metadata documentation, technical documentation of data sources, production line documentation and other documentation;
  • Develop strategy and test specifications
  • Support users during acceptance testing
  • Carry out production work
  • Carry out any other activities related to this mandate

 

Job Responsibilities:

  • Perform PL / SQL programming
  • Carry out the unitary and integrated tests and record the results of these tests in a report
  • Make corrections, if required, following acceptance testing
  • Provide support following production, for a period of two weeks after the loading of the relevant source into production

 

Deliverables:

  • Work plan
  • Design files, as well as the associated organic appendices
  • Test strategies, specifications and report of test results;
  • Production files;
  • Conversion strategy;
  • User manual;
  • Deployment strategy;
  • Source code of programs, scripts and related documentation;
  • Any document underlying previous responsibilities.

 

 

Job Requirements:

 

  • Hold a Diploma of College Studies (DCS) in Computer Science or a related discipline;
  • Five years of experience in system development and maintenance;
  • Two years of experience in a data warehouse environment similar to Revenue Québec;
  • Have two years of programming experience in SQL, PL * SQL and using Oracle databases;
  • Have experience with the office tools used at Revenue Québec: Word, Visio, Excel.
DATE POSTED 2017-03-01

No more jobs from this category.

Warning

Please, enter a valid value

Thank you.

Your password successfully changed.