W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J36993

  • Specialized Area:

    ETL

  • Job Title:

    ETL developer

  • Location:

    New Orleans,LA

  • Duration:

    7 Months

  • Domain Exposure:

    Pharmaceuticals, Retail, Real Estate

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

Roles and Responsibilities:

  • 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.

Apply Now
Equal Opportunity Employer

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract