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

Contract
Ottawa, Toronto
Posted 3 weeks ago

We have an excellent 9 months contract opportunity with possible extension for a senior Architecture – ETL (Extract, Transform, Load) Developer in Mississauga, Ottawa, or Toronto .
For now, work will be done remotely, and then it will be hybrid.
Must haves:
• Reliability level Federal Security clearance is mandatory.
• 3 to 5 years of relevant ETL/DI experience.
• 3 + years’ experience in IBM infosphere tool suite (DataStage & QualityStage).
• 3+ year development with database technologies. 1+ year experience with data warehousing methodologies.
• Teradata experience.
If you are available, please send your resume to [email protected] OR [email protected] OR [email protected] OR [email protected] OR [email protected] OR refer someone interested

Job title: DI ETL Developer
Start date: ASAP
Contract Length: 9 Month (possibility of extension)
Location: Ottawa or Toronto(Mississauga) / hybrid role

THE POSITION

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.

Additional responsibilities include:

• 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:
• 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

Nice to have:
• Cloud Technologies (Azure, AWS…)
• Familiarity with Agile methodology
• Familiarity with JIRA

Apply Online

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