Oracle PL/SQL Developer

Everforth Apex
Chicago, United States of America
18 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 142K

Job location

Chicago, United States of America

Tech stack

Data analysis
Unit Testing
ETL
Data Structures
Relational Databases
Python
Operational Data Store
Oracle Applications
Oracle SQL Developer
Performance Tuning
Shell Script
PL-SQL
SQL Databases
Informatica Powercenter
Data Management
Software Version Control
Oracledb

Job description

We are seeking an Oracle DB Developer to join our team. In this role, you will assist in the design, development, and implementation of various complex applications. You will be expected to follow best practices established by the team, including proper source code control practices and delivery of unit test cases. This position requires onsite presence five days a week., * Design, develop, and implement complex applications using Oracle PL/SQL.

  • Utilize Informatica for ETL processes.
  • Perform analysis and performance tuning of queries and scripts.
  • Conduct logical and physical database design.
  • Design key and indexing schemes, as well as partitioning strategies.
  • Construct and implement the operational data store.
  • Ensure data models are consistent with the ecosystem and adhere to data management standards.
  • Participate in building and testing business continuity and disaster recovery procedures.
  • Develop and troubleshoot using SQL, PL/SQL, and Shell scripts.

Requirements

Experience: 5 to 10 years of Oracle Applications related development experience using PL/SQL, and 2 to 3 years of Informatica development experience.

Technical Skills: Oracle Development (PL/SQL), Informatica, SQL, and Shell scripting.

Preferred Qualifications

  • Experience with relational database internals, including query processing and planning.
  • Knowledge of key data structures, algorithms, and data modeling.
  • Experience dealing with data at scale and adhering to strict audit standards.
  • Proficiency in other programming/scripting languages such as Python.
  • Experience with Data Analysis and Science is a plus.

Benefits & conditions

Compensation

The anticipated bill rate for this position is up to $96.93 per hour. The pay rate range is $63.00 to $68.26 per hour.

About the company

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Everforth Apex uses a virtual recruiter as part of the application process. Click for more details.

Apply for this position