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’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.
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.