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.
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)
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.