Sr. Oracle ODI ETL Developer (Remote)

Cedent; United States; Remote; USD 55,104 - 82,656; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

Job summary

A technology solutions provider is seeking a Senior Oracle ODI ETL and OAC BI Developer. This role involves designing, developing, and maintaining ETL processes using Oracle Data Integrator and creating business intelligence solutions with Oracle Analytics Cloud. With the assignment primarily involving remote work, it's a contract position with potential full-time employment for qualified candidates. Applicants should have strong SQL skills, experience in data modeling, and proficiency in BI solutions development. The position has an hourly rate range of $40-60/hr.

Qualifications

• 3+ years of experience in developing BI solutions using Oracle Analytics Cloud.
• 5 years of experience building scalable ETL processes using ODI.
• Strong verbal and written communication skills.

Responsibilities

• Lead design and development of ETL processes using ODI.
• Develop and implement BI solutions with OAC.
• Optimize ETL workflows and BI solutions.

Skills

Oracle Data Integrator (ODI)

Oracle Analytics Cloud (OAC)

SQL & PL/SQL

Data Model design

REST APIs

Excel

Word

PowerPoint

Job description

Job Description

We recently completed an implementation of People Analytics solution on Oracle ADW and Oracle Analytics Cloud, which sources data from Oracle Fusion Cloud HCM Implementation and other internal Edge Systems. We are seeking an experienced, Senior Oracle ODI ETL and OAC BI Developer for designing, developing, and maintaining ETL processes using Oracle Data Integrator (ODI) and creating business intelligence solutions with Oracle Analytics Cloud (OAC).

This assignment primarily involves remote work. It is a contract position with the potential for full-time employment for candidates who meet the eligibility criteria.

Responsibilities

• Lead the design & development, and management of end-to-end ETL processes using Oracle Data Integrator (ODI).
• Develop and implement BI solutions using Oracle Analytics Cloud (OAC), including dashboards, reports, and data visualizations.
• Optimize ETL workflows and BI solutions to enhance performance and scalability.
• Collaborate with stakeholders to understand their business needs and develop solutions that meet those needs.
• Identify and resolve complex ETL and BI issues in a timely manner.
• Create and maintain comprehensive documentation for ETL processes, BI solutions, and best practices.
• Provide technical guidance and mentorship to team members.
• Provide on-call support of Data Integration Batch processes on a rotating basis and other on-call as required.
• Lead and oversee technical teams to ensure timely delivery of high-quality solutions.

Qualifications

• Must be proficient in understanding and triaging complex software issues.
• Must have 3+ years of experience in developing and implementing BI solutions using Oracle Analytics Cloud (OAC), including dashboards, reports, and data visualizations.
• Must have ability to multitask under pressure handling various deadlines.
• Must have at least 5 years of advanced skills in SQL & PL/SQL and data querying (including writing advanced select statements, stored procedures, and functions) experience.
• Must have at least 5 years of experience building scalable and reliable ETL to pull large and complex data together from different systems using Oracle Data Integrator.
• Must have basic knowledge of REST APIs and be able to test using Postman.
• Must have hands‑on experience in Data Model design and development and optimizing the performance of data warehouse.
• Must have knowledge of cloud computing principles, including SaaS, PaaS, and experience working on a cloud‑based database platform like ADW.
• Must have strong aptitude to isolate problems, address immediate needs, analyze ramifications, and implement solutions.
• Must have strong verbal and written communication skills to describe and report issues in non‑technical language.
• Must possess strong analytical skills and be highly proficient with Excel, Word & PowerPoint.

Nice to Have

• Experience supporting Oracle ORDS REST APIs is a plus.
• Experience with Oracle BICC Extracts and PVOs from Oracle Fusion Cloud HCM is a plus.

Compensation

Hourly Rate Range: $40-60/hr

Benefits Offered

[Health, Dental, Vision Insurance]

Deadline

Applications accepted until 10/30/2025 at 11:59 PM CST.

Equal Employment Opportunity Statement

We are an Equal Pay Employer. All employment decisions, including compensation, benefits, hiring, training, and promotions, are made based on merit, qualifications, and business needs. We do not discriminate on the basis of gender, race, ethnicity, age, disability, sexual orientation, or any other protected characteristic. We are committed to ensuring equal pay for equal work and regularly review our compensation practices to promote fairness, equity, and transparency across our organization.