Oracle FAW/BI Integration Architect Permanent - Hybrid - London -SC clearance required (5 year UK residency to be eligible). 2 days London-based office, 3 days remote/work form home.

Responsible for integrations architecture, design and solution delivery.

Leading the integrations technical architecture and solution design for Oracle Analytics solution (FAW & OAC).

Define standards and write solution design documentation.

You are experienced in agile, leading, coaching and managing a team of developers and technical delivery.

Overseeing the integrations delivery and ensuring relevant standards, processes and approach are used.

Rich experience gathering integrations requirements, documenting requirements and solution design.

Mandatory skills:

5+ years of experience with integrations, data warehousing, data mappings.

Design, develop, deploy ETL processes using Oracle Data Integrator to extract, transform, and load data from various source systems into target databases or data warehouses.

Collaborate with business analysts and stakeholders to gather and understand data integration requirements, ensuring that solutions meet business needs.

Create and maintain data integration workflows, mappings, and data transformation logic within Oracle Data Integrator Studio.

Optimize and tune ETL processes for performance, scalability, and reliability, including SQL query optimization and caching strategies.

Implement error handling, logging, and monitoring mechanisms to ensure data quality and integrity during the ETL process.

Manage metadata and maintain metadata repositories to ensure data lineage and consistency.
Work closely with database administrators to integrate ODI processes with Oracle databases and ensure proper data security measures are in place.

Collaborate with cross-functional teams, including data analysts, data scientists, and database administrators, to support data-related initiatives.

Perform routine maintenance tasks, monitor ETL jobs, and troubleshoot issues in production environments.

Keep up to date with Oracle Data Integrator updates and enhancements, and recommend upgrades and improvements to existing ETL solutions.

Create comprehensive documentation for ETL processes, including data flow diagrams, data dictionaries, and process descriptions.

Client facing conversations, workshops and presentations, stakeholder management, business analysis and building strong relationships.

Experience in writing SQL queries, stored procedures in Oracle SQL and Oracle PL/SQL.

Desired skills:
Experience with Oracle BI Apps solutions, FAW, OAC, OBIEE.
ETL integrations in context of analytics solutions.
Experience of core HR and Finance Oracle Fusion modules.