PersMod Systems Engineer - ETL

Systems Engineering,Data Mart,Kimball,Data Structure,ETL,RDBMS,Dimensional Modeling,Data Warehousing,Logic Design,ODI,Relational Database,SQL
Full Time
Depends On Experience
Telecommuting not available Travel not required

Job Description

Join CSRA and be a part of the team of men and women that solve some of the world’s most complex technical challenges. The Personnel Modernization (PersMod) program is searching for a Systems Engineer; Extract, Transformation, and Load (ETL) Developer for an opportunity in New Orleans, LA.

The candidate will execute ETL tasks to support a data warehouse and follow best practice approach for logical and physical data structure.  Principal disciplines include data modeling and standardization, designing an ETL environment and processes, building and automating the processes using the Oracle Data Integrator tool. Candidate will possess knowledge of the ODI tool, capable of developing a set of default strategies, transforming as needed to populate target tables, develop ETL specification document (for high level planning and physical design), populate dimensions table with historic data, execute bulk and incremental load processes, develop processes for dimension and fact table incremental loads, and schedule a job to kick off at a certain time.

The desired candidate will possess ETL administration 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.

Duties also include:

  • 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.
  • Understand and construct complex select statements.
  • Experience with warehouse concepts and design.

Basic Qualifications:

  • Bachelor's Degree in Computer Science or Software Engineering.  (4 years of additional experience may be substituted for a Bachelor Degree)
  • 1-3+ years of systems engineering experience, specifically with ETL
  • Interim Secret clearance required to start; Secret preferred

Desired Skills:

  • Expertise using oracle Data Integrator (ODI).
  • Expertise in SQL, PL/SQL.

Delivering Next Generation IT Solutions
CSRA delivers 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 CSRA
As a CSRA 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 : CSRA741233
Have a Job? Post it

Similar Positions

ETL Developer needed to
  • CyberCoders
  • New Orleans, LA
Remote-DWH/Data and Process Modeler
  • CompuGain Corporation
  • New Orleans, LA
ETL Developer
  • Actium Consulting
  • Baton Rouge, LA
Informatica B2B DX Lead & Developer
  • Inspiration Global
  • Baton Rouge, LA
Informatica B2B DX Lead
  • Techpeople.US, Inc
  • Baton Rouge, LA
Informatica B2B DX Lead & Developer
  • Fabergent
  • Baton Rouge, LA
Informatica B2B DX Lead & Developer
  • Synergy Global Technologies Inc
  • Baton Rouge, LA
Senior Business Intelligence Analyst
  • Synthesis Systems, Inc.
  • Ridgeland, MS
Informatica / MDM Lead Developer
  • Arthur Lawrence
  • Beaumont, TX
DataStage Developer
  • Sapient Corporation
  • Houston, TX