RTI International is one of the world's leading research institutes, dedicated to improving the human condition by turning knowledge into practice. Our staff of nearly 6,000 provides research and technical services to governments and businesses in more than 75 countries in the areas of health and pharmaceuticals, education and training, surveys and statistics, advanced technology, international development, economic and social policy, energy and the environment, and laboratory testing and chemical analysis.

Global Technology Solutions (GTS) caters to the diverse technology needs of RTI and its effort to digitally transform the Institute. GTS provides technical support, resources and services to help staff work efficiently and effectively in compliance with RTI policies. GTS also aims to provide technology solutions to support the Institute's Business Units, General and Administrative functions, and make RTI a global leader in finding innovative solutions to technological challenges.

RTI is looking for an experienced Oracle Integration Architect to join the Enterprise Applications and Analytics team. This role reports into the Integrations Lead and is responsible for development and maintenance of integrations with all G&A applications, including the Enterprise Data Warehouse.

Essential Duties:
* Collaborate with Business Analysts and business stakeholders in requirements gathering, development of Technical Design Documents and development and rollout of integrations with the SaaS, on-prem and cloud hosted applications.
* Lead integration architectural designs in collaboration with the System architecture team to design integrations based on approved ARB architecture canvases.
* Develop and maintain integrations using Oracle Integration Cloud (OIC)
* Develop and maintain best practices for integration development and contribute to overall integration strategy refinement.
* Closely partner with system architects, data architects and other technical team members
* Analyze and troubleshoot complex data integration ETL issues in a timely manner
* Develop and maintain documentation for integrations - such as Technical Design Documents and SIT Test scripts.
* Design, develop, implement, and optimize ETL workflows and transformations using Oracle Data Integrator (ODI) based on requirements for batch processing, real-time, bulk transfer or streaming of data into the Enterprise Data Warehouse.
* Implement Data Governance standards and procedures for ETL development and tool configurations.
* Collaborate with Master Data Management leads to ensure accurate and consistent transformations are applied in ETL processes.

Job Requirements are a combination of qualifications and related experience.
* Bachelor's Degree (preferably in Computer Science) and 12 years of relevant experience in OIC or
Master's degree and 10 years of experience or
PhD and 6 years of experience or
Equivalent combination of education and experience.
* 3 years working experience architecting and developing integrations in Oracle Integration Cloud

Integration architecture AND hands-on development/troubleshooting is a requirement.

Skills & Abilities
Below are skills and abilities required to perform the essential duties of this job. An addendum that clarifies additional skills and abilities for incumbents in this job may be used in addition to this description.
* Familiarity with all available data ingestion mechanisms in Oracle Autonomous data warehouse and corresponding data lakes and data marts
* Experience developing and maintaining ETL processes for data integration between various systems.
* Experience collecting, analyzing, and documenting user requirements
* Familiarity with all available data ingestion mechanisms in Oracle Autonomous data warehouse and corresponding data lakes and data marts
* Experience in designing ETL solutions for all data warehousing approaches such as Inmon and Kimball i.e. both ETL and ELT approaches.
* Excellent communications skills to interact with internal business owners and other developers, including training and mentoring of team members
* Possess skills in API design, security, and management.

Nice to Have
* Hands on experience with Oracle Kubernetes for container orchestration and deployment of integration solutions.
* Implement DevOps practices to streamline integration development, testing, and deployment processes.
* Design, implement, and maintain integrations using Oracle API Gateway.
* Experience in configuring and managing API Gateway policies, authentication, and authorization mechanisms.
* Implementing event-driven architecture using Oracle Streaming or Kafka.
* Experience developing serverless functions for handling integration tasks.

#LI-MH1

Disclaimer
The above information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job

For San Francisco, CA USA Job Postings Only: Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. Further information is available .

The anticipated pay range for this role is listed below. Our pay ranges represent national averages and may vary by location as a geographic differential may be applied to some locations within the United States.

RTI considers multiple factors when making an offer including, for example: established salary range, internal budget, business needs, and education and years of work experience possessed by the applicant. Further, salary is merely one element to our offer.

At RTI, we demonstrate our commitment to rewarding individual and team achievement through a total rewards package. This package includes (among other things) a competitive base salary, a generous paid time off policy, merit based annual increases, bonus opportunities and a robust recognition program. Other benefits include a competitive range of insurance plans (including health, dental, life, and short-term and long-term disability), access to a retirement savings program such as a 401(k) plan, paid parental leave for all parents, financial assistance with adoption expenses or infertility treatments, financial reimbursement for education and developmental opportunities, an employee assistance program, and numerous other offerings to support a healthy work-life balance.