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