Senior Oracle PL/SQL Developer

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.