Oracle PL/SQL Developer

4-8 years
a month ago 63 Applied
Job Description

Job Title: Senior Oracle PL/SQL developer

Data Analytics domain Notes: POD/Unit /Department: CI/XAD4

Designation: Reporting to:

Work Location: Bangalore

No of Positions: 4

L1 Interview Panel

L2 Interview Panel:

Experience Range (Min to Max): 8 Years

Responsibilities/Duties: (in brief) (List the essential duties and responsibilities of the job.)

Interact with customer to understand business requirement

Create/ track open point list and co-ordinate with customer for clarification

Convert business requirement to concept/ technical specification

Work along with source system experts in finalize the source to report mapping

Work with requirements spec in preparing the data/ dimensional models

Coordinate with central team to replicate tables from source system to data lake

Support Oracle developer in design and development

Creation of activity plan as per the agreed concept with timelines

Design, Develop and Deploy solution

Unit & Integration testing

Hand holding key users in report utilization

Support customers during the stabilization phase

Mandatory and Optional Skills Sr. No. Technical Skills Mandatory /Good to have

Min Years of hands on Exp in this skill 1 Oracle PL/SQL Mandatory 8 2 Data Warehousing Mandatory 4 3 Backend application programs to be developed. Application programs such as stored Procedures, Functions, Packages, cursors, collections and triggers and materialized views using SQL and PL/SQL. Know-how of Power BI reports and APEX. Mandatory 6 4 SQL and ETL processes, ETL and DB performance tuning, table partitioning Mandatory 5 5 Experience working in EDW projects, handling cross domain data models Mandatory 5 6 Data Modelling Preferred 4 7 Experience in understanding business requirement & work with source system experts, Add to advantage 5 Version 2.0 Page 2 of 2 platform owner etc to model the data to get the desired end objective Education and Work Experience Requirements: OtherRequirements: (Shifts, WFH/WFO/Client Office, etc.) For Use by Talent Acquisition: Assigned to: Date Assigne

JOB TYPE

Industry

Other

Function

People Also Considered

Career Advice to Find Better