Developer (Datastage)

Apply now »

Date: Jan 12, 2023

Location: Ottawa, ON, CA, K2K 3N5

Company: Innovapost

Requisition Number: 2107 

Location: March Road  

Province: Ontario (CA-ON) 

Country: Canada (CA) 

Employment Type: Regular 

 

 

Who is Innovapost?

Great question! We are the technology arm of the Canada Post Group of Companies. This includes Canada Post, Purolator, and SCI. By joining us you will be able to make a positive impact on how every Canadian delivers and receives their packages and mail. Next time you see your neighbor picking up their mail and receiving a package, you will be able to say “you’re welcome”

 

 

Why join Innovapost?

As Technology evolves constantly, we invest in our High Performing Workforce with the Skills of Tomorrow through continuous learning and career growth within Innovapost, including access to LinkedIn Leaning, the new Degreed capability and a Leadership Developmental Program. We invest in Diversity, Inclusion and Belonging, and provide continuous employee engagement to grow our business together. 

What role you will play?

The Data Integration ETL Developer will be joining a diverse agile Product Team dedicated to delivering Data Analytics initiatives.   The DI/ETL Developer will develop and unit test ETL processes to interface data from multiple internal and external systems, satisfying data modeling design, overall performance, business requirements, QA, and production support requirements.  The DI/ETL Developer will be a great collaborator in a team setting as working alongside Data Architects, Business Intelligence Report Developers, Data Quality Testers and Project managers is essential in meeting tight timelines.

What you'll be responsible for? (Apart from Innovating)

•    Meet with ETL Design and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues.
•    Collaborate in the planning, design, development, and deployment of new functionality, and enhancements.
•    Review the Business Requirements, Functional Design, Table Definitions and Mapping Specification and provide feedback. 
•    Design and document a Data Flow appropriate to the data volumes and technical/business requirements and adheres to Innovapost standard practices.
•    Conduct peer review of your design and development plan, then develop and unit test the components (ETL, Linux script, SQL scripts and stored procedures, etc.) as required.
•    Update JIRA tasks with information as development progresses and record time spent on tasks 
•    Enter time into time recording software on a timely basis according to time spent on different assignments to enable charge back
•    Participate in our Agile team meetings and provide status and progress updates on your tasks
•    Prepare Release package with design and operation documentation and notes for promotion of code to QA and subsequent promotion to Production.
•    Provide support to QA Team during testing and Production Support Team during warranty period.
•    Contribute to the ongoing improvement of standard practices and assist colleagues with design and code issues.

What does it take for this role to be yours?

•    3 to 5 years of relevant ETL/DI experience.
•    3+ year experience in IBM infosphere tool suite (DataStage & QualityStage).
•    3+ year development with database technologies. 1+ year experience with data warehousing methodologies.
•    Teradata experience - Asset
 

Additional skills that sets you apart:

•    Cloud Technologies (Azure, AWS…)
•    Familiarity with Agile methodology
•    Familiarity with JIRA
 

Competencies:

  • Be Courageous
  • Innovate
  • Be Inclusive
  • Inspire
  • Be Curious

 

Diversity, Inclusion & Belonging at Innovapost

We value diversity as an essential part of who we are as a company, how we operate and how we see our future. We believe that attracting, developing, and retaining people who reflect the diversity of Canada is essential to our success because this matters to all communities and customers we serve. We encourage applications from women, Indigenous People, persons with disabilities and visible minorities.

 

Accommodation

Innovapost is committed to providing an inclusive and barrier-free work environment, starting with the hiring process. If you are contacted by Innovapost regarding a job opportunity, please advise if you have any restrictions that need to be accommodated.  All information received in relation to accommodation will be kept confidential.

The work we do at Innovapost impacts every Canadian. To work with us, you must be eligible to obtain a Canada Post Reliability Security Clearance. For more information please reference the Government of Canada site


Good luck! We are looking forward to meeting you, but unfortunately, we will not be able to meet all of you!