Data Ingestion/ ETL Developer job – Red Gate Group LTD – Reston, VA


Data Ingestion/ ETL Developer

Red Gate Group LTD

2 reviews

Reston, VA 20190


POSITION: Data Ingestion/ETL Developer

Reston, VA


Active TOP SECRET (TS) with Sensitive Compartmented Information (SCI) access

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, 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:

  • 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
  • TS/SCI clearance in JPAS is required

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

original job

Apply Now

Please review all application instructions before applying to Red Gate Group LTD.

Other jobs you may like


Red Edge
Arlington, VA
2 days ago

Easily apply

ETL Developer

Harmonia Holdings Group, LLC.
McLean, VA
3 days ago

2 reviews

The Red Gate Group (RGG), a Service Disabled, Veteran Owned Small Business, (SDVOSB) is based in Northern Virginia. Formed in 2006, RGG has…

Thousands of employers search for candidates on Indeed


Source link

Author: admin