Oracle/SQL ETL Developer - Managed care Job at HSK Technologies Inc, Des Moines, IA

Nm5QMHRQYVY1dWMxTWJGd0FjMk5KNERJ
  • HSK Technologies Inc
  • Des Moines, IA

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

Job Tags

Contract work,

Similar Jobs

Delaware North

Security Officer, The Lodge at Geneva Job at Delaware North

 ...Delaware North Parks and Resorts is hiring a part-time Overnight Security Officer to join our team at The Lodge at Geneva in Geneva, Ohio. As...  ...and serving guests from all over the world, and want to experience hands-on learning, our Parks and Resorts team invites you to... 

Avera Medical Group

Registered Nurse (RN) or Medical Assistant | Family Medicine Clinic | PRN Job at Avera Medical Group

Performs selected medical assistant and clerical duties that assist in care for clinic patients following established standards, practices, and competency. Works collaboratively with other clinic staff to solve practice-related problems. Demonstrates knowledge of the principles...

First Fleet

Team Truck Drivers - CDL A Job at First Fleet

 ...Job Description Established Team Truck Drivers Wanted: CDL A | Home 2-3 days per week, Competitive Pay, & Great Miles! Benefits: ~ Top Team Pay! Earn $140,000 - $180,000~ Home Weekends ~100% No Touch Freight ~ Medical, Dental, Vision and Hearing - Plans start... 

Sodexo

Airport Lounge Line Cook Job at Sodexo

 ...Now Hiring: Cook Delta Sky Club, Jacksonville Airport / Sodexo Location: Jacksonville International Airport (JAX) Pay...  ...the airport. Why Work With Us: Work in a unique airport lounge setting Be part of a supportive team that values quality and... 

QPS Employment Group

Extrusion Operator Job at QPS Employment Group

 ...activities to ensure proper equipment startup and operation on multiple pieces of equipment - Read and interpret equipment manuals and production orders to perform required tasks such as tasks to set up, load materials, operate, monitor, troubleshoot, clean, and complete...