ETL Developer

ETL Developer

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: None

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Local

* * *

The Opportunity:
CACI is currently looking for a ETL Developer with Agile methodology experience to join our BEAGLE (Border Enforcement Applications for Government Leading-Edge Information Technology) Agile Solution Factory (ASF) Team supporting Customs and Border Protection (CBP) client located in Northern Virginia!

Join this passionate team of industry-leading individuals supporting the best practices in Agile Software Development for the Department of Homeland Security (DHS). Serve as an Agile Scrum team member providing software development and maintenance for the delivery of releasable software in short sprint cycles. Responsible for activities associated with delivery of software solutions associated with customer-defined systems and software projects by working in close collaboration with software developers/engineers, stakeholders, and end users within Agile processes.

HYBRID options available!

Responsibilities:

• Designing, developing and implementing custom software and database application capabilities for a variety of legacy and modernized systems with limited oversight
• Acting as a member of a product team supporting teammates and collaborating with a do what it takes attitude to ensure product and team success
• Providing improvements to the product(s) being supported
• Actively participate in release and sprint planning, artifact creation, sprint testing, regression testing, demonstrations and retrospectives and solution releases
• Supporting release planning with conceptual design and development / refinement of software engineering guidelines
• Analyzing complex project-related problems and creating innovative solutions involving, scheduling, technology, methodology, tools and solution components
• Ensuring product quality and timeliness of work, providing advice and guidance, resolving problems to meet objectives, and providing periodic performance reports
• Providing mentoring to junior members of the team

Qualifications:

Required: 

• Must be a U.S. Citizen with the ability to pass CBP background investigation, criteria include but are not limited to:
  • 3 year check for felony convictions
  • 1 year check for illegal drug use
  • 1 year check for misconduct such as theft or fraud

• College degree (B.S.) in Computer Science, Software Engineering, Information Management Systems or a related discipline.  Equivalent professional experience will be considered in lieu of degree
• Professional Experience: at least seven (7) years related technical experience, with software design, specializing in database architecture and development for Business Intelligence solutions
• You are good at:
  • Database ETL (Informatica, AWS DMS, Kafka), Apache Sparks, Database design and development (DataBricks, Oracle RDBMS, and PostgreSQL),
  • Software Development methodology / best-practices
  • Familiarity with Business Intelligence software (Qlik Sense, Cognos, SAP Business Objects)
  • Object oriented design and development principals, Service Oriented Architecture (SOA), Micro-Services architecture
• Working on unusually complicated problems and providing solutions that are highly creative and ingenious, exhibiting ingenuity, creativity, and resourcefulness
• Acting independently to expose and resolve problems
• Experience with source code control systems and concurrent development workflows (Git preferred)
• Ability to apply estimation techniques to software development efforts
• Working knowledge of and ability to assist others in the use of software engineering tools to support process improvement
• Excellent written and verbal communication skills
• Strong collaboration skills and desire to work within a team
• Show good initiative, team-oriented individual with very strong work ethic and a self-starter

Desired:

• Technical Certifications, such as OCAJP; OCPJP; OCE, OCM; CSM or similar.
• DOD 8570 certification
• Ability to apply advanced principles, theories, and concepts, and contribute to the development of innovative principles and ideas
• Direct experience providing support for applications utilizing Oracle databases

• Additionally, familiarity with any of the following highly desirable: Jira, Confluence, GitLab, Jenkins, Chef, Ansible, Kafka, DISA STIGs, Python

-