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