Data Warehouse ETL Engineer – DoD & AWS GovCloud

Quantum Sky; Aurora (CO); On-site; USD 120,000 - 150,000; Full time

Job summary

Quantum Sky is seeking a Data Warehousing Specialist (ETL/PowerCenter Journeyman) to maintain and enhance large-scale ETL pipelines within the DHA EOSS program. You will work on EDW data consolidation, batch processing, and data mart delivery in a AWS GovCloud/RHEL environment.

Responsibilities include design, development, and administration of complex ETL mappings, batch automation, and Oracle SQL tuning. Required DoD eligibility, IAT II certification within 90 days, and a bachelor’s degree or

Qualifications

• Citizenship: Must be a U.S. Citizen (mandatory for DoD IT-II privileged access).
• Cybersecurity Certification: DoD 8140.03 / DoDD 8570.01-M IAT Level II within 90 days (e.g., Security+ CE, CCNA Security, CySA+).
• Education & Experience: Bachelor’s degree or 15 years equivalent experience.
• 3–5 years hands-on ETL development, data warehousing, and Informatica administration/development.
• Operational experience with BMC Control-M job scheduling and automation.
• Proficiency in Oracle SQL/PLSQL in hosting environment.
• Experience with DHA, MHS, TRICARE, or DoD financial/accounting systems.
• Healthcare data experience: TEDS, HIPAA, pharmacy records.
• Warehouse Archival & Purge: archiving for Stage and Arc Stage databases.
• AWS GovCloud, S3, EC2, AVHE familiarity.
• Gitlab version control & SBM/ALM change management use.
• Scripting: Perl, Python, or advanced Linux shell scripting.

Responsibilities

• Design, develop, test, and maintain complex ETL mappings, sessions, and workflows using Informatica PowerCenter.
• Administer, schedule, and monitor production batch workflows with BMC Control-M.
• Develop and maintain robust Linux shell/bash scripts.

Skills

ETL development

Data warehousing

Oracle SQL

PL/SQL

Bash scripting

Shell scripting

Linux

Performance tuning

Batch processing

Education

Bachelor's degree in CS/IS/Engineering or 15 years experience

Tools

Informatica PowerCenter

BMC Control-M

GitLab

SBM/ALM

Oracle Database

AWS GovCloud

Linux shell scripts

Job description

Quantum Sky is seeking a Data Warehousing Specialist (ETL/PowerCenter Journeyman) to maintain and enhance large-scale ETL pipelines within the DHA EOSS program. You will work on EDW data consolidation, batch processing, and data mart delivery in a AWS GovCloud/RHEL environment.

Responsibilities include design, development, and administration of complex ETL mappings, batch automation, and Oracle SQL tuning. Required DoD eligibility, IAT II certification within 90 days, and a bachelor’s degree or