ODI/OWB Developer

Overview

On Site
Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 7 Month(s)
No Travel Required

Skills

ODI
OWB
Azure Synapse Developer
PL/SQL
BIRT/BO
DW
Curam
SQL
Spark pools
PySpark
Python
SparkSQL
Power BI
Medicaid
Microsoft Power BI
Modeling
Oracle
Oracle Data Integrator
Oracle Warehouse Builder
Partnership
RDBMS
RTR
Relational Databases
Reporting
Scripting
Semantics
Systems Analysis
Testing
Extract
Transform
Load
Finance
Management
Mentorship
Microsoft Azure
Cloud Computing
Data Analysis
Data Integration
Data Warehouse
Analytics
Apache Spark
BIRT
Business Intelligence
Business Objects
Dashboard

Job Details

Job ID: NC-779769

Hybrid/Local ODI/OWB/Azure Synapse Developer (both must/15+) with PL/SQL, BIRT/BO, DW, Curam, SQL/Spark pools, PySpark/Python/SparkSQL, Power BI and Medicaid experience

Location: Raleigh, NC (NCDHHS-NCFAST)
Duration: 7 Months
Position: 1 (1)

Skills:
Experience programming and design of large scale web based distributed systems Required 5 Years
Experience in using Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI), Required 5 Years
Experience with SQL scripting and Relational Database modeling Required 5 Years
Experience with Experience with structured system development methodologies Required 5 Years
Ability to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options. Required
Ability to organize, prioritize, and follow complex and/or detailed technical procedures. Required
Prefer experience with Business Intelligence tools such as Business Objects or BIRT Highly desired 2 Years
Prefer Data Warehouse experience Highly desired 2 Years
Experience with the Cram product. Highly desired 4 Years
Strong SQL Skill Highly desired 2 Years

Description:
NC FAST requires the services of a Curam Reports Developer to assist with reports development activities for NC FAST Medicaid Projects

North Carolina Families Accessing Services through Technology (NCFAST) is seeking a highly skilled Oracle PL/SQL and Microsoft Azure Synapse developer to provide business and system analysis, modeling, design, developing and maintaining Medicaid reporting solutions and semantic models. This role will work closely with NC FAST internal business team and Medicaid team to develop new reports and maintain the reporting code for some of the enhancements based on the backlog of change requests from the business and help fix some of the defects from the backlog as well.

Requirements
Strong understanding of relational databases (including tables, views, indexes, table spaces, users, grants)
Strong experiences in design, build, and manage data warehouses
5 or more years Oracle PL/SQL
Strong working knowledge Business intelligence and reporting tool (BIRT) and the understanding of the underlying data and tables in IBM Curam framework for the product delivery cases and the financial part to support all kinds of reports for case workers
Strong working knowledge of Build data analytics solutions using Azure Synapse serverless SQL pools
Demonstrated experience with Azure Synapse Analytics, including Synapse pipelines, SQL pools, and Spark pools.
1-2 years of experience utilizing Python, PySpark, and SparkSQL on Azure Cloud
Experience configuring, designing, developing and testing dashboards using Power BI
Lead and mentor other reporting developers in data integration efforts, utilizing ETL design patterns, error handling and configurations.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.