This job is with Oracle, an inclusive employer and a member of myGwork the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.
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 Principal Engineer 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 - IC4
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
Skills
- 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 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
- Play a role of technical leader / mentor
As a world leader in cloud solutions, Oracle uses tomorrow's technology to tackle today's problems. True innovation starts with diverse perspectives and various abilities and backgrounds.
When everyone's voice is heard, we're inspired to go beyond what's been done before. It's why we're committed to expanding our inclusive workforce that promotes diverse insights and perspectives.
We've partnered with industry-leaders in almost every sectorand continue to thrive after 40+ years of change by operating with integrity.
Oracle careers open the door to global opportunities where work-life balance flourishes. We offer a highly competitive suite of employee benefits designed on the principles of parity and consistency. We put our people first with flexible medical, life insurance and retirement options. We also encourage employees to give back to their communities through our volunteer programs.
We're committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by calling +1 888 404 2494, option one.
Disclaimer
Oracle is an Equal Employment Opportunity Employer*. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.
- Which includes being a United States Affirmative Action Employer
