Talent.com
Oracle / SQL ETL Developer - Managed care

Oracle / SQL ETL Developer - Managed care

HSK Technologies IncDes Moines, IA, US
28 days ago
Job type
  • Full-time
Job description

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