CEDENT- Sr. Oracle ODI ETL Developer ()

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.

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 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 knowledge of working on a Cloud based database platform like ADW.
Must have strong aptitude to isolate problems, addressing immediate needs, analyzing ramifications, and implementing solutions
Must have strong verbal and written communication skills to describe and report issues in non-technical language
Must possess strong analytical skills and must 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

Visit Careers at CEDENT

Subscribe to be notified of new jobs

Share this job

Personal Information

* First name
* Last name
* Email
Address
* City
State
Zip code
* Phone number

Attachments

Attach a Cover letter Upload file

Attach

Other Information

How did you hear about this position? * Your Legal Work Authorization in the US? * Are you currently employed? * Will you be able to join us on our W-2? * What is your desired salary / hourly rate? * If on a Visa, will you be able to transfer your Work Visa to us? * What is your motivation for Change/New Job Opportunity? * If Currently working, what is your Notice period? * What is your current location? * Are you ready to relocate? * Can you provide proof of legal right to work in the United States? * if Hired when will you be able to start?