Oracle PLSQL and Microsoft Azure Synapse Developer (Onsite)

Job Title : Oracle PL / SQL and Microsoft Azure Synapse Developer (Onsite)

Location : Durham NC

Duration : 12 Month

Job Description :

The Client 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 the 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 :

• Must be a local candidate and be able to come to office on a need basis
• 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 dash boards using Power BI
• Lead and mentor other reporting developers in data integration efforts utilizing ETL design patterns error handling and configurations

Skills : Skill

Required / Desired

Amount

of Experience

Experience programming and design of large-scale web based distributed systems

Required

Years

Experience in using Oracle Oracle Utilities ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI)

Required

Years

Experience with SQL scripting and Relational Database modeling

Required

Years

Experience with structured system development methodologies

Required

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

Years

Prefer Data Warehouse experience

Highly desired

Years

Experience with the C ram product.

Highly desired

Years

Strong SQL Skill

Highly desired

Years

Key Skills

Administration And Accounting,Events,ERP Sales,Access Control,Autocad Design,Inventory Management

Employment Type : Full Time

Experience : years

Vacancy : 1