Data Ingestion/ETL Develolper – 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

Clearance: TS/SCI

Required Qualifications and Skills:
Note: These are mandatory items that all candidates must have when making application to Blue Sky for this position. Please ensure that your submission addresses each of these requirement items. Candidates without these required elements will not be considered.

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

Who We Are

Blue Sky Innovative Solutions (Blue Sky) assists its federal, state and local, and commercial clients with solving their toughest challenges in the areas of IT Infrastructure Support and Engineering; Application Development and Maintenance; Program and Project Management; and Management Consulting. Find out more about Blue Sky at Blue Sky is an equal opportunity employer and recruits mission-oriented, proactive, skilled candidates from across the United States. As an SBA certified HUBZone small business, Blue Sky has a special interest in recruiting and hiring personnel who reside in HUBZones. To determine whether you reside in a HUBZone, visit #CJBSIS


Source link

Author: admin