Apply Now    

Senior ETL (ODI) Developer

Req #: 244263_70114
Location: New Orleans, LA US
Job Category: Information Technology
Minimum Clearance Required: Secret

Job Description

Senior Software Developer (ETL) for an opportunity to join the Navy Personnel and Pay (NP2) team in New Orleans, LA.

CACI is currently searching for a Senior Professional Software Developer (ETL) to implement an Oracle Data Integrator (ODI) solution in an analytical environment: design approach, processes and transformation using Oracle Data Integrator. Developer opportunity is located in New Orleans, LA.

The candidate will develop using ODI to support a data warehouse and follow best practice approach for logical and physical data structure.  Principal disciplines include data modeling and standardization, utilizing ODI best practices, developing an E-LT solution within the environment, building and automating processes using Oracle Data Integrator.  Candidate will need to possess knowledge of PL/SQL to re-engineer and develop within the ODI tool.

Candidate must be capable of developing default strategies, transforming as needed to populate target tables, develop ETL or E-LT specification documentation (for high level planning and physical design), populate dimension tables with historic data, execute bulk and incremental load processes, develop processes for dimension and fact tables incremental loads, and schedule jobs to kick off at a certain time.

Basic Qualifications:

  • Candidate should have good written and verbal communication skills, and should be able to work efficiently individually or in a team environment.
  • Must possess 5+ years of experience utilizing Oracle Data Integrator (ODI) as the ETL tool.
  • Perform ETL system planning and design, complete logical design, draft architectural plan, and draft source to target mapping of data elements. 
  • Maintain existing structure and make decisions for the design to make the appropriate technical decisions for the overall warehouse project. 
  • Extract, data, clean and conform, deliver for presentation and maintain an ETL environment.
  • Ability to understand and construct complex select statements. Experience with warehouse concepts and design.
  • Bachelor's Degree in Computer Science or Software Engineering.  (4 years of additional experience may be substituted for a Bachelor Degree).
  • Interim Secret clearance (or full Secret)

Desired Qualifications:

  • The desired candidate will possess ETL ODI application experience with enterprise information to support an analytical environment with multiple source data and universes, and data marts. 
  • Kimball dimensional modeling experiences a plus.
  • RDBMS (Relational database management system) concepts; SQL knowledge, and the ability to understand and construct complex SQL statements is required for this position.

Job Location

US-Remote (Any State)-VA-NEW ORLEANS


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