PersMod Sr. Software Developer (ETL) RQ32398

Software Engineering,ETL,Data Modeling,ODI,Data Warehousing,Data Mart,Security Clearance,Kimball,SQL,Data Structure,Dimensional Modeling,Logic Design,Relational Database
Full Time
Depends On Experience
Work from home not available Travel not required

Job Description

GDIT along with the Navy Personnel Modernization (PersMod) program seeks a PersMod Sr. 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. The opportunity is located in New Orleans, LA.

Basic Qualifications:

  • Bachelor's Degree in Computer Science or Software Engineering (4 years of additional experience may be considered in lieu of a degree)
  • 5+ years of experience with ETL ODI, RDBMS, SQL and data warehouse design
  • Secret clearance

Candidate will need to:

  • Possess knowledge of PL/SQL to re-engineer and develop within the ODI tool.
  • 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.
  • 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.
  • Utilize 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.

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. 

GDIT (General Dynamics Information Technology) is the premier provider of high-tech IT solutions to the government IT market. We deliver cost-effective, next-generation IT solutions and services to the Department of Defense, the intelligence community and federal civilian agencies as they modernize their information systems.

We are a company of over 40,000 smart, talented individuals who are committed to a stronger and better future for America through next-generation thinking and meaningful results.

Delivering Next Generation IT Solutions
We deliver a broad range of innovative, next-generation IT solutions and professional services to help our customers modernize their legacy systems, protect their networks and assets, and improve the effectiveness and efficiency of mission-critical functions for our warfighters and our citizens.

Committed to Our Country and Communities
Whether we're helping our U.S. government customers meet their mission and operational challenges or working to address critical needs within our local communities, we bring the same level of passion and commitment, developing solutions that meet or exceed the challenge.

Join Us
As an employee, you get to be part of a best performing team supporting our nation's most critical missions. We give you the tools to be successful; all you need to do is bring your best ideas, your energy and a desire to develop your skills, experience and career.

Dice Id : 90833617
Position Id : GDIT595275
Have a Job? Post it

Similar Positions

Oracle ADF Java Software Engineer
  • Mastech Digital
  • New Orleans, LA
Senior DataStage ETL Developer
  • Brooklyn, MS
Senior Business Intelligence Architect: Healthcare
  • Acadian Ambulance
  • Lafayette, LA
Talend Developer
  • Kellton Tech
  • Houston, TX
Talend ETL Consultant
  • Infometry Inc.
  • Houston, TX
ETL Developer
  • Capgemini
  • Houston, TX
ETL Architect
  • IBS Group
  • Houston, TX
Oracle PL/SQL Developer
  • Wise Men Consultants
  • Houston, TX
PL/SQL Developer
  • Robert Half Technology
  • Houston, TX
Data Integration Analyst
  • TekisHub Consulting Services
  • Houston, TX
Data Architect
  • FSTONE Technologies
  • Houston, TX