Oracle Senior Developer - Data Warehouse in Bengaluru, India

Senior Developer - Data Warehouse

Preferred Qualifications

This position is for the role of a Senior Data Warehouse Developer for the Oracle Health Insurance (OHI) Components suite of Analytics application.

Roles & Responsibilities include

  • Design, develop, test, and support the data warehouse solution.

  • Design and develop mappings, Process Flows and ETL scripts using ODI.

  • Lead and mentor other team members in DW best practices and development processes.

  • Engages with data architects and other ETL developers to assist with designing optimal data structures to support BI, reporting, dashboards and analytical datasets

  • Collaborate with other team members on assignments and provide updates

  • Collaborates as an expert in the planning, design, development, and deployment of BI application, and enhancements to existing application

  • Create and maintain technical documentation required for development.

  • Create and maintain customer documentation shipped as part of the product.

  • Collaborates with source system developers and functional analysts to identify relevant data to be included in the warehouse.

  • Designs and applies data security standards on ETL applications and data

  • Report progress on tasks and projects

  • Work with functional groups and different level of employees to effectively and professionally achieve results

Detailed Description and Job Requirements

As a senior member of the product development division, you will take an active role in the definition and evolution of standard practices and procedures. Managing all aspects of the warehouses such as data sourcing, migration, quality, design, and implementation. Overall responsibility for assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of data warehouse products.

Hands-on, to plan and execute proofs-of-concept, and mentor junior staff, as well as possess a broad enough vision to provide integration solutions across a wide range of technologies. Must be able to multi-task and self-manage multiple high-priority initiatives.

Candidate should be self starter and motivated. Should be able to work with passion and dedication.

Essential skills

  • Minimum 6-8 years of proven experience in design and development of Data Warehouse solutions, ETL, Software Development and system Integration projects.

  • Minimum 3 years of strong experience in Oracle Data Integrator (ODI) with knowledge of data modeling and ETL design, prefereably ODI 12c

  • Must have done the Development of topology setup, Load Plans C5, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs.

  • Must be well versed and hands-on in using and customizing Knowledge of Modules (KM) IKM, LKM, CKM and RKM.

  • Managing Files, Oracle DB, XML's through ODI

  • Sound knowledge of OBIEE reporting including RPD modelling

  • Must have worked on end to end implementation of DW and BI projects.

  • Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure

  • Ability to tune mappings at ETL level and provide suggestion of tuning at database level.

  • Ability to design ETL unit test cases and debug ETL Mappings.

  • Create Load-Plans and schedule the same.

  • Strong knowledge and experience and implementation of Oracle Data warehouse concepts SCD2, Aggregates, Hierarchy tables, Snapshot fact tables etc.

  • Proficient in Data Warehouse concepts of Dimensional modeling, Star Schema

  • Must have product development experience

  • Has strong presentation and collaboration skills and can communicate all aspects of the job requirements, including the creation of formal documentation

  • Proven analytical and problem-solving abilities, with a keen attention to detail

  • Team Player

Preferred Skills

  • Domain knowledge of Health Insurance

  • Knowledge on cloud and web services

  • Experience working with Unix/Linux server environments

  • Previous work experience on Agile/Scrum teams

Detailed Description and Job Requirements

Design, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc.

As a member of the software engineering division, you will assist in defining and developing software for tasks associated with the developing, debugging or designing of software applications or operating systems. Provide technical leadership to other software developers. Specify, design and implement modest changes to existing software architecture to meet changing needs.

Duties and tasks are varied and complex needing independent judgment. Fully competent in own area of expertise. May have project lead role and or supervise lower level personnel. BS or MS degree or equivalent experience relevant to functional area. 4 years of software engineering or related experience.

Job: Product Development

Location: IN-IN,India-Bengaluru

Job Type: Regular Employee Hire

Organization: OFSS