Data Ingestion/ETL Develolper job – Blue Sky Innovative Solutions – 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, 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:
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, 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



Source link

Author: admin