ETL Programmer Analyst

Post Date

Mar 26, 2024

Location

Vancouver,
British Columbia

ZIP/Postal Code

V6T1Z4
Canada
Jun 27, 2024 Insight Global

Job Type

Contract

Category

Data Warehousing

Req #

VAN-692924

Pay Rate

$53 - $79 (hourly estimate)

Who Can Apply

  • Candidates must be legally authorized to work in Canada

Job Description

Insight Global is looking for an ETL Programmer Analyst to join our client locally in Vancouver, BC on a contract basis. The successful candidate should posses 4-6 years' of experience within data and a focus within Informatica ETL. You will be analyzing data within a data warehouse environment that is being migrated from an ERP system and fixing issues within that data once in the data warehouse. The bulk of this data will be HR and Finance related. The data will then be transferred from on-prem Informatica PowerCenter to the cloud, Informatica IICS. This will require the successful candidate to understand ETL (extract, transform, load) in the Informatica tool, understand what's been built within the on-prem version and how to translate that to the cloud IICS language. You will be working closely with business stakeholders and data SME's to pull the correct data attributes for every issue within PowerCenter.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

- 4-6 years' experience working within Informatica PowerCenter and IICS
- Experience working on any true enterprise data warehouse, Oracle preferred
- Data reporting tools such as Tableau, Crystal Reports, PowerBI

Nice to Have Skills & Experience

- Working within HR and Finance data migrated from ERP systems
- Higher-education experience
- Strong security Understanding

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.