Senior Oracle ODI ETL And OAC BI DeveloperWe 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 include:Leading the design & development, and management of end-to-end ETL processes using Oracle Data Integrator (ODI).Developing and implementing BI solutions using Oracle Analytics Cloud (OAC), including dashboards, reports, and data visualizations.Optimizing ETL workflows and BI solutions to enhance performance and scalability.Collaborating with stakeholders to understand their business needs and develop solutions that meet those needs.Identifying and resolving complex ETL and BI issues in a timely manner.Creating and maintaining comprehensive documentation for ETL processes, BI solutions, and best practices.Providing technical guidance and mentorship to team members.Providing on-call support of Data Integration Batch processes on a rotating basis and other on-call as required.Leading and overseeing technical teams to ensure timely delivery of high-quality solutions.Candidates must be proficient in understanding and triaging complex software issues.
Required experience includes:3+ years of experience in developing and implementing BI solutions using Oracle Analytics Cloud (OAC), including dashboards, reports, and data visualizations.Ability to multitask under pressure handling various deadlines.At least 5 years of advanced skills in SQL & PL/SQL and data querying (including writing advanced select statements, stored procedures, and functions) experience.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.Basic knowledge of REST APIs and able to test using POSTMAN.Hands on experience in Data Model design and development and optimizing the performance of data warehouse.Knowledge of cloud computing principles, including SaaS, PaaS and knowledge of working on a Cloud based database platform like ADW.