CACI International Jobs

Job Information

CACI International ETL Software Developer (TS/SCI with Polygraph) in Mclean, Virginia

Job Description

What You’ll Get to Do:

CACI is seeking fully cleared, dynamic technical professionals to join our TETRA program in the Northern, Virginia area. TETRA is an Enterprise IT Program that supports and protects the IC mission. The program is a portfolio of hundreds of projects funded by numerous customers providing Engineering and Sustainment services for a Global Information Technology Enterprise. As a team, we architect, develop, engineer, maintain, and provide continuous sustainment of enterprise-level communications in support of the customer’s mission worldwide. We also provide secure, reliable, and cost-effective enterprise-class data center hosting services, in which we develop, integrate, and maintain. Be a part of something greater than yourself and make a lasting impact at CACI.More About the Role:

CACI’s Business and Information Technology Solutions (BITS) Sector is seeking a Software Developer with extract, transform, and load (ETL) experience to be a part of a larger team of software developers supporting real mission initiatives. This position entails extracting, transforming, and loading raw data into databases utilizing Pentaho, SQL Developer, Java, Oracle, RDS, and other tools. Raw data is extracted into database tables and cleansed to ensure information is appropriately categorized. As a Software Developer, you will work with other parts of the team to maintain process, schedule, and quality controls.

Your responsibilities will include the following:

  • 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

  • Leveraging experience to provide support in the areas of data extraction, transformation, and load, and data mapping

  • Providing analytical support, database support, and maintenance support for data exploitation systems

  • Providing and supporting large-scale file manipulation, data modeling, data mapping, data testing, data quality, and documentation preparation

  • Working with other teams, program leadership, and key stakeholders, as needed

You’ll Bring These Qualifications:

  • TS/SCI with Polygraph clearance (active / in-scope)

  • Experience with databases in Amazon Web Services (AWS)

  • Experience with Pentaho

  • Ability to analyze, design, build, test, implement, and support ETL solutions for multiple subject areas sourced from disparate data sources

  • Possess analytic problem-solving skills

  • Fluent in data manipulation languages, such as MySQL, Microsoft SQL Server, and/or PostgreSQL

  • Demonstrated experience with Oracle development, SQL, and PL/SQL

  • Knowledge of computer software applications, including database technologies and programming languages

  • Excellent written and verbal communication skills

  • Detail oriented skills

  • Proven expertise and experience with data scripting and manipulation

  • Developed experience with Java, C#, or Python

  • Demonstrated experience performing data ingestion on an enterprise-level (structured and unstructured)

  • Demonstrated experience with design mappings for data capture, staging, cleansing, transforming, loading, and auditing

  • Ability to develop ETL design documentation, including source code

Candidate must have one of the following:

  • 12 Years of job related experience and High School/GED diploma

  • 10 Years of job related experience and Associates 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

These Qualifications Would be Nice to Have:

  • Bachelor’s degree in Computer Science, Software Engineering, or related field of study

  • Experience with data modeling in a large enterprise-class database environment

  • Experience with Perl and PowerShell scripting

  • Experience with data security policies

  • Experience with Microsoft SQL Server

Work Hours:

  • Core hours: 8:00 AM – 2:00 PM

Work Location:

  • McLean, VA

What We Can Offer You:- We’ve been named a Best Place to Work by the Washington Post.- Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives.- We offer competitive benefits and learning and development opportunities.- We are mission-oriented and ever vigilant in aligning our solutions with the nation’s highest priorities.- For over 55 years, the principles of CACI’s unique, character-based culture have been the driving force behind our success.




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.