ETL Developer
- Pay rate: $118,000 – 125,000 CAD Monthly, based on experience
- Location: Vancouver hybrid; 2 days a week on campus
Raise is currently hiring a ETL Developer team member on behalf of our client, an esteemed educational institution. They’re expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader.
Job Overview
The Data Integration / ETL Specialist will be responsible for migrating and modernizing enterprise ETL processes by converting existing Informatica PowerCenter jobs to Informatica Intelligent Data Management Cloud (IDMC), supporting integrations where Workday serves as the source system and Oracle databases (hosted within AWS) serve as destinations. The role will also design and deliver new ETL jobs and integrations across multiple data sources to build governed, analytics-ready datasets for Faculty and institutional reporting. This position works closely with Enterprise Data Governance, Data Warehouse, Architecture, Security, and DBA teams to ensure data integrity, lineage, compliance, and alignment with enterprise data models, while supporting testing, documentation, and implementation to enable reliable, scalable data delivery.
Responsibilities:
- 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, data lineage and 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.
Core Duties:
- Convert ETL jobs in Informatica PowerCenter to IDMC. Source is Workday, destination is Oracle database.
- Create new integrations and ETL jobs for multiple data sources to create datasets (in Oracle, within AWS) for a Faculty.
Education and Certifications:
- Undergraduate degree in a relevant discipline; a degree in IT or Business Administration is preferred.
Experience:
- 5+ years’ experience coding in IDMC, for a medium or large organization, including designing, developing and implementing ETL jobs.
- In-depth knowledge of Workday and AWS.
- Strong understanding of data modelling, data profiling and data quality concepts and techniques.
- Strong understanding of database design, and data warehouse architectures.
- Excellent skills with Oracle and other relational databases.
- Exceptional written and oral communication skills, including the ability to present ideas and suggestions clearly and effectively.
- Experience in a university or other public sector environment is preferred.
Additional Assets:
- Experience in Informatica PowerCenter is also a strong asset.
- An understanding of API’s and leading data integration technologies is an asset.
- AI and Python training/experience an asset.
Looking for meaningful work? We can help
Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.
We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.
We have a dedicated webpage for accommodations where you can learn more about what we offer, and request accommodation: https://raise.jobs/accommodations/
In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at +1 800-567-9675 or hello@raiserecruiting.com
#WES
#LI-SC1