View Our Website View All Jobs

Data Ingestion/ETL Developer

Data Ingestion/ETL Developer

Reston, VA

Candidate must be a U.S. Citizen and have an active TS/SCI

Role 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, un–structured, and semi–structured reporting into a schema–less 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:

  • 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, work–flows, 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
Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file

150
To comply with government Equal Employment Opportunity / Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Gender
Race/Ethnicity
Veteran/Disability status