ETL Developer | Data Warehouse & Governance Expert

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

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.