Typical Responsibilities/Tasks:
• ETL Architecture: Assist the end-to-end development, maintenance, and optimization of enterprise-level ETL processes using DataStage to support HRC application structures.
• Data Integration & Quality: Design complex data mapping and transformation logic, ensuring data integrity across disparate sources within the Army’s data warehouse environment.
• Systems Maintenance: Provide Cyber and IA database systems maintenance, ensuring all ETL jobs comply with rigid security and Information Assurance protocols.
• Technical Lifecycle Management: Review and provide sophisticated technical solutions for data projects across all stages of the development lifecycle, from initial ingestion to report generation.
• Monitoring & Automation: Implement and manage advanced job scheduling and monitoring tools to ensure 24/7 reliability of data pipelines.
• Documentation: Produce high-quality technical documentation, including data flow diagrams (Visio), mapping specifications, and system architecture briefs.