Principal Application Specialist (Cognos/DataMart Developer)
University of Cambridge
- Cambridge
- £45,585-57,696 per year
- Permanent
- Part-time
- Design, develop and unit test improvements to the Extract, Transform and Load (ETL) processes.
- Check overnight ETL, investigate and fix any failures.
- Monitor performance and other operational aspects of the ETL and work with DBAs to resolve any issues or suggest enhancements.
- Collaborate with the relevant systems helpdesks, investigate any incidents that are reported, resolve and advise users where appropriate.
- Work as part of a multi-disciplinary team to review requirements, develop specifications and design effective solutions.
- Producing new DataMarts
- Testing (including regression, integration, performance)
- Supporting existing DataMarts (enhancing, monitoring, tuning, debugging)
- Support for IBM Cognos Analytics report writers.
- Introducing new IBM Cognos Analytics features
- Supporting software upgrades
- Experience of ODI version 12.2.1.3 or above.
- In-depth knowledge of Oracle PL/SQL. In particular, the ability to analyse and quickly correct DataMart build issues.
- A good understanding of DataMart design.
- Able to create and maintain IBM Cognos Framework Manager models/packages.
- Knowledge of the Oracle EBS Financials 12.2
- Experience using APEX
- Ability to learn new skills independently and proactively and are constantly striving to raise technical excellence.
- Debug complex problems effectively, including in new unexplored applications.
- Drive and commitment to see activities through to completion meeting deadlines matching pace to the urgency of the situation.
- Ensure that business requirements and processes are fully understood and clearly documented.