Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and manage data warehouses, ETL processes, and BI solutions for banking data.
- Company: Join a leading financial services client based in London, focused on innovation.
- Benefits: Enjoy a competitive salary of £75k plus bonuses and benefits.
- Why this job: Be part of a dynamic team that drives data-driven decision-making in banking.
- Qualifications: 5+ years of experience in Oracle development, with expertise in ODI ETL and BI.
- Other info: Ideal for those with a background in financial services, especially banking.
The predicted salary is between 54000 - 84000 £ per year.
Our London based Financial Services Client is looking to recruit an experienced (5 years plus) Oracle Developer in developing data warehouses, BI development (OAS BI), ETL development, and data integration. ODI ETL is essential for this role along with the Oracle analytics exposure, and ideally you will have some financial services background, preferably Banking.
Main Responsibilities:
- Data Warehouse Management: Design, implement and manage data warehouse schemas and data marts to store and organize volumes of data. Implement data models and schemas to support efficient data retrieval and analysis. Perform regular maintenance and updates to ensure the data warehouse, marts and services operate smoothly.
- Data Management: Manage and optimize data to ensure efficient data storage and retrieval. Write complex SQL queries to manipulate and analyse data.
- Data Integration: Integrate data from multiple sources, ensuring seamless data flow and consistency. Collaborate with IT and business teams to understand data requirements and implement integration solutions.
- ETL Development and Maintenance: Design, develop, and maintain ETL processes using Oracle Data Integrator (ODI). Ensure data quality, consistency, and integrity throughout the ETL pipeline. Optimize ETL workflows for performance and scalability.
- Business Intelligence Development: Develop and maintain BI solutions using Oracle Analytics Server. Create interactive dashboards, reports, and visualizations to support business decision-making. Perform data analysis to derive actionable insights and present findings to stakeholders.
- Retail Banking & Accounting Knowledge: Apply domain knowledge of retail banking and accounting to understand data requirements and provide relevant insights. Ensure compliance with industry regulations and standards.
Senior ODI ETL & OAS BI Banking Data Developer employer: Cameron Kennedy
Contact Detail:
Cameron Kennedy Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior ODI ETL & OAS BI Banking Data Developer
✨Tip Number 1
Familiarise yourself with Oracle Data Integrator (ODI) and Oracle Analytics Server (OAS). Having hands-on experience or even completing relevant online courses can give you a significant edge during interviews.
✨Tip Number 2
Network with professionals in the banking and financial services sector. Attend industry meetups or webinars to connect with potential colleagues and learn about the latest trends in data management and BI development.
✨Tip Number 3
Prepare to discuss your previous projects involving data warehousing and ETL processes. Be ready to explain your role, the challenges you faced, and how you overcame them, as this will demonstrate your practical experience.
✨Tip Number 4
Stay updated on the latest regulations and standards in the banking industry. Understanding compliance issues can set you apart from other candidates and show that you are proactive about industry knowledge.
We think you need these skills to ace Senior ODI ETL & OAS BI Banking Data Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Oracle Data Integrator (ODI), ETL development, and BI solutions. Include specific projects or achievements that demonstrate your expertise in data warehousing and financial services.
Craft a Compelling Cover Letter: Write a cover letter that connects your background in banking data development to the job requirements. Emphasise your understanding of retail banking and accounting, and how your skills can benefit the company.
Showcase Technical Skills: In your application, clearly outline your technical skills related to SQL, data integration, and Oracle Analytics Server. Use examples to illustrate how you've successfully implemented these skills in previous roles.
Highlight Collaboration Experience: Mention any experience you have working with IT and business teams to gather data requirements. This role requires collaboration, so demonstrating your ability to work well with others will strengthen your application.
How to prepare for a job interview at Cameron Kennedy
✨Showcase Your ODI ETL Expertise
Make sure to highlight your experience with Oracle Data Integrator (ODI) during the interview. Be prepared to discuss specific projects where you designed and maintained ETL processes, as this is a crucial requirement for the role.
✨Demonstrate Your BI Development Skills
Since the position involves developing BI solutions using Oracle Analytics Server, be ready to share examples of dashboards or reports you've created. Discuss how these tools helped in decision-making processes within your previous roles.
✨Understand the Financial Services Landscape
Having a background in banking or financial services is beneficial. Brush up on industry-specific knowledge and be prepared to discuss how your understanding of retail banking and accounting can contribute to the role.
✨Prepare for Technical Questions
Expect technical questions related to SQL queries, data warehousing, and data integration. Practise writing complex SQL queries and be ready to explain your thought process when solving data-related problems.
