Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and manage data warehouses, ETL processes, and BI solutions for financial services.
- Company: Join a leading Financial Services Client in the heart of London.
- Benefits: Enjoy a competitive salary, bonus, and benefits package.
- Why this job: Be part of a dynamic team shaping data-driven decisions in banking.
- Qualifications: 5+ years of experience in Oracle development, ODI ETL, and BI tools required.
- Other info: Ideal for those with a background in retail banking and accounting.
The predicted salary is between 60000 - 90000 £ 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 (City of London) 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 (City of London)
✨Tip Number 1
Make sure to brush up on your knowledge of Oracle Data Integrator (ODI) and Oracle Analytics Server (OAS). Being able to demonstrate your expertise in these tools during interviews will set you apart from other candidates.
✨Tip Number 2
Familiarise yourself with the latest trends and technologies in data warehousing and BI development. Showing that you're up-to-date with industry advancements can impress potential employers and highlight your commitment to continuous learning.
✨Tip Number 3
Network with professionals in the banking and financial services sector. Attend industry events or join relevant online forums to connect with others in the field, which could lead to valuable referrals or insights about job openings.
✨Tip Number 4
Prepare to discuss specific projects where you've successfully implemented ETL processes or developed BI solutions. Real-world examples will help illustrate your skills and experience, making a strong case for why you're the right fit for the role.
We think you need these skills to ace Senior ODI ETL & OAS BI Banking Data Developer (City of London)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Oracle Development, ODI ETL processes, and BI development. Use specific examples from your past roles that demonstrate your skills in data warehousing and integration.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention your relevant experience in financial services, particularly in banking, and how it aligns with the responsibilities outlined in the job description.
Showcase Technical Skills: Clearly list your technical skills related to SQL, ODI, and Oracle Analytics Server. Provide examples of projects where you successfully implemented these technologies, focusing on outcomes and improvements achieved.
Highlight Problem-Solving Abilities: Include instances where you solved complex data integration challenges or optimised ETL workflows. This will demonstrate your analytical thinking and ability to handle the demands of the role.
How to prepare for a job interview at Cameron Kennedy
✨Showcase Your Technical Skills
Be prepared to discuss your experience with Oracle Data Integrator (ODI) and your proficiency in developing ETL processes. Highlight specific projects where you've successfully implemented data warehouses or BI solutions, as this will demonstrate your hands-on expertise.
✨Understand the Financial Services Landscape
Since the role requires a background in financial services, brush up on key concepts in retail banking and accounting. Be ready to discuss how your domain knowledge can contribute to the company's data management and analytics needs.
✨Prepare for Problem-Solving Questions
Expect questions that assess your ability to troubleshoot and optimise ETL workflows. Think of examples where you faced challenges in data integration or performance issues, and be ready to explain how you resolved them.
✨Demonstrate Collaboration Skills
The role involves working closely with IT and business teams. Prepare to share examples of how you've effectively collaborated with cross-functional teams to understand data requirements and implement solutions that meet business needs.
