Todays Jobs
Job Role
Job Types
Sector
Aircraft type
Software Developer
Apply now
Location: Reston
Job type: Permanent
Aircraft type:
Contact:
Sector: Manufacturing
Job Role:
Req #: 219972
Location: Reston, VA US
Job Category: Information Technology
Security Clearance: TS/SCI with Polygraph
Clearance Status: Must Be Current
Job Description
The Software Developer (ETL/Java) will be part of a larger team of Software Developers supporting real mission initiatives. The position entails extracting, transforming, and loading raw data into databases using Pentaho, SQL Developer, Java and other tools. Raw data is extracted into database tables and cleansed to make sure information is appropriately categorized. Additionally, the Developer will work with other parts of the team to maintain process, schedule and quality controls.
JOB RESPONSIBILITIES:
* Responsible for completion of each data set in an efficient and timely manner.
* Maintaining records of what and how information was extracted, transformed and loaded.
* Utilizing knowledge of tools for automation or process improvement, if applicable.
* Leverage experience to provide support in the areas of data extraction, transformation and load (ETL), data mapping, data extraction,
* Provide analytical support, database support, and maintenance support for data exploitation systems.
* Provide and support large-scale file manipulation, data modeling, data mapping, data testing, data quality, and documentation preparation.
* Work with other teams, program leadership, and key stake holders as needed.
You will bring:
* Proven expertise and experience with data scripting and manipulation
* Development experience in Java or C#
* Demonstrated experience performing data ingestion on an enterprise level (structured and unstructured)
* Demonstrated ability to analyze, design, build, test, implement and support ETL solutions for multiple subject areas sourced from disparate data sources
* Demonstrated experience with basic command line administration in a Linux environment
* Demonstrated experience with Oracle development, SQL, and PL/SQL
* Demonstrated experience with software configuration management utilizing COTS tools (eg. Subversion)
* Demonstrated experience with design mappings for Data Capture, Staging, Cleansing, Transforming, Loading and Auditing
* Must have active TS/SCI with Polygraph
You will have one of the following:
* 12 Years of job related experience and High School/GED diploma
* 10 Years of job related experience and Associate degree
* 8 Years of job related experience and Bachelor’s degree
* 6 Years of job related experience and Master’s degree
* 4 Years of job related experience and Doctorate
It would be nice if you had:
* Experience in data modeling in a large Enterprise class database environment
* Experience with Perl, Pentaho, and Shell Scripting
* Experience with Data Security policies
* Experience Microsoft SQL Server
* Familiarity with Hadoop, Marklogic, Hbase, or similar technologies
* Ability to analyze, design, build, test, implement and support ETL solutions for multiple subject areas sourced from disparate data sources
* Ability to develop ETL design documentation including source
Core hours:
9am to 2:30pm
Work location:
McLean, VA
Job Location
US-Reston-VA-VIRGINIA SUBURBAN
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.
Apply for this job