ETL & Data Warehouse Specialist – DHA EOSS

Quantum Sky; Aurora (CO); On-site; USD 112,000 - 135,000; Full time

Benefits offered by this job

Health/Dental/Vision

401(k) match

Paid Time Off

Job summary

Quantum Sky in Aurora, CO is seeking a Data Warehousing Specialist (ETL Data Warehouse Specialist - Journeyman) to maintain, enhance, and monitor large-scale ETL pipelines. The role supports the Defense Health Agency’s EOSS program in an AWS GovCloud East environment, running on RHEL and Oracle DBMS.

You will work across development, sustainment, and modernization projects, implementing archiving, CARS/G-Invoicing integration, SFIS/SLOA updates, and CRMSIT data feeds, with a strong emphasis on

Qualifications

• Bachelor's degree or 15 years of equivalent experience.
• 3–5 years hands-on ETL, data warehousing and Informatica administration.
• Experience with BMC Control-M scheduling and automation.
• Solid Oracle SQL/PLSQL experience with Oracle databases.

Responsibilities

• Design, develop, test, and maintain ETL mappings and workflows using Informatica PowerCenter.
• Administer, schedule, and monitor production batch processing workflows using BMC Control-M.
• Develop shell scripts (Perl, Bash) and PL/SQL procedures for ingestion, transformation, and data validation.
• Tune databases and ETL performance; support off-hours maintenance and disaster recovery readiness.

Skills

ETL development

Data warehousing

Informatica administration

Oracle SQL

BMC Control-M

Education

Bachelor’s degree in Computer Science/Information Systems/Engineering

Tools

Informatica PowerCenter

BMC Control-M

Oracle DBMS

Git / GitHub

Job description

Quantum Sky in Aurora, CO is seeking a Data Warehousing Specialist (ETL Data Warehouse Specialist - Journeyman) to maintain, enhance, and monitor large-scale ETL pipelines. The role supports the Defense Health Agency’s EOSS program in an AWS GovCloud East environment, running on RHEL and Oracle DBMS.

You will work across development, sustainment, and modernization projects, implementing archiving, CARS/G-Invoicing integration, SFIS/SLOA updates, and CRMSIT data feeds, with a strong emphasis on