Apex oracle data Engineer/Developer

We are seeking an experienced ApexOracle and PL/SQL Data Engineer to join our team. In this key technical role, you will primarily focus on Oracle PL/SQL development and data integration tasks while also contributing to Azure platform dataflows and datamarts. Your responsibilities will include investigating and resolving user problems, troubleshooting dataflow and datamart issues, and championing change within our BI and Data Solutions team.

Summary

• Design and Implement Oracle extracts from an Oracle database.
  • Design and Implement Dataflows and DataMart's on an Azure platform.
  • Ability to Configure Databricks Clusters & maintain Databricks Notebooks in SQL, Python & R
  • Troubleshooting issues on both an Oracle and Azure platform
  • Liaise with global data teams, to monitor progress and highlight any issues for action.
  • Specify components of solutions to support the delivery of user requirements right first time.
  • Champion change on behalf of the BI & Data Solutions team and for the IT Solutions team in general
  • Automation of Tasks on Azure platform and Attunity Replicate Server
  • Maintaining Powershell Automation scripts on Attunity Replicate Server
  • Designing, Creating and Maintaining Data Integration Tasks on an Attunity Replicate Server
  • Specify components of solutions to support the delivery of user requirements right first time.
  • Ensure the Applications are designed to be effectively managed.
  • Plan and manage systems tests to ensure that solutions work correctly and meet the specification.
  • Identify and drive improvements to the current processes and new development work.
  • Responsible for creating and maintaining documentation - Document changes to systems and produce documentation for new solutions.
  • Maintain functional peer relationships and participate in continuous process improvement activities and support quality initiatives.
  • Ability to work on own initiative - and work on issues till resolution.

Required Skills

Oracle PL/SQL - with at least 4 years of experience

• Oracle database knowledge
• Strong Data Integration, ETL and Data Modelling - at least 2 years of experience
• Experience with Azure DevOps CI/CD implementation and use
• Knowledge of Azure Data Lake processing
• Azure Analysis Services
• Azure DevOps CI/CD implementation
• A proven track record of developing Big Data solutions
• PowerBI Development and Architecture
• Experience of working in Insurance or the Financial industry
• At least 5 years of experience in solution design including the analysis of business requirements and implementation of change
• Proven ability to work in an Agile development environment
• Communication - Ability to liaise with various functions and interact and communicate with individuals at all levels

Note: This role primarily focuses on Oracle PL/SQL and data engineering tasks while also involving responsibilities related to the Apex Reports and data integration. Your expertise in Oracle PL/SQL will be a critical asset to our team, and you will have the opportunity to contribute to various aspects of our data solutions.

Our Recruitment Delivery Team are committed to offering an inclusive recruitment experience to all candidates. If you require any accommodations or adjustments as a result of disability, impairment, or health condition, please do not hesitate to let me know by emailing gscemeaedi @ resourcesolutions .com