Epicareer Might not Working Properly
Learn More

Oracle/SQL ETL Developer - Managed care

Salary undisclosed

Apply on


Original
Simplified

Job Description

Job Description

Note: Only submit candidates with legitimate experience writing Stored Procedures, Views, and T-SQL within an Oracle platform. I understand that this one is a challenge.

Title/Role: - Oracle/SQL ETL Developer - Managed care

Region Description: State of Iowa

Req. Status: Open

No. of Openings: 1

No. Filled: 0

Worksite Address Des Moines, IA

Agency Interview Type In Person

Engagement Type: Contract

Duration: 6 Months With possible of Extension.

Short Description:

**In-Person Interviews ONLY***

DHS is looking for a database expert who will work within the Enterprise Data Warehouse to create and maintain ETL packages needed to support managed care and other Medicaid programs.

Complete Description:

****PLEASE NOTE - The client is ONLY scheduling IN-PERSON INTERVIEWS for this position. They will not schedule webcam or phone interviews. Please ONLY SUBMIT CANDIDATES who can EASILY ATTEND an IN-PERSON INTERVIEW if selected to interview***

The Bureau of Medical Systems & Enterprise Data Warehouse is seeking a motivated candidate to fulfill the Responsibilities of supporting managed care and other Medicaid programs by developing and maintaining ETL packages which are needed for agency reporting.

Experience with mainframe VSAM files are necessary to transform existing legacy files to the Data Warehouse.

This candidate also shares the responsibility for supporting the Medicaid Eligibility system s Oracle backend interfaces and reporting.

Excellent interpersonal, verbal and written communication skills and the ability to interact with a diverse group of team members is mandatory.

Responsibilities of DBA5 role include but are not limited to:

Working with SQL Server 2012+

Working with Oracle (version 11.x or higher)

Working with SQL Server Integration Services

Working with Mainframe VSAM files

Working on an Agile team

Required Skills:

Experience working with SQL Server 2012 +

Oracle 11.x Experience with Stored Procedures, Functions, Views

Experience working with CTE (Common Table Expressions)

Experience working with SQL Server Integration Services

Experience working with Mainframe VSAM files

Experience working on an Agile team

Year of experience Consultant have with below skills?

Experience working with SQL Server 2012+

Experience working with Oracle (version 11.x or higher)

Experience working with SQL Server Integration Services

Experience working with Mainframe VSAM files

Experience working on an Agile team

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.
Report this job