Assistant Manager

We are seeking an exceptional SME Oracle Fusion Middleware + ODI (Oracle Data Integrator) ROLES AND RESPONSIBILITIES ODI Architecture & Design Leadership: • Architect and design enterprise-scale Oracle Data Integrator solutions for Europe's largest ODI implementation • Define ODI architecture patterns, standards, and best practices for large-scale data integration platforms • Design high-performance ODI architectures supporting high-volume, complex data integration scenarios • Create ODI topology designs including master repositories, work repositories, agents, and execution environments • Architect scalable ODI agent configurations: standalone agents, Java EE agents, and high-availability agent clusters • Design ODI security architectures including user management, role-based access control, and data encryption • Establish ODI development standards, naming conventions, and coding guidelines for global teams • Evaluate and recommend ODI deployment options: on-premises, cloud (OCI, AWS, Azure), and hybrid architectures Large-Scale ODI Infrastructure Implementation (10+ Years): • Lead the implementation of large-scale ODI infrastructure platforms supporting enterprise-wide data integration • Design and deploy ODI master repositories and work repositories for multi-environment configurations • Implement ODI agent topologies: standalone agents, clustered agents, and load-balanced execution environments • Configure ODI for high availability, disaster recovery, and business continuity requirements • Optimize ODI infrastructure for performance, scalability, and resource utilization • Implement ODI lifecycle management: development, testing, staging, and production environments • Design ODI backup and recovery strategies for critical data integration processes • Plan and execute ODI upgrades, migrations, and platform consolidations with minimal downtime Oracle Fusion Middleware Expertise • Architect and implement Oracle Fusion Middleware solutions including WebLogic Server, SOA Suite, and Service Bus • Design Oracle WebLogic Server domains and clusters for ODI Java EE agent deployment • Implement Oracle Service Bus (OSB) for service-oriented integration with ODI • Configure Oracle SOA Suite for orchestrating complex data integration workflows • Design Oracle Fusion Middleware security: SSL/TLS, authentication, and authorization • Implement Oracle Fusion Middleware high availability and clustering configurations • Optimize Oracle Fusion Middleware performance and resource management • Integrate ODI with Oracle Fusion Middleware components for enterprise integration Data Integration & ETL/ELT Architecture • Design end-to-end data integration solutions using ODI for ETL and ELT patterns • Architect data warehouse and data mart loading strategies using ODI • Design real-time and near-real-time data integration architectures using ODI CDC (Change Data Capture) • Implement ODI Knowledge Modules (KMs) for optimized data loading and transformation • Design ODI mappings, packages, scenarios, and load plans for complex data integration • Architect data quality and data validation frameworks within ODI processes • Implement ODI for cloud data integration: Oracle Cloud Infrastructure, AWS, Azure, Snowflake • Design ODI integration with big data platforms: Hadoop, Spark, Databricks Performance Optimization & Tuning: • Optimize ODI performance: execution plans, parallelism, batch sizing, and resource allocation • Tune ODI Knowledge Modules for specific database platforms and integration scenarios • Optimize ODI agent performance: JVM tuning, connection pooling, and thread management • Design and implement ODI load balancing and workload distribution strategies • Monitor ODI performance metrics and conduct capacity planning for future growth • Optimize database interactions: SQL tuning, index strategies, and partition schemes • Implement ODI caching strategies and temporary storage optimization • Conduct performance benchmarking and stress testing for ODI implementations Security & Governance: • Implement comprehensive ODI security models: authentication, authorization, and encryption • Design ODI user management and role-based access control (RBAC) strategies • Configure ODI for secure data integration: SSL/TLS, data masking, and encryption at rest • Implement ODI audit logging and compliance reporting for regulatory requirements • Ensure compliance with GDPR, PCI-DSS, HIPAA, SOX for data integration processes • Design data lineage and metadata management solutions using ODI • Implement ODI data governance frameworks and data quality standards • Manage ODI certificates, credentials, and secure connectivity to source and target systems Technical Advocacy & Thought Leadership: • Serve as the technical advocate for Europe's largest ODI implementation, representing the organization in industry forums • Provide strategic direction and architectural guidance for ODI and Oracle Fusion Middleware initiatives • Drive innovation and best practices in data integration and Oracle technologies • Represent the organization in Oracle user groups, conferences, and industry events • Publish technical whitepapers, case studies, and thought leadership content on ODI implementations • Engage with Oracle product management and engineering teams to influence product roadmap • Evaluate emerging Oracle technologies and recommend adoption strategies • Build external partnerships and collaborate with Oracle consulting and support teams Mentoring & Knowledge Transfer: • Mentor and coach global engineering teams on ODI architecture, development, and best practices • Develop and deliver ODI training programs, workshops, and certification preparation • Create comprehensive ODI documentation: architecture guides, runbooks, and best practice manuals • Establish ODI Centers of Excellence and communities of practice • Conduct architecture reviews and code reviews for ODI implementations • Provide technical guidance and consultation to project teams on complex ODI challenges • Build reusable ODI components, templates, and accelerators for common integration patterns • Foster knowledge sharing and collaboration across global ODI teams Operations & Support: • Provide L3 support for critical ODI production issues and escalations • Monitor ODI infrastructure health, performance, and availability • Implement proactive monitoring and alerting for ODI jobs, agents, and repositories • Conduct root cause analysis for ODI incidents and implement preventive measures • Manage ODI change requests, enhancements, and platform configurations • Plan and execute ODI maintenance windows, patches, and platform refreshes • Maintain ODI inventory: interfaces, mappings, schedules, and documentation • Generate operational reports: job execution metrics, SLA compliance, and performance trends Integration Architecture: • Design integration patterns between ODI and enterprise applications: SAP, Oracle EBS, Salesforce, Workday • Implement ODI integration with cloud platforms: Oracle Cloud, AWS, Azure, Google Cloud • Design API integration patterns using ODI and Oracle Integration Cloud (OIC) • Architect real-time integration using ODI CDC and Oracle GoldenGate • Implement ODI integration with message queues: Oracle AQ, IBM MQ, Kafka • Design data lake and data warehouse integration using ODI • Implement ODI for master data management (MDM) and data governance initiatives • Architect hybrid cloud and multi-cloud data integration strategies PRIMARY SKILLS (REQUIRED) Oracle Data Integrator (ODI) - Large Scale (10+ Years): • Expert-level experience architecting and implementing large-scale ODI infrastructure platforms including: - • ODI architecture design for enterprise-scale implementations - ODI topology design: master repositories, work repositories, agents, and execution environments - ODI agent configurations: standalone agents, Java EE agents, and high-availability clusters - ODI Knowledge Modules (KMs): selection, customization, and optimization - ODI mappings, packages, scenarios, and load plans for complex data integration - ODI CDC (Change Data Capture) for real-time data integration - ODI security: user management, roles, privileges, and encryption - ODI performance tuning: parallelism, batch sizing, and resource optimization - ODI lifecycle management: development, testing, staging, and production - ODI backup, recovery, and disaster recovery strategies - ODI version upgrades and migration strategies - ODI integration with cloud platforms: OCI, AWS, Azure - ODI integration with big data: Hadoop, Spark, Databricks Oracle Fusion Middleware (5+ Years): • Deep expertise in Oracle Fusion Middleware technologies: - Oracle WebLogic Server: domain configuration, clustering, and high availability - Oracle SOA Suite: BPEL, BPM, and service orchestration - Oracle Service Bus (OSB): service design, proxy services, and business services - Oracle Fusion Middleware security: SSL/TLS, authentication, and authorization - Oracle Fusion Middleware performance tuning and resource management - Oracle Fusion Middleware integration with ODI Java EE agents - Oracle Web Services Manager (OWSM) for security policy management - Oracle Enterprise Manager for Fusion Middleware monitoring Database & Data Integration: • Extensive database and data integration expertise: - Oracle Database: architecture, performance tuning, and PL/SQL development - SQL and PL/SQL for complex data transformations and stored procedures - Data warehouse design: dimensional modeling, star/snowflake schemas, ETL/ELT - Data integration patterns: ETL, ELT, CDC, real-time, batch processing - Database performance tuning: indexing, partitioning, query optimization - Data quality frameworks and data validation techniques - Data modeling and metadata management Cloud & Hybrid Integration: • Cloud platform expertise: - Oracle Cloud Infrastructure (OCI): compute, storage, networking, and database services - Oracle Integration Cloud (OIC) and Oracle Data Integration Platform Cloud - AWS data integration services: AWS Glue, Amazon RDS, S3 - Azure data integration: Azure Data Factory, Azure SQL, Blob Storage - Cloud migration strategies for ODI and data integration workloads - Hybrid cloud and multi-cloud data integration architectures Performance & Optimization: • Performance engineering expertise: - ODI performance tuning and optimization techniques - JVM tuning for ODI agents and WebLogic Server - Database performance tuning and SQL optimization - Parallel processing and workload distribution strategies - Caching strategies and temporary storage optimization - Capacity planning and scalability assessments Security & Compliance: • Security and compliance expertise: - ODI security architecture and implementation - Oracle Fusion Middleware security configurations - SSL/TLS, encryption, and certificate management - Data masking and data protection techniques - Regulatory compliance: GDPR, PCI-DSS, HIPAA, SOX - Audit logging and compliance reporting - Identity and access management (IAM) for data integration SECONDARY SKILLS (PREFERRED) Additional Oracle Technologies: • Oracle GoldenGate for real-time data replication • Oracle Data Guard for high availability and disaster recovery • Oracle Exadata and Oracle Autonomous Database • Oracle Analytics Cloud (OAC) and Oracle Business Intelligence • Oracle Enterprise Manager for monitoring and management • Oracle SQL Developer and Oracle Data Modeler Data Integration Platforms: • Informatica PowerCenter and Informatica Cloud • Talend Data Integration and Talend Cloud • Microsoft SSIS (SQL Server Integration Services) • IBM InfoSphere DataStage • SAP Data Services and SAP BODS • Pentaho Data Integration Cloud-Native & DevOps: • Docker and Kubernetes for containerized ODI deployments • CI/CD pipelines for ODI deployment automation • Infrastructure as Code: Terraform, Ansible for ODI infrastructure • Git version control for ODI project management • DevOps practices for data integration teams • Cloud-native data integration patterns Data Governance & Quality: • Data governance frameworks and metadata management • Data lineage and impact analysis • Data quality tools: Informatica DQ, Talend DQ, Oracle EDQ • Master data management (MDM) concepts and tools • Data catalog solutions: Collibra, Alation, Apache Atlas • Data privacy and protection regulations Soft Skills: • Technical leadership and thought leadership • Executive communication and presentation skills • Stakeholder management across business and IT • Mentoring and knowledge transfer capabilities • Problem-solving in complex data integration scenarios • Architecture documentation and diagramming • Project management and delivery coordination • Vendor management and Oracle relationship management CERTIFICATIONS (REQUIRED/PREFERRED) Required: • Oracle Certified Professional: Oracle Data Integrator 12c Implementation Specialist OR • Oracle Certified Expert: Oracle Data Integrator 11g Certified Implementation Specialist Preferred: • Oracle Certified Master (OCM) - Oracle Database • Oracle WebLogic Server 12c Certified Implementation Specialist • Oracle SOA Suite 12c Certified Implementation Specialist • Oracle Cloud Infrastructure (OCI) Architect Associate or Professional • Oracle Cloud Infrastructure Data Integration Certified • Oracle GoldenGate 12c Certified Implementation Specialist • Oracle Database 12c/19c Administrator Certified Professional • TOGAF 9 Certified or similar enterprise architecture certification • Project Management Professional (PMP) or PRINCE2 Practitioner • Certified Data Management Professional (CDMP) QUALIFICATIONS Educational Background • Bachelor's degree in Computer Science, Information Technology, Software Engineering, or related technical field • Master's degree in Computer Science, Data Engineering, Information Systems, or Business Administration is highly preferred Experience Requirements: • Total 10+ years of professional experience in data integration, database administration, or enterprise architecture • Minimum 10 years architecting and implementing large-scale Oracle Data Integrator (ODI) infrastructure platforms • Proven experience as technical lead or architect for major ODI implementations • Demonstrated capability to serve as technical advocate for large-scale ODI initiatives • Experience with Europe's largest or similarly large-scale ODI implementations preferred • Track record of delivering complex, enterprise-wide data integration solutions • Experience with Oracle Fusion Middleware technologies: WebLogic, SOA Suite, Service Bus • Experience in global organizations with distributed teams and multi-region deployments Technical Competencies: • Expert-level understanding of Oracle Data Integrator architecture and internals • Deep knowledge of Oracle Fusion Middleware stack and integration patterns • Strong expertise in database technologies, SQL, and PL/SQL • Understanding of data warehouse design, ETL/ELT patterns, and data integration best practices • Knowledge of cloud platforms and cloud-native data integration architectures • Familiarity with big data technologies and modern data platforms • Understanding of data governance, data quality, and master data management • Knowledge of IT security principles and compliance frameworks • We are seeking an exceptional SME Oracle Fusion Middleware + ODI (Oracle Data Integrator) with 10+ years of expertise in architecting and implementing large-scale ODI infrastructure platforms. • This senior role requires a distinguished technical leader who will serve as the technical advocate for Europe's largest ODI implementation, providing strategic direction, architectural guidance, and thought leadership for mission-critical data integration initiatives. • The ideal candidate will possess unparalleled expertise in Oracle Data Integrator, Oracle Fusion Middleware technologies, and enterprise data integration patterns. • As the subject matter expert, you will be responsible for designing high-performance, scalable, and resilient ODI architectures, mentoring global engineering teams, establishing integration standards, and ensuring the operational excellence of one of the most significant ODI implementations in the industry. • This role demands a visionary architect who can bridge complex business requirements with cutting-edge Oracle technologies while driving innovation and best practices across the organization. ================================================================================ ROLES AND RESPONSIBILITIES ================================================================================ ODI Architecture & Design Leadership: • Architect and design enterprise-scale Oracle Data Integrator solutions for Europe's largest ODI implementation • Define ODI architecture patterns, standards, and best practices for large-scale data integration platforms • Design high-performance ODI architectures supporting high-volume, complex data integration scenarios • Create ODI topology designs including master repositories, work repositories, agents, and execution environments • Architect scalable ODI agent configurations: standalone agents, Java EE agents, and high-availability agent clusters • Design ODI security architectures including user management, role-based access control, and data encryption • Establish ODI development standards, naming conventions, and coding guidelines for global teams • Evaluate and recommend ODI deployment options: on-premises, cloud (OCI, AWS, Azure), and hybrid architectures