Cloud Jobs in Prescott, ON

The Oracle Analytics and FDI – Technical Lead role will play a lead role in projects relating to the design and deployment of solutions based on Oracle’s Cloud-based data and analytics platforms including Autonomous Data Warehouse (ADW), Oracle Analytics Cloud (OAC), Oracle Data Integrator (ODI) and Oracle Fusion Data Intelligence (FDI). The ideal candidate will have hands on technical development expertise and experience with designing, building, testing and deploying ADW, OAC, ODI and / or FDI. Additionally, the ideal candidate will have prior experience with developing ETL and data pipelines using ODI where Oracle ERP and / or Oracle HCM systems are the primary data sources including Oracle Cloud ERP, Oracle Cloud SCM, Oracle Cloud HCM, Oracle E Business Suite, Peoplesoft and / or JD Edwards. The candidate is also expected to have experience using Oracle Analytics Cloud to create reports, dashboards and visualizations using both OAC Classic and Data Visualization. The candidate is expected to have prior experience with developing semantic models using Oracle’s Client Administration Tool (i.e., experience creating and modifying RPD’s). This role will be expected to play the lead in terms of overall solution design and architecture and it is important for the candidate to have strong communication, presentation and client interaction skills while also having strong hands-on technical skills. This role will also work with end users and IT personnel to identify requirements, develop designs and conduct testing. Although this role is a technical leadership role, it is ideal for the candidate to have prior functional experience and knowledge in one or more of the common analytics domains such as Finance, HR, Procurement, Supply Chain, Sales and Marketing. This role is also expected to work with the offshore team of Apps Associates in a collaborative manner to design and build solutions. It is a plus if the candidate has experience with and some understanding of Artificial Intelligence (AI) and machine learning (ML) and the machine learning lifecycle (although this is not a ‘hard and fast’ requirement for this role).

The candidate is expected to have significant expertise and experience with the technologies, skill sets, design patterns and use cases outlined below. Please note that while it is not necessary to have experience in all of the items outlined below, some level of experience with Oracle Analytics Cloud (or its predecessors) and Oracle Data Integrator is highly desirable.

• Oracle Analytics Cloud
• Classic
• Data Visualization
• Semantic Model Development
• Autonomous Data Warehouse
• Oracle Data Integrator
• Fusion Analytics Warehouse
• Fusion ERP Analytics
• Fusion HCM Analytics
• Fusion SCM Analytics
• Fusion CX Analytics
• PL / SQL, SQL, Python, Java (optional)
• Technical knowledge of the table structures in Oracle EBS, Oracle Cloud ERP, Oracle Cloud SCM and / or Oracle Cloud HCM (for data extraction purposes)
• Oracle Cloud Infrastructure Object Storage
• Data warehouse design and data modeling for data warehouses (e.g., star schema)
• Data lake design patterns and technologies – object-storage based and otherwise
• Design of data pipelines and ELT-based data integration
• Security design including SSO and row / data level security

While not required, experience with the technologies, platforms and knowledge domains below is considered a plus :

Roles and Responsibilities include :

The candidate for this role will be working on project delivery in a technical lead capacity. More specifically, outlined below are the roles and responsibilities for this role :

Required Qualifications

Education

Why Apps?

Apps Associates has a culture of extreme expertise built on trust and collaboration while ensuring competency and excellence which helps us build long term partnerships with our clients. This extreme expertise is only possible because of a pool of highly motivated, passionate and talented individuals who help address client’s core needs and thereby make a significant and positive difference in customer’s lives. In addition to excellent benefits. Apps Associates provides our employees with a robust platform for training, professional development and the ability to get certified which helps us continuously adapt, learn and maintain flexibility while delivering complex customer engagements.