|Dynology Corporation Career Portal|
Senior Professional Software Developer 2019T0018003
- Job Title
- Senior Professional Software Developer 2019T0018003
- Job ID
- New Orleans, LA
- Other Location
GDIT is currently 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.
Required: Basic Qualifications/Skills Candidate should have good written and verbal communication skills, and should be able to work efficiently individually or in a team environment.
Education Bachelor Degree
Work Experience 6-9 Years
Required: Responsibilities 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.
Required: Must be a U.S. Citizen and have a current Secret Clearance
Education Bachelor's Degree in Computer Science or Software Engineering. (4 years of additional experience may be substituted for a Bachelor Degree)
Desired: Responsibilities/Skills Expertise using Oracle Data Integrator (ODI).
Expertise in SQL, PL/SQL.
Clearance requirements: Secret