Data Ingestion/ETL Developer, (MIT) job – CACI – Reston, VA


Job Description

What You’ll Get to Do:
As a Data Ingestion/ETL Developer, you will 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.

More About the Role:
You will 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 semi–structured reporting into a schema–less Accumulo database.

You will design, develop, test, implement, and support innovative and optimal data solutions.

You will interact with websites, web services, e-mail feeds, etc., while learning about the network interaction on the http/https level including security, cookies, headers, and processing attachments to extract information.

You will 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 .

You’ll Bring These Qualifications:
Current Top Secret/Specialized Compartmented Information Security Clearance, willingness to submit to a CI Poly.

Possess the ability to effectively communicate both orally and in writing.

More than one year of experience with Java and JavaScript, relational databases as well as development, maintenance and enhancement of data mappings, work-flows and processes.

Experience with ETL development and processes from diverse data sources, and experience with data modeling concepts.

Willing to work rotating shifts if needed.

Bachelor’s degree and three years of experience, or associates degree and seven years of experience, or nine years of relevant work experience.

These Qualifications Would be Nice to Have:
Bachelors degree in IT, CS, Computer Engineering or Systems Engineering.

Database Administration, ETL, or Business Intelligence-related certifications.

DoDD 8570 Compliance Certification, including Security+.

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 as a database administrator.

Experience with DoD or IC clients.

Ability to work independently with some government oversight and function effectively as part of a team in a joint working environment.

What We Can Offer You:
CACI-WGI (The Wexford Group International) is a wholly-owned subsidiary of CACI with a reputation for uncompromising standards of quality in its people and its performance. Joining the CACI-WGI team is a mark of excellence for those employees who complete our rigorous Recruiting, Assessment, and Selection (RAS) process.

CACI-WGI’s mission places its personnel against the government’s most critical emerging challenges. Work with us and you’ll be working with a team making a difference across the globe.

CACI-WGI offers competitive benefits as well as numerous learning and development opportunities.

Job Location


CACI employs a diverse range of talent to create an environment that fuels innovation and fosters continuous improvement and success. At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is proud to provide dynamic careers for employees worldwide. CACI is an Equal Opportunity Employer – Females/Minorities/Protected Veterans/Individuals with Disabilities.


Source link

Author: admin