Oracle Developer Gosport, England
Job description
Do you have ODI and OAS experience? If so, then this could be the role for you!
We are SSCL, the largest provider of business-critical support services for our Government, Police and Defence customers. We play a vital role in transforming business support services, delivering digital solutions and developing innovations that make things easier for our customers!
Our Defence business within SSCL is seeking an Oracle Developer with experience of ODI & OAS to join the MI & Reporting team. Being part of a team of 6 ODI Developers you will be responsible for the maintenance and management of PL, SQL & ODI scripts / systems. In addition to this, you will be involved with the throughput multiple source system to manage and create a centralised Data Lake for the OAS reporting function covering Customer Relationship Management (CRM), HR, Payroll and training information.
You could be based anywhere in the UK, however there will be the need to travel to our customer site in Gosport Hampshire once a month.
What you will be doing:
- Design, develop and unit test improvements to the ETL.
- Create and submit RCB documentation – gaining all vital permissions and ensuring relevant Dimensions work has been complete for specific release.
- Check overnight ETL, and investigate and fix any failures.
- Monitor availability of all OAS services (presentation and BI servers) and work with DBAs to resolve any issues.
- Supervise Serena Incident inbox, investigate any problems that arise, resolve and advise users where appropriate. Build a plan to fix problem where there is a real issue.
- Create and test fixes to problems. This may involve corrections / upgrades in ODI, Database, BI Repository and Webcat and document as appropriate.
What you’ll bring:
- Experience of PL/SQL.
- Experience of ODI version 12.2.1.3 or above.
- OAS (Oracle Analytics Server) R5.9 (and previous product incarnations) including development of the BI Repository and Webcat.
It would be great if you had:
- Experience using APEX
- Business knowledge of the UK MoD personnel and pay systems and processes.
- Experience in close teamwork and cross-team working with clients both during on-site collocations, and as part of a remote team.
If you are interested in this role but not sure if your skills and experience are exactly what we’re looking for, please do apply, we’d love to hear from you!
Although this role is advertised as full-time, we support different ways of working and can offer a range of flexible working arrangements. So, if you’re interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible.
Employment Type: Full-time Permanent
Location: UK Anywhere
Security Clearance Level: SC - You must be eligible and willing to undergo the SC Clearance process.
Internal Recruiter: Carolyne
Salary: £56,000 + 3% Flex Fund
Benefits: £5,400 car allowance, 25 days annual leave with the option to buy additional days, private medical, life assurance, pension.
Loved reading about this job and want to know more about SSCL?
Shared Services Connected Ltd was established as a joint venture between the Cabinet Office and Sopra Steria, in 2013 as part of the Government’s Shared Services Strategy for Smarter Government programme and operates from four regional centres of excellence: Blackpool; Newcastle; Newport; and York. We deliver outstanding business transformation programmes to across the Public Sector with a target to release one billion pounds of savings to the public.
We have established an enviable track record in the design and delivery of large-scale innovative HR, Payroll, IT, and Finance & Accounting solutions to significantly improve efficiencies and enhance service levels across Government and Public Sector.
Our clients include several government agencies including the Department for Work and Pensions, Environment Agency Department for Education, Ministry of Justice and Home Office as well as the Metropolitan Police Service and the Construction Industry Training Board.
