ETL Developer

TEEMA; Vancouver; On-site; CAD 85,000 - 115,000; Full time

Job summary

A forward-thinking consulting firm in Vancouver seeks an experienced ETL Developer to enhance data governance and infrastructure. You will plan technical migrations, develop integration plans, and work closely with various stakeholders to align dataset requirements. The ideal candidate must have over 5 years of experience in coding, particularly in IDMC and Informatica PowerCenter. Strong data modeling skills and expertise in database design are essential. Excellent communication skills are required.

Qualifications

• 5+ years experience coding in IDMC for medium or large organizations.
• Experience in Informatica PowerCenter is a strong asset.
• Strong understanding of data modeling, profiling, and quality concepts.
• Strong skills with Oracle and relational databases.
• In-depth knowledge of Workday and AWS.
• Exceptional written and oral communication skills.

Responsibilities

• Work with Enterprise Data Governance and Data Warehouse teams for migration path planning.
• Develop integration plans and oversee testing of applications.
• Maintain positive relationships regarding UDAP matters with business partners.
• Document design and table structure changes.

Skills

Coding in IDMC

Informatica PowerCenter

Data modeling

Data profiling

Database design

Data warehousing

Oracle

AWS

API integration

Python

Job description

Job Title

Job Title: ETL Developer

Job ID

Job ID: 85616

Location

Location: Vancouver, British Columbia

What you will be doing:

• Work with Enterprise Data Governance and the Data Warehouse team to plan and document the technical migration path for ETL’s. This includes critical data elements, including business use, ownership, datalineageand business rules (calculated fields).
• Work closely with data analysts, report owners, data stewards, and data governance teams to help align dataset requirements.
• Develop integration plans and system test plans, overseeing testing of new or modified applications and ensures data and applications meet specifications.
• Work closely with other data developers, Architects, Cybersecurity, and DBAs to ensure that designs are incorporated into current Technical Specifications as required, and that those specifications are updated as changes occur.
• Work with data architect to align with and maintain data models for the data warehouse.
• Create ETL job design based on current and evolving infrastructure, and present for peer reviews before implementing.
• Conduct testing and validation of data when ETL changes are directly or indirectly applied to data warehouses.
• Participate in project planning and implementation.
• Documents design, including ETL job details, and table structure changes. Ensures documentation of functions and changes to new or modified modules.
• Act as a resource and subject matter expert to business partners to ensure alignment between business unit-level procedures and enterprise reporting.
• Maintain positive relationships regarding UDAP matters with relevant cross-functional business partners, providing input and feedback on changing data elements and policies.
• Assists in the creation and presentation of business cases.

What you must have:

• 5+ years experience coding in IDMC, for a medium or large organization, including designing,developingand implementing ETL jobs.
• Experience in Informatica PowerCenter is also a strong asset.
• Very strong understanding of data modeling, data profiling and data quality concepts and techniques.
• Very strong understanding of database design, and data warehouse architectures.
• Very strong skills with Oracle and other relational databases.
• In-depth knowledge of Workday and AWS.
• An understanding of API’s and leading data integration technologies is an asset.
• AI and Python training/experience an asset.
• Higher Ed experience preferred.
• Exceptional written and oral communication skills, including the ability to present ideas and suggestions clearly and effectively.

Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.

For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com