Oracle data integration (ODI) Developer

Los Angeles, CA, US • Posted 8 hours ago • Updated 8 hours ago
Contract Independent
Contract Corp To Corp
Contract W2
12 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

  • Oracle data integration
  • ODI
  • Oracle PL/SQL
  • Oracle SQL
  • Data Extraction
  • Cloud Computing
  • Data Integration
  • Extract, Transform, Load
  • PL/SQL
  • Oracle Data Integrator
  • Stored Procedures
  • Data lake migration
  • Data Build Tool
  • DBT
  • Continuous Delivery
  • Continuous Integration
  • Amazon Web Services
  • Migration

Summary

QUALIFICATIONS AND DUTIES
1. Design, automate and support sophisticated data extraction, transformation, and
loading applications.
2. Strong knowledge of Oracle database for batch application development within data
warehouse / data lake environment.
3. Perform data ingestion from heterogeneous data sources to on-premises or cloud data
storage, (including and not limited to snowflake, AWS, etc.)
4. Experience managing ETL using DBT, ODI, Oracle PL/SQL, Oracle SQL and ShellScript.
5. Experience and knowledge in developing dimensional hierarchies, design data model to
support multiple Enterprise Data Management reports. Work with all stakeholders
including business customers, vendors, and internal resources to facilitate team
communication and achieve the mission.
6. Creates and improves data solutions that enable smooth data delivery and is in charge
of gathering, processing, maintaining, and analyzing enormous amounts of data.
7. Experience in data quality validation.
8. Knowledge/Experience in API development frameworks.
9. Knowledge/Expierience in Cloud native data integration technologies
10. Data lake migration experience from on prem systems to cloud platform
11. Previous Experience working on client Data Lake systems
12. Min 3 years’ experience in building incremental models/handling raw data layers and
building DBT models for client Vendors/Application
13. Proficiency in dbt (Data Build Tool) development, including macros, hooks, and
incremental models. Experience converting complex Oracle stored procedures into
modular dbt models.
14. Ability to write DBT tests for data quality and manage security on DBT models.
15. Expert-level knowledge of Git workflows, implementing branching strategies, and
establishing CI/CD pipelines for automated deployment

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91132487
  • Position Id: 8975493
  • Posted 8 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Los Angeles, California

Yesterday

Easy Apply

Contract, Third Party

$70 - $85

Los Angeles, California

5d ago

Easy Apply

Full-time, Third Party

$150000 - $160000

Downey, California

6d ago

Easy Apply

Contract

$60 - $80

Los Angeles, California

Today

Easy Apply

Contract

$82.92 - $92.92 per hour

Search all similar jobs