Oracle _ Data Integrator (ODI

Cloudxtreme; Hyderabad, Pune District, Chennai District; On-site; INR 900,000 - 1,400,000; Full time

Job summary

Cloudxtreme is seeking a skilled Oracle BI/ETL Developer in Hyderabad to design and implement BI applications. You will work on Oracle objects, PL/SQL packages, and SQL tuning, while collaborating with customers to translate requirements into ETL specifications and high/low level design documents.

Applicants should have experience with Oracle BI Apps, scripting languages, and version control. Strong English communication and problem-solving abilities are essential.

Qualifications

• Experience with Oracle BI Apps and SQL/PLSQL development.
• Exposure to Python, R or UNIX shell scripting.
• Ability to design Oracle objects (Tables, Views, Indexes, Partitions, Procedures).
• Experience tuning SQL and analyzing explain plans.
• Strong communication and stakeholder interaction skills.

Responsibilities

• Develop and maintain Oracle BI Apps components and ETL specs.
• Create PL/SQL packages, procedures, functions, and triggers.
• Tune SQL and optimize performance using explain plan and traces.
• Design Oracle objects like tables, views, indexes and partitions.
• Collaborate with customers to translate requirements into design docs.

Skills

Oracle BI Apps

Python

R

UNIX shell scripting

SQL

PL/SQL

Git

ETL specifications

SQL tuning

Partitioning

English communication

Customer interaction

debugging/automation

scripting (Python/UNIX)

Education

Bachelor's degree or equivalent in a relevant field

Tools

Git

Job description

Role & responsibilities

• Experience in Oracle BI Apps
• Exposure to one or more of the following: Python, R or UNIX shell scripting.
• Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
• Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions
• Working knowledge of GIT or similar source code control system
• Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
• Experience in SQL tuning and optimization using explain plan and SQL trace files
• Partitioning and Indexing strategy for optimal performance
• Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
• Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents
• Systematic problem-solving approach, coupled with strong communication skills
• Ability to debug and optimize code and automate routine tasks.
• Experience writing scripts in one or more languages such as Python, UNIX Scripting and/or similar.
• Experience working with technical customers