Sr. Oracle ODI ETL Developer Job at Centstone, New York, NY

VjZDNGpKVkNWbGI5L1dOajVCRDZ4ZDR0S2c9PQ==
  • Centstone
  • New York, NY

Job Description

Job Title: Sr. Oracle ODI ETL Developer

Location: New York, New York

Position Type: Contract

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.

Job Tags

Full time, Contract work, Immediate start, Remote job,

Similar Jobs

HGC Group of Companies

Project Manager Job at HGC Group of Companies

Join our dynamic team as a Concrete Project Manager, where you will lead and oversee complex construction projects from conception to completion. In this pivotal role, you will ensure that all projects are delivered on time, within scope, and within budget. Your expertise...

Metro Community Health Center

Administrative Assistant Job at Metro Community Health Center

 ...employee premium for UPMC Gold Small Business Medical, United Concordia dental, STD, LTD and...  ...transportation and flexibility with work schedule required. Requires critical thinking...  ...underserved population. Experience in data entry, Access, MS Word, Excel. Knowledge of community... 

Harvard-Westlake School

Upper School Biology and Chemistry Teacher Job at Harvard-Westlake School

 ...Upper School Biology & Chemistry Teacher for 2025-2026 We are looking for a highly qualified educator for a Biology and Chemistry teaching position in the Science Department at the Upper School (grades 1012). The job entails teaching honors level biology (either Honors... 

Legacy Health

Professional Billing Specialst Job at Legacy Health

 ..., billing, financial, payment posting, cash reconciliation and collection services to ensure LHS financial viability and customer service...  ...and organizational skills. Ability to analyze and interpret data. LEGACYS VALUES IN ACTION: Follows guidelines set forth... 

RICEFW Technologies Inc

DPS - Program Manager 3/PM3 - Hybrid/REMOTE Job at RICEFW Technologies Inc

 ...Program Manager 3/PM3 Hybrid position: Mostly work from home but has to be able to report onsite as requested. The selected Program Manager will be responsible for the following Innovate Ohio projects at the Ohio Department of Public Safety: BASS 2....