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:
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
Core hours: 8:00AM – 2:00PM
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.