ETL Developer – SCI Clearance – Reston, VA 20190


Data acquisition engineer performing Extract Transform Load (ETL)

Created to develop workflows to acquire data, analyze, manage, maintain, and evaluate state-of-the-art extraction, transforming, and loading capabilities to maintain a timely data corpus

  • 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 with the development, maintenance, and enhancement of data mappings, work-flows, and processes
  • 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, JSON, 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
  • BA or BS degree preferred
  • Database Administration, ETL, or Business Intelligence-related Certifications preferred
  • DoDD 8570 Compliance Certification, including Security+

Job Type: Full-time

Pay: $130,000.00 – $140,000.00 per year

Benefits:

  • 401(k)
  • 401(k) matching
  • Dental insurance
  • Flexible schedule
  • Health insurance
  • Life insurance
  • Paid time off
  • Vision insurance

Schedule:

  • 8 hour shift
  • Monday to Friday

Education:

  • High school or equivalent (Preferred)

Experience:

  • SQL: 1 year (Required)
  • Data Warehouse: 1 year (Required)

Security Clearance:

Work Remotely:

  • Yes, temporarily due to COVID-19



Source link

Author: admin