Skills

SQL Programming Databases Recruitment PL/SQL

Job Specifications

About the job

Our client, the world’s leading risk and claims administration partner recognized as America’s Greatest Workplaces, is seeking a Senior Oracle PL/SQL Developer. In this role, you responsible for 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.

This is a 6-month 100% remote contract opening with an excellent chance of being extended. There is also a chance it could be converted to permanent.

Required Skills & Experience

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.

The Offer

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

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying; no sponsorship is currently available. Employment is contingent upon successful completion of a pre-employment screening.

About the Company

Motion Recruitment delivers IT Talent Solutions for Contract, Direct Hire, Managed Solutions and Statement of Work to all of North America from our 21 delivery centers. Our high-touch, specialized, team-based recruitment model’s success is proven through our exemplary track record in filling the most challenging IT positions for startup and enterprise clients alike. Our hyper-specialized tech focus results in a truly consultative approach for both our clients and candidates, within our recruiting areas of expertise: Software... Know more