Software Developer 3

At Oracle Health, we put humans at the heart of every conversation. Our mission is to create a human-centric healthcare experience powered by unified global data.As a global leader we're looking for a Data Engineer with BI to join an exciting project for replacing existing Data warehouse systems with the Oracle's own data warehouse to manage storage of all the internal corporate data to provide insights that will help our teams to make critical business decisions Join us and create the future!

Career Level - IC3

Roles and Responsibilities

. Proficient in writing and optimising SQL queries for data extraction

. Translate client requirements to technical design that junior team members can implement

. Developing the code that aligns with the technical design and coding standards

. Review design and code implemented by other team members. Recommend better design and efficient code

. Conduct Peer design and Code Reviews for early detection of defects and code quality

. Documenting ETL processes and data flow diagrams

. Optimizing data extraction and transformation processes for better performance

. Performing data quality checks and debugging issues

. Conducting root cause analysis for data issues and implementing fixes

. Collaborating with more experienced developers on larger projects, collaborate with stakeholders on the requirements

. Participate in the requirements, design and implementation discussions

. Participating in learning and development opportunities to enhance technical skills

. Test storage system after transferring the data

. Exposures to Business Intelligence platforms like OAC, Power BI or Tableau

Technical Skills Set :

. You must be strong in PLSQL concepts such as tables, keys, DDL, DML commands, etc.

. You need be proficient in writing, debugging complex SQL queries, Views and Stored Procedures.

. Strong hands on in Python / PySpark programming

. As a Data Engineer, you must be strong in data modelling, ETL / ELT concepts, programming / scripting Python language,

. You must be proficient in the following ETL process automation tools

??????. Oracle Data Integrator (ODI)

??????. Oracle Data Flow

??????. Oracle Database / Autonomous Data warehouse

. Should possess working knowledge in any of the cloud platform like Oracle Cloud (Preferred), Microsoft Azure, AWS

. You must be able to create technical design, build prototypes, build and maintain high performing data pipelines, optimise ETL pipelines

. Good knowledge on Business Intelligence development tools like OAC, PowerBI

. Good to have Microsoft ADF and Data Lakes, Databricks

Career Level - IC3