Infotech Spectrum Inc, · 2 days ago
Oracle Analytics Reporting and Technical Developer
Wonder how qualified you are to the job?
Insider Connection @Infotech Spectrum Inc,
Responsibilities
Define complex application development administration and programming standards.
Oversee the support, maintenance, operation, and upgrades of applications.
Troubleshoot and resolve complex technical problems.
Review the physical design of existing systems for optimizing performance and create/maintain eco-system diagrams.
Lead projects, as necessary, for special systems and application development in areas of complex problems.
Collaborate with business leaders, users, and IT teams to plan, design, develop, test, and implement data models, dashboards, and reports primarily using Oracle Analytics Cloud.
Leverage ODI for data integration, ETL (Extract, Transform, Load), and data movement tasks.
Experience with Oracle databases and SQL is essential.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
5 or more years of experience with Oracle Fusion Cloud and OAC
Functional understanding of Oracle Fusion Modules (AP, GL, FA, CM, Procurement, PPM)
Oracle Fusion Cloud applications development experience using web services (SOAP/REST APIs, and PVOs)
Expert level experience in writing complex SQL queries, SQL tuning and database concepts
Strong ability to translate business requirements into technical designs and requirements
Strong communication skills with both technical and non-technical team members
Develop efficient data pipelines from Oracle Cloud ERP to OAC, leveraging features like FAW (Fusion Analytics Warehouse), using DBCS and with OTBI connection and BICC for data extraction and transformation
Implement at least three end-to-end projects involving OAC, FAW, and BICC. These projects may include migrations and new implementations
Collaborate with business leaders, users, and IT teams to plan, design, develop, test, and implement data models, dashboards, and reports primarily using Oracle Analytics Cloud
Leverage ODI for data integration, ETL (Extract, Transform, Load), and data movement tasks
Experience with Oracle databases and SQL is essential
Proficiency in OACS, ODI, and OBIEE repository (RPD) for all layers
Experience building complex reports and dashboards
Bachelor’s Degree – Information technology discipline or computer engineering
Preferred
ODI and OIC are a plus
Oracle certifications are welcomed
P6 knowledge, GIS DB knowledge, EPBCS – for source connections and integrations on OAC
Experience with App Composer
GitHub best practices for OAC repositories and reports
Ability to schedule reports and smtp distribution/mail server distribution
Company
Infotech Spectrum Inc,
Infotech Spectrum delivers comprehensive fully integrated creative IT solutions ranging from IT consulting services to advanced technology deployment and product development.
Funding
Current Stage
Growth StageCompany data provided by crunchbase