Shared Data Warehouse (SDW) Process Transformation Subject Matter Expert (SME)

• Implement and support ETL workflows to extract data from SDW mid-tier, transform it into usable formats, and load it into SDW Oracle DB.
• Create efficient and scalable ETL pipelines to handle large volumes of data.
• Ensure ETL processes align with business requirements and data architecture standards.
• Perform complex data transformations to standardize, cleanse, and enrich SDW data from MOCAS for analytical or operational purposes.
• Integrate SDW data from MOCAS, including structured, semi-structured, and unstructured data formats.
• Ensure seamless data flow between SDW, MOCAS and systems, applications, and databases.
• Implement data quality checks and validation rules within ETL processes to ensure accuracy, consistency, and completeness of data.
• Identify and resolve data anomalies, inconsistencies, and errors during transformation.
• Collaborate with stakeholders to define data quality standards and metrics.
• Monitor ETL process performance and identify bottlenecks or inefficiencies.
• Optimize ETL workflows, queries, and transformations to improve processing speed and resource utilization.
• Implement best practices for ETL performance tuning and scalability.
• Manage ETL tools and platforms (ex. Informatica).
• Configure and maintain ETL environments, ensuring they are secure, reliable, and up to date.
• Evaluate and recommend new ETL tools or technologies to enhance data transformation capabilities.
• Ensure ETL processes comply with DoW organizational policies, industry standards, and regulatory requirements (Ex. Managing PII data).
• Implement data governance practices to maintain data lineage, metadata, and audit trails.
• Collaborate with data stewards and governance teams to enforce data security and privacy measures.
• Create and maintain detailed documentation for ETL workflows, data mappings, and transformation logic.
• Provide regular reports on ETL process performance, data quality metrics, and operational status.
• Document lessons learned and best practices to improve future ETL implementations.

Years of Experience: 10+ years’ professional experience in IT or related field

Clearance Level & Investigation: Tier 3 or equivalent (ADP/IT-II)

IT Level (AR 25-2): IT-II or NACLC

IA Cert Level (DoD 8570.01): IAT Level II

Computing Environment Certifications: Relevant certification from nationally recognized authority (preferred), * 10+ years of overall professional experience in IT or related field.

• Must have knowledge and expertise in the following: ETL Process Design and Development; Data Transformation and Integration; Data Quality and Validation; Performance Optimization; ETL Tool Management; Data Governance and Compliance; Documentation and Reporting; Incident Management and Troubleshooting.

Required Clearance:

• Must possess IT-II security clearance or have a current National Agency Check with Local Agency Check and Credit Check (NACLC).

Certifications:

• Relevant certification from a nationally recognized technical authority preferred.
• DoW Approved 8570 Baseline Certification: Category IAT Level II.