Role: Oracle Analytics Reporting and Technical Developer
Location : [Saint Louis, MO, 63104] (Hybrid,)
Visa : No OPT and H1B
Duration: 6 Months C2H
Experience : 5+years
Working with Prime Vendor
Summary:
Oracle Analytics Reporting and Technical Developer is responsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business stakeholder requirements.
Role requires the following skills: Reporting and BI work using the myriad of Oracle database, cloud apps and tools listed in the job description; ETL Development to extract production data and store it in a reporting database or data warehouse to create reports
Responsibilities:
- Propose, conceptualize, design, implement, and develop solutions for difficult and complex applications independently.
- 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.
- Develop efficient data pipelines from Oracle Cloud ERP to OAC, leveraging features like FAW (Fusion Analytics Warehouse), using DBCS and with Oracle Transactional Business Intelligence 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.
Qualifications:
- 5 years of consulting or professional experience implementing analytics reports and solutions using Oracle technologies.
- 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
- 5 + 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.
- Oracle certifications are preferred.