Data Engineer

Janus Henderson Investors•Denver, CO

4d•Hybrid

About The Position

Janus Henderson Investors US, LLC seeks a Data Engineer in Denver, CO responsible for the design, development, testing, installation and support of complex data extract transformations, ETL, and ELT programs, using PL/SQL, Informatica Power Center 10.x and earlier models. Develop integrations between internal systems, as well as external data vendors using RDMS databases, flat files and cloud storage. Develop job schedules using Autosys to meet daily SLAs for the enterprise data warehouse and appropriate technology applications, using key design and development concepts for Data Lakes, Data Warehouses and Data Marts. Implement ETL / ELT pipelines within and outside of the data warehouse using SQL. Perform unit and integration tests and support UAT testing. Remote work permitted 2 days a week.

Requirements

Bachelor’s degree in Information Systems, Computer Science, Electronics Engineering, or a related field
7 years of progressively responsible experience with PL/SQL, Informatica Power Center 10.x and earlier models.

Responsibilities

Design, development, testing, installation and support of complex data extract transformations, ETL, and ELT programs, using PL/SQL, Informatica Power Center 10.x and earlier models.
Develop integrations between internal systems, as well as external data vendors using RDMS databases, flat files and cloud storage.
Develop job schedules using Autosys to meet daily SLAs for the enterprise data warehouse and appropriate technology applications, using key design and development concepts for Data Lakes, Data Warehouses and Data Marts.
Implement ETL / ELT pipelines within and outside of the data warehouse using SQL.
Perform unit and integration tests and support UAT testing.