Be an early applicantLess than 25 applicants
Paramount Software Solutions, Inc · 2 days ago
Oracle BI Technical Lead
St Louis, MO
Contract
Onsite
Senior Level
5+ years exp
Wonder how qualified you are to the job?
Maximize your interview chancesSoftware
Insider Connection @Paramount Software Solutions, Inc
Responsibilities
OAC reporting, configuration/OBIA/ADW/DBCS
BICC/UCM/Object storage/data replication/packages/interface development
Ability to configure and perform data replication inside OAC on DBCS to extract fusion SaaS data.
Experience with App Composer
GitHub best practices for OAC repositories and reports
Ability to schedule reports and smtp distribution/mail server distribution.
P6 knowledge, GIS DB knowledge, EPBCS – for source connections and integrations on OAC
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 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.
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
OAC reporting, configuration/OBIA/ADW/DBCS
BICC/UCM/Object storage/data replication/packages/interface development
Ability to configure and perform data replication inside OAC on DBCS to extract fusion SaaS data
Experience with App Composer
GitHub best practices for OAC repositories and reports
Ability to schedule reports and smtp distribution/mail server distribution
P6 knowledge, GIS DB knowledge, EPBCS – for source connections and integrations on OAC
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
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
At least five 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
Oracle certifications are welcomed
Company
Paramount Software Solutions, Inc
Paramount Software Solutions is a computer software company offering software development and technology solutions.
51-200 employees
H1B Sponsorship
Paramount Software Solutions, Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Trends of Total Sponsorships
2023 (45)
2022 (72)
2021 (69)
2020 (130)
Funding
Current Stage
Growth StageLeadership Team
Pramod Sajja
President, CEO & Founder
Company data provided by crunchbase
