Contractor Oracle ODI ETL Developer

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