Data Ingestion/ETL Developer – TS/SCI Cleared – Reston, VA


Data Ingestion/ETL Developer
Reston, Virgina

Job description:
Maintain responsibility for the design, development, and maintenance of Extract, Transform, and Load (ETL) workflows and scripts for a large analytic data Cloud project for a DoD agency. Leverage Pentaho Kettle combined with thorough knowledge of data modeling, ETL, SQL scripting, and analytical expertise to extract a wide variety of structured, unstructured, and semistructured reporting into a schemaless Accumulo database. Design, develop, test, implement, and support innovative and optimal data solutions.

In this role you will:

  • Interact with websites, web services, e-mail feeds, etc., learning about the network interaction on the http/https level including security, cookies, headers, and processing attachments to extract information
  • Learn the details of JavaScript/AJAX/JQUERY DOM implementations, certificate exchanges, and web bots as they are used to extract information for REGEX ETL transformations

Basic Qualifications:

  • TS/SCI in JPas clearance is required
  • 1+ years of experience with Java and JavaScript
  • 1+ years of experience with relational databases
  • 1+ years of experience in the development, maintenance, and enhancement of data mappings, workflows, and processes
  • Experience with ETL development and processes from diverse data sources
  • Experience with data modeling concepts

Additional Qualifications:

  • Experience with PostgreSQL, Pentaho Kettle, Accumulo, SOLR, NetOwl, Tableau, and PhantomJS
  • Experience with a variety of data feed types, including RSS, SOAP, and REST
  • Experience with DoD or IC clients
  • Experience as a database administrator
  • Knowledge of the Agile software development process, including Kanban
  • Possession of excellent oral and written communication skills
  • BS degree in IT, CS, Computer Engineering, or Systems Engineering preferred
  • DoDD 8570 Compliance Certification, including Security+
  • Database Administration, ETL, or Business Intelligence-related certifications preferred

Job Type: Full-time

Salary: $120,000.00 /year

Application Question:

  • What is your security clearance level?

Benefits:

  • Health insurance
  • Dental insurance
  • Vision insurance
  • Paid time off



Source link

Author: admin