drjobs Senior Developer - ETL

Senior Developer - ETL

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Bengaluru - India

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Description

Job Description: Senior ODI Developer (OCI PaaS/IaaS Expertise)

Role Overview:

We are seeking a highly skilled Senior ODI Developer with strong hands-on experience in SQL PL/SQL and Oracle Data Integrator (ODI) projects particularly on OCI (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 in banking or insurance projects is a significant advantage.

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.
  • Provide guidance and best practices for ODI and OCI-based data integration projects.

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.

Education and Experience:

  • Bachelors degree in computer science Information Technology or a related field.
  • 4 to 6 years of experience in ODI development with at least 2 years of experience in OCI-based projects.
  • Domain experience in banking or insurance is an added advantage.

Career Level - IC2



Responsibilities

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.
  • Provide guidance and best practices for ODI and OCI-based data integration projects.


Qualifications

Career Level - IC2




Required Experience:

Senior IC

Employment Type

Full-Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.