Smashing Boxes is looking for a Senior Software Engineer in the New Orleans, LA area with a knack for problem solving and a love of bleeding-edge web technology to Extract, Transformation, and Load (ETL) for a current long-term government project. Be a part of the team of men and women that solve some of the world's most complex technical challenges.
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. SQL knowledge, and the ability to understand and construct complex SQL statements is required for this position. Kimball dimensional modeling experience and knowledge of RDBMS (Relational database management system) concepts are a plus.
Candidates must be US citizens and required to have an ACTIVE DoD Secret clearance.