Database/ETL Engineer Senior
Core
Designing and optimizing high-volume data integration solutions for the US Army Human Resources Command (HRC) to ensure accurate, secure, and actionable HR data.
Role type
Senior ETL Engineer (DataStage)
Builds
Enterprise-level ETL processes and data pipelines for Army HR data
Domain
Defense / Federal Government / Data Warehousing
Deliverable
production ML models | product features | dashboards & analysis
Required skills
IBM InfoSphere DataStage, SQL (PostgreSQL, Oracle, MS SQL), ETL architecture, data mapping, schema management, job scheduling, Visio
Preferred skills
PostgreSQL, XML/HTML, open-source development environments
Technologies
IBM InfoSphere DataStage, PostgreSQL, Oracle, Microsoft SQL, Visio
Responsibilities
Develop and maintain end-to-end ETL processes using DataStage; Design complex data mapping and transformation logic; Ensure ETL jobs comply with security and Information Assurance protocols; Implement advanced job scheduling and monitoring tools; Produce technical documentation including data flow diagrams.
Seniority
Senior, hands-on IC