Senior Architecture – ETL (Extract, Transform, Load) Developer

Contract
Ottawa
Posted 2 months ago

We have an excellent 6 months contract opportunity for a senior Architecture – ETL (Extract, Transform, Load) Developer in Ottawa.
Work would be done remotely until the pandemic situation normalizes.
Must haves:
• Reliability level Federal Security clearance is mandatory.
• 5+ years of relevant ETL/DI experience required.
• 5+year experience in IBM infosphere tool suite (DataStage & QualityStage)
• 5+ year development with database technologies. 1+ year experience with data warehousing methodologies.
• 3+ year experience in PL/SQL development. Preference will be given to people with experience on Teradata and InfoSphere suite (DataStage / QualityStage / FastTrack / IDA in particular).
• Ability to develop Teradata Storage Procedures to implement ETL processes.

Job Posting Title: Architecture – ETL (Extract, Transform, Load) Developer – Senior
Description: GENERAL INFORMATION

Job Posting Start Date: 04/25/2022
Job Posting End Date: 10/21/2022
Site: Ottawa
Location: Ottawa

Job Title: DI/ETL Developer
Duration: 6 months
Start Date: asap

SCOPE

The ETL developer will be a replacement to our current DI developer who is reaching the two year limit. The developer will be assigned to Commercial product team under Data Analytics team working with on going projects as well as the backlogs.

DUTIES

• Develop and unit test ETL processes to interface data from multiple internal and external systems. Develop ETL jobs that satisfy data model design, Overall performance, business requirements, QA, and Production support 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 and Code review.
• 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).
• Participate in our Agile team meetings.

SKILLS AND EXPERIENCES

Must Have:
1) 5+ years of relevant ETL/DI experience required.
2) 5+year experience in IBM infosphere tool suite (DataStage & QualityStage).
3) 5+ year development with database technologies. 1+ year experience with data warehousing methodologies.
4) 3+ year experience in PL/SQL development. Preference will be given to people with experience on Teradata and InfoSphere suite (DataStage / QualityStage / FastTrack / IDA in particular).
5) Ability to develop Teradata Storage Procedures to implement ETL processes.
6) Familiarity with Agile methodology

Nice to have:
7) Cloud Technologies (Azure, AWS,….)

Soft Skills:
a. Problem solving / analytical thinking b. Creative thinking c. Smart risk taking d. Ability to execute e. Interpersonal skills

Apply Online

A valid email address is required.
A valid phone number is required.