ETL Developer

Information Technology Consulting New Orleans, Louisiana


Description

Job Description

CSCI Consulting is seeking a Systems Engineer (ETL Developer). This position 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.

 

Minimum Requirements

  • Active Department of Defense Secret Clearance.
  • 4-8 years’ experience with ETL Development.
  • Experience in the following areas:
    • SQL
    • PL/SQL
    • Use of Oracle Data Integrator (ODI) tool
  • Bachelors degree in Computer Science or Software Engineering.
    • 8 years of experience can be substituted for degree.
  • Ability to work with clients to understand their needs.
  • Demonstrated ability to comply with data standards and policies.
  • Excellent written and oral communication skills.
  • Professional presence is required.
  • All candidates must be U.S. Citizens and be able to pass a Federal background investigation.

Preferred Skills

  • Department of Defense experience is a plus.
  • Strong organizational and time management skills.
  • Ability to maintain a positive relationship with customers and other vendors.
  • Capability to work in a team environment, as well as independently.
  • Possess motivation to learn new technologies and methodologies that demonstrate value.
  • Past experience working for a Federal Agency.

Benefits of working at CSCI

  • Competitive Salaries
  • 20 Days PTO + Paid Holidays
  • Full Health Benefit Package including Medical, Dental and Vision
  • 401K Retirement Plan
  • Team Building Events and Employee Parties

 

CSCI Consulting is an Equal Employment Opportunity and Affirmative Action employer. It is the policy of CSCI Consulting to provide equal employment opportunity in accordance with all applicable Equal Employment Opportunity/Affirmative Action laws, directives and regulations to all employees and qualified applicants without regard to race, ethnicity, color, religion, national origin, sex, age, disability status, pregnancy, sexual orientation, gender identity, genetic information, protected veteran status, or any other protected status under Federal, State or Local laws.

CSCI Consulting is committed to helping individuals with disabilities to participate in the workforce and ensuring equal opportunity to compete for jobs. If you require an accommodation, please contact CSCI Human Resources for further assistance. For questions regarding the qualifications listed above please contact the CSCI Talent Acquisition Team.

Disclaimer: The above declarations are not intended to be an all-inclusive list of the duties and responsibilities of the job described, nor are they intended to be such a listing of the skills and abilities required to do the job. Rather, they are intended only to describe the general nature of the job.

We are an E-Verify employer where mandated by State or Federal contracts.

For more information, please click on the following links:
E-Verify Participation Poster: English | Spanish
E-Verify Right to Work Poster: English | Spanish