Search by job, company or skills

O

ODI Developer

2-7 Years
new job description bg glownew job description bg glownew job description bg svg
  • Posted a month ago
  • Be among the first 50 applicants
Early Applicant
Quick Apply

Job Description

We are seeking a highly skilledSenior ODI Developerwith strong hands-on experience inSQL,PL/SQL, andOracle Data Integrator (ODI)projects, particularly onOCI (Oracle Cloud Infrastructure)PaaS or IaaS platforms. The ideal candidate will design, implement, and optimize ETL processes, leveraging cloud-based solutions to meet evolving business needs. Prior experience inbankingorinsuranceprojects is a significant advantage.

Skills and Qualifications:

Mandatory Skills:

  • Strong hands-on experience with Oracle Data Integrator (ODI) development and administration.
  • Proficiency in SQL and PL/SQL for complex data manipulation and query optimization.
  • Experience deploying and managing ODI solutions on OCI PaaS/IaaS environments.
  • Deep understanding of ETL processes, data warehousing concepts, and cloud data integration.

Preferred Experience:

  • Hands-on experience in banking or insurance domain projects, with knowledge of domain-specific data structures.
  • Familiarity with OCI services like Autonomous Database, Object Storage, Compute, and Networking.
  • Experience in integrating on-premise and cloud-based data sources.

Other Skills:

  • Strong problem-solving and debugging skills.
  • Excellent communication and teamwork abilities.
  • Knowledge of Agile methodologies and cloud-based DevOps practices.

Key Responsibilities:

  • Design, develop, and deploy ETL processes using Oracle Data Integrator (ODI) on OCI PaaS/IaaS.
  • Configure and manage ODI instances on OCI, ensuring optimal performance and scalability.
  • Develop and optimize complex SQL and PL/SQL scripts for data extraction, transformation, and loading.
  • Implement data integration solutions, connecting diverse data sources like cloud databases, on-premise systems, APIs, and flat files.
  • Monitor and troubleshoot ODI jobs running on OCI to ensure seamless data flow and resolve any issues promptly.
  • Collaborate with data architects and business analysts to understand integration requirements and deliver robust solutions.
  • Conduct performance tuning of ETL processes, SQL queries, and PL/SQL procedures.
  • Prepare and maintain detailed technical documentation for developed solutions.
  • Adhere to data security and compliance standards, particularly in cloud-based environments.

More Info

About Company

We’re a cloud technology company that provides organizations around the world with computing infrastructure and software to help them innovate, unlock efficiencies and become more effective. We also created the world’s first – and only – autonomous database to help organize and secure our customers’ data. Oracle Cloud Infrastructure offers higher performance, security, and cost savings. It is designed so businesses can move workloads easily from on-premises systems to the cloud, and between cloud and on-premises and other clouds. Oracle Cloud applications provide business leaders with modern applications that help them innovate, attain sustainable growth, and become more resilient. The work we do is not only transforming the world of business--it's helping defend governments, and advance scientific and medical research. From nonprofits to companies of all sizes, millions of people use our tools to streamline supply chains, make HR more human, quickly pivot to a new financial plan, and connect data and people around the world.

Job ID: 130139087

Similar Jobs