Oracle _ Data Integrator (ODI

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