Apply Now    

ETL Software Developer

Req #: 244461
Location: Mclean, VA US
Job Category: Information Technology
Minimum Clearance Required: TS/SCI with Polygraph

Job Description

CACI is seeking fully cleared, dynamic technical professionals to join our TETRA program in the Northern, Virginia area.  Be part of something greater than yourself and make a lasting impact at CACI.  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 customers’ mission worldwide.  We also provide secure, reliable, and cost-effective enterprise class data center hosting services, in which we develop, integrate, and maintain.

What You’ll Get to Do:

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

More About the Role:

Your responsibilities will include the following:

  • Completion of each data set in an efficient and timely manner

  • Maintaining records of what and how information is extracted, transformed, and loaded (ETL)

  • 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 (ETL), 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:

  • Experience with databases in Amazon Web Services (AWS)

  • 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, and/or PostgreSQL

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

  • Excellent verbal and written communication skills

  • Detail oriented skills

  • Proven expertise and experience with data scripting and manipulation

  • Development experience in Java, C#, or Python

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

  • 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 (e.g., Apache Subversion)

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

  • Experience with Pentaho

  • 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 Associate’s 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 in data modeling in a large enterprise class database environment

  • Experience with Perl, Pentaho, and PowerShell scripting

  • Experience with data security policies

  • Experience with Microsoft SQL Server

  • Familiarity with Apache Hadoop, MarkLogic, Apache HBase, or similar technologies

Work Hours:

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

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.

Apply Now