Oracle Data Integration

We are seeking a highly skilled GCP Cloud Solution Architect with strong expertise in Oracle systems, Oracle Data Integration (ODI), BigQuery, and Google Vertex AI Search. This individual will be responsible for owning the end-to-end solution architecture, driving data integration flows, and providing both technical leadership and hands-on delivery. The role requires a strong balance of architectural vision, data engineering expertise, and the ability to work independently while engaging directly with business and technical stakeholders. This position plays a critical role in replacing the client's existing Algolia-based e-commerce search with Google Vertex AI Search, ensuring seamless integration with the client's Oracle-based product catalog. Key Responsibilities Solution Ownership & Architecture Define and own the end-to-end architecture for integrating Oracle product data with Google Vertex AI Search. Design, document, and govern data pipelines for ingestion, transformation, and indexing of product data. Establish best practices for scalability, availability, and performance of the search solution. Data Flow Development & Governance Build and manage ETL/ELT processes using Oracle Data Integrator (ODI), Data Fusion, and other GCP-native services. Ensure proper schema mappings between Oracle product catalog structures and Vertex AI Search index schema. Implement error handling, monitoring, and automated reconciliation of data flows. Hands-on Delivery & Technical Leadership Work as an individual contributor while also acting as a technical leader, mentoring junior team members and guiding cross-functional stakeholders. Collaborate closely with client teams to resolve issues in Oracle data sources, transformation logic, and schema mismatches. Provide expertise on Oracle database structures, JSON schema transformation, and search indexing strategies. Client Engagement & Ownership Act as the primary technical point of contact for the client on this engagement. Demonstrate strong self-ownership, accountability, and proactive issue resolution across the solution lifecycle. Support client in issue triaging related to Oracle source systems and Vertex AI Search integration. Search Experience Optimization Establish schema mapping rules to ensure product data from Oracle is properly optimized for semantic search, filtering, and recommendations in Vertex AI Search. Tune search relevance, ranking signals, and indexing strategy for e-commerce use cases. Support A/B testing, performance tuning, and incremental rollout of Vertex AI Search features. Required Skills & Experience Mandatory Expertise: Strong experience with Oracle Database and Oracle Data Integrator (ODI). Proven expertise in Google Cloud Platform (GCP) services including BigQuery, Data Fusion, Pub/Sub, and Vertex AI Search. Strong understanding of JSON schema design and transformations for search optimization. Hands-on experience designing and implementing large-scale data ingestion and search indexing pipelines. Solutioning & Leadership: Experience in solution architecture, system integration, and cloud-native design patterns. Ability to lead technically while still contributing as an individual contributor. Demonstrated ability to engage with client stakeholders and resolve complex technical challenges. Soft Skills: Strong ownership mindset with the ability to work independently and drive results. Excellent communication skills for presenting technical solutions to business stakeholders. Problem-solving attitude with the ability to manage ambiguity and client escalations. Nice-to-Have Skills Knowledge of search migration projects (Algolia to Vertex AI or equivalent). Familiarity with e-commerce product data structures and search relevance tuning. Experience with recommendation systems, semantic search, or AI-driven search engines. Role Type & Engagement Position: GCP Cloud Solution Architect – Vertex AI Search & Data Integration Experience: 12 years overall IT experience, with minimum 5 years in GCP and strong background in Oracle & data engineering. Engagement: Full-time, client-facing, ownership-driven role.

---