Data Acquisition ETL Engineer (TS/SCI)
On-siteReston, Virginia, United States
Reston, Virginia, United StatesOn-siteFull TimeSenior LevelHigh School Or Equivalent
Full TimeSenior LevelHigh School Or Equivalent
Job Summary
Conduct Extract Transform Load (ETL) workflows to acquire, analyze, manage, maintain, and evaluate state-of-the-art data extraction capabilities. Determine data ingest quality issues and propose recommendations for elimination while assisting in the formulation of data ingest processes. Provide subject matter support to provision information technology and ETL operations. Work within a team to develop processes that maintain a timely data corpus using diverse data sources including RSS, SOAP, and REST. This role supports DoD or IC clients within a TS/SCI environment in Reston, VA.
Required Qualifications
- 2+ years of experience with Java
- 1+ years of experience with a streaming data framework, including Apache Kafka
- 1+ years of experience with web-based architecture, including HTML and JavaScript
- 1+ years of experience with ETL development and processes from diverse data sources
- 1+ years of experience in working with Relational Databases
- Experience with a variety of data feed types, including RSS, SOAP, and REST
- Experience with data modeling concepts
- TS/SCI clearance required
- HS diploma or GED
- Experience with XML, and TXT transformations, including writing and applying XSLT to transform data
- Experience with any of the following technologies: Apache Kafka, NiFi, Airflow, PostgreSQL, Pentaho Data Integration, Accumulo, Solr, Elastic Stack, Firefox, Chromium, or Kubernetes
- Experience with DoD or IC clients
- Experience as a database administrator
- Experience with web scraping, including Document Object Model (DOM) exploration
- Knowledge of the Agile software development process, including Scrum and Kanban
- Ability to map and document needed data elements in multiple databases to aggregate them under one schema
- ComptTIA Security+
Desired Qualifications
- BA or BS degree preferred
- Database Administration, ETL, or Business Intelligence-related Certifications preferred
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.