Apply on Employer Site

Motion Recruitment · 1 week ago

Senior Oracle PL/SQL Developer

United States

Contract

Remote

Senior Level, Lead/Staff

$55/hr - $60/hr

8+ years exp

Motion Recruitment is seeking a Senior Oracle PL/SQL Developer who will be responsible for designing and developing high-volume custom data load packages to transform data into the internal claims processing system. This is a remote contract position with a possibility of extension or conversion to permanent.

Information TechnologyRecruitingStaffing Agency

No H1B

Responsibilities

Designing and developing high-volume custom data load packages to import and transform data from customer-provided sources into our clients' internal claims processing system

Qualification

Oracle PL/SQLSQLData loading workflowsException HandlingHierarchical queriesMaterialized ViewsDebugging PL/SQL CodeDynamic SQL

Required

At least 8+ years of experience as an Oracle PL/SQL Developer

Strong skills in Oracle server-side programming including SQL, SQL•Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Job, Schedulers, and Oracle AQ

Proven experience designing, building, and optimizing data loading workflows to process structured data from various sources (e.g., flat files, CSVs, external databases)

Hands on experience writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues

Strong skills in Exception Handling extensively debug PL/SQL Code, DDL, DML and display the error messages in the application

Experience with writing hierarchical queries

Experience with external tables and high-volume data import into Oracle DB

Experience creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions and Coding Dynamic SQL statements

Benefits

Medical Insurance – Four plans to choose from for you and your family

Dental and Orthodontia Benefits

Vision Benefits

Health Savings Account (HSA)

Health and Dependent Care Flexible Spending Accounts (FSA)

401(k) Retirement Plan

Company

Motion Recruitment

Glassdoor3.5

Motion Recruitment, a Kelly® Company, delivers IT Talent Solutions for Contract, Direct Hire, Managed Solutions and Statement of Work to all of North America from our 21 delivery centers.

Founded in 1989

Boston, Massachusetts, USA

501-1000 employees