CACI International ETL Developer in Remote (Any State), Virginia
Job Category: Information Technology
Time Type: Full time
Minimum Clearance Required to Start: NACI
Employee Type: Regular
Percentage of Travel Required: None
Type of Travel: None
CACI is seeking an ETL Developer in supporting of a new program and customer initiative. Work location is REMOTE
Duties & Responsibilities
Be responsible for designing robust ETL framework with proper triggers and data quality checks in place.
Be responsible for designing and maintaining BI environment with underlying AWS Redshift and Oracle databases.
Partner with cross-functional teams to understand the business and analytics needs.
Support Cloud development pipelines using Jenkins, Cloud Formation, Puppet and other tools as appropriate.
Script and automate system tasks to reduce manual repetitive work using Terraform, Puppet and other technologies as appropriate.
Participate in production software deployments working closely with other members of the production support group to ensure the proper transition of system changes into the production environments.
Perform general technical trouble shooting & give consultation to development teams.
Bachelor’s Degree or equivalent in Computer Science, Mathematics, Information Systems Management or 5 years of experience in related engineering field.
5 years of experience in data warehouse design and implementation initiatives, knowledge of various data modeling methodologies, relational, dimensional or hybrid.
Experience with Oracle SQL coding and tuning.
Experience designing and developing enterprise-level ETL processes, Matillion required.
Experience writing, optimizing, and validating SQL queries.
A full understanding of the software development life cycle (Agile and Waterfall)
Ability to independently research and resolve technical problems in a complex IT environment with local and remote groups
Strong analytical, organizational, problem-solving, and time-management skills
Strong communication (verbal and written) and listening skills
Must be able to obtain and maintain a Public Trust Clearance.
Experience supporting AWS Redshift production environment
Experience with Oracle database
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.
Company Overview: 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 an Equal Opportunity Employer – Females/Minorities/Protected Veterans/Individuals with Disabilities.
Pay Range: The proposed salary range for this position is $65,300-$134,000. There are a host of factors that can influence final salary including, but not limited to, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, geographic location, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. Employment benefits include health and wellness programs, income protection, paid leave and retirement and savings.
As a federal contractor, CACI is subject to any federal vaccine mandates or other customer vaccination requirements. All new hires are required to report their vaccination status.