POSITION: Data Ingestion/ETL Developer

LOCATION: Reston, VA

DEPARTMENT: JIDO

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