Oracle Senior Developer - Data Warehouse in Bengaluru, India
Senior Developer - Data Warehouse
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.
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
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
Job Type: Regular Employee Hire