Oracle ETL Developer Job at VDart, Pennsylvania

M05YRzdTeFpFTExXaFpiWDMzMC8wZFB5eFE9PQ==
  • VDart
  • Pennsylvania

Job Description

Title: Oracle ETL Developers


Location: remote


Duration: 3+ month

Job Summary


We are seeking an experienced ETL Developer with strong expertise in Oracle Warehouse Builder (OWB) and Oracle Data Integrator (ODI) to support the migration of legacy OWB mappings to ODI. The ideal candidate will play a critical role in re-engineering and optimizing ETL processes, ensuring a smooth and efficient transition to modern Oracle integration platforms.

Key Responsibilities

  • Analyze existing OWB mappings, process flows, and metadata.




  • Design and develop equivalent ETL processes in ODI (preferably ODI 12c).




  • Collaborate with data architects, DBAs, and business analysts to ensure migration aligns with business and technical requirements.




  • Develop and maintain documentation for the migration process and data flow mappings.




  • Optimize and refactor ETL logic during migration for performance and maintainability.




  • Perform data validation, reconciliation, and troubleshooting post-migration.




  • Support deployment and post-migration testing in various environments (DEV, UAT, PROD).




  • Train and guide internal teams on ODI processes and best practices, if needed.

Required Skills and Qualifications

  • 5+ years of experience with ETL tools, including at least 2 years with ODI.




  • Proven experience in OWB and hands-on experience migrating OWB projects to ODI.




  • Strong SQL and PL/SQL skills.




  • Experience working with Oracle databases and data warehousing concepts.




  • Familiarity with data modeling and metadata management.




  • Strong problem-solving and debugging skills.




  • Excellent communication and documentation abilities.

Preferred Qualifications

  • Experience with ODI 12c (Knowledge of ODI components, packages, load plans, mappings).




  • Knowledge of performance tuning in both OWB and ODI environments.




  • Exposure to Agile methodologies and DevOps CI/CD processes.
VDart

Job Tags

Remote job,

Similar Jobs

Lakeland Regional Health

Primary Care Physician-LAKE WALES Job at Lakeland Regional Health

 ...0 bed academic state of the art teaching facility. LRH has achieved multiple workplace awards from highly reputable names including Aetna, Forbes and the Florida Hospital Association. Our 910-bed main campus operates a Level II Trauma Center, a Level III Neonatal Intensive... 

Canada Cartage

Cyber Security Analyst Job at Canada Cartage

 ...Document systems security implementations, operations and maintenance activities and update as...  ...the year, like summer barbeques and driver-appreciation week that regularly bring us...  ...for six straight years in a row. ~ Trucking HR has announced that Canada Cartage has... 

Costco Wholesale Corp.

Forklift Operator Job at Costco Wholesale Corp.

 ...Costco Wholesale Corp. - 98-600 KAMEHAMEHA HWY [Warehouse Associate / Forklift Operator / Up to $29.90-hr + $1/hr premium] As a Forklift Operator at Costco, you'll: Operate an electric stand-up forklift to move pallets of merchandise and equipment throughout the warehouse... 

Interior Health Authority

Registered Nurse | General Duty Pediatrics Job at Interior Health Authority

 ...seeking an experienced and dynamic Registered Nurse to join our Pediatrics department at the...  ...Nurse: Practices in a variety of clinical settings and is responsible for the...  ...emergency and trauma services, ambulatory and outpatient clinics, and diagnostic services. Specialty... 

Anytime Fitness - Folkston, GA

Personal Training Manager Job at Anytime Fitness - Folkston, GA

 ...exceptional service, we strive to create a positive and motivating environment for our members. We are seeking a highly motivated Personal Training Manager (PTM) to join our team. The PTM will be responsible for overseeing the personal training department including sales...