Talent.com
Oracle/SQL ETL Developer - Managed care
Oracle/SQL ETL Developer - Managed careHSK Technologies Inc • Des Moines, IA, US
Oracle / SQL ETL Developer - Managed care

Oracle / SQL ETL Developer - Managed care

HSK Technologies Inc • Des Moines, IA, US
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.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_alerts.create_a_job]

    OracleSQL ETL Developer Managed care • Des Moines, IA, US

    [internal_linking.similar_jobs]
    CDL-A Company Driver - 1yr EXP Required - OTR - Flatbed - $85k - $95k per year

    CDL-A Company Driver - 1yr EXP Required - OTR - Flatbed - $85k - $95k per year

    Koch Trucking • Ames, IA, US
    [job_card.full_time]
    Our dedication to respect, excellence, safety, and innovation has helped us become a full-service transportation and distribution leader. These values have helped us maintain a healthy business envi...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Licensed Mental Healthcare Provider

    Licensed Mental Healthcare Provider

    Covenant Family Solutions LLC • Ames, IA, US
    [job_card.full_time]
    Join Our Team as a Mental Health Therapist!.Are you passionate about providing high-quality therapeutic care? Do you thrive in a collaborative environment where you can make a meaningful impact on ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    APi Data Analyst - PERM FTE

    APi Data Analyst - PERM FTE

    Robert Half • Des Moines, IA, US
    [job_card.full_time] +1
    API INTEGRATION DATA ANALYST .LOCATION : HYBRID IN OFFICE IN DES MOINES.Easy location to commute to to work onsite! .YOU MUST BE ABLE TO WORK ONSITE • • but once you get up to speed,...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Oracle Analytics Specialist

    Oracle Analytics Specialist

    Oracle • Des Moines, IA, United States
    [job_card.full_time]
    Fusion Data Intelligence Content Development aims to enable customers to fully leverage their data by offering top-tier out-of-the-box content as well as a very flexible customization framework.Wit...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Senior / Lead Asterisk Developer

    Senior / Lead Asterisk Developer

    IDT • Madrid, Iowa, United States, 50156
    [job_card.full_time]
    Senior / Lead Asterisk Developer.Were looking for a Senior / Lead Asterisk Developer to help us build and scale a cloud PBX solution based on Asterisk. The team is building a cloud PBX solution based on...[show_more]
    [last_updated.last_updated_variable_days]
    Leasing Consultant, Indianola

    Leasing Consultant, Indianola

    Indigo Living • Indianola, IA, US
    [job_card.full_time]
    Current job opportunities are posted here as they become available.Subscribe to our RSS feeds to receive instant updates as new positions become available. Were a group of passionate people that jus...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    NetSuite Senior Developer

    NetSuite Senior Developer

    National Carwash Solutions, Inc. • Grimes, IA, US
    [job_card.full_time]
    National Carwash Solutions (NCS) has grown over the past 45 years to become North America’s largest equipment, service, and cleaning solutions provider in the car wash industry.Our world-clas...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    GENERAL BI DEVELOPER

    GENERAL BI DEVELOPER

    Mary Greeley Medical Center • Ames, Iowa, United States, 50010
    [job_card.full_time]
    Under general supervision, assists in planning, developing, and implementing computerized information systems.Assists with reporting, training, and the presentation of data in accordance with the h...[show_more]
    [last_updated.last_updated_variable_days]
    Director of Data Engineering

    Director of Data Engineering

    Workiva, Inc. • Ames, IA, United States
    [job_card.full_time]
    We are seeking a seasoned and strategic Director of Data Engineering to lead the evolution and operations of Workiva's multi-tenant data platform. This platform underpins our enterprise and customer...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Class A Dedicated Home Weekly

    Class A Dedicated Home Weekly

    18 Wheels Logistics • Ames, IA, US
    [job_card.full_time]
    Dedicated Class A CDL-A Drivers.Join our fleet running dedicated routes to well known stores.This is an active, high-paying position that offers consistent miles and a reliable weekly home time sch...[show_more]
    [last_updated.last_updated_30] • [promoted]
    PWM Analyst • •

    PWM Analyst • •

    Morgan Stanley • West Des Moines, IA, US
    [job_card.full_time]
    Private Wealth Management Analyst.Private Wealth Management (PWM) is a division of Morgan Stanley focused on delivering financial advisory resources to ultra-high net worth individuals, foundations...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Physician / Dermatology / Iowa / Permanent / Dermatology Opportunity in Iowa Job

    Physician / Dermatology / Iowa / Permanent / Dermatology Opportunity in Iowa Job

    First Choice Inc • Ames, Story County, IA, US
    [job_card.permanent]
    McFarland Clinic is seeking a BE / BC Dermatologist to join our extraordinary team and provide exceptional care within Iowas largest multidisciplinary clinic. Consistently ranked in the top 10 Best Pl...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Data Analyst

    Senior Data Analyst

    Fidelity & Guaranty Life Insurance Company • Des Moines, IA, US
    [job_card.full_time]
    Job Title : Senior Data Analyst.Telecommuting role to be performed anywhere in the U.Leverage prior Annuity and Life Insurance experience to drive Data Governance requirements and work with business...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Lead Software Engineer

    Lead Software Engineer

    Relativity • Des Moines, IA, United States
    [job_card.full_time]
    Are you looking to be in a workplace where colleagues inspire one another, working together to build AI software solutions?. We're looking for a Lead Software Engineer to join our Relativity Privacy...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Cloud Architect

    Cloud Architect

    Musco Sports Lighting • Des Moines, IA, US
    [job_card.full_time]
    If your experience aligns with the qualifications outlined below, we look forward to hearing from you!.Bachelor's degree in Computer Science, Computer Engineering, Information Technology or rel...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Technical Analyst EHR (FT) | Patient Scheduling | Ames | 2025-264

    Technical Analyst EHR (FT) | Patient Scheduling | Ames | 2025-264

    McFarland Clinic, P.C. • Ames, IA, US
    [job_card.full_time]
    McFarland Clinic is currently accepting applications for a Technical Analyst EHR for its Ames office.Candidates should be service-oriented, a team player, and be able to provide extraordinary care,...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Global SAP IS-U Architect : FICA & Billing Lead

    Global SAP IS-U Architect : FICA & Billing Lead

    Accenture • Des Moines, IA, US
    [job_card.full_time]
    A global professional services company is seeking an SAP IS-Utilities techno-functional specialist to lead program delivery and support teams for complex clients. This role requires minimum 3 years ...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Board Certified Behavior Analyst - Hybrid Role

    Board Certified Behavior Analyst - Hybrid Role

    BK Behavior • Ames, IA, US
    [job_card.full_time] +1
    Board Certified Behavior Analysts (BCBAs).Applicants must already hold active BCBA certification.Our training program is designed to support certified BCBAs in excelling within our company.Transiti...[show_more]
    [last_updated.last_updated_30] • [promoted]