Artech

Oracle PL/SQL Developer

Company : Artech

Location : Chicago, IL, 60290

Job Type : Full Time

Date Posted : 15 June 2026

Location:

Chicago IL

Introduction

Join our collaborative and supportive GIS team, passionate about delivering exceptional customer experiences while meeting unique business needs. This role offers the opportunity to work across the application stack, whether building new solutions, debugging existing code, or collaborating with cross-functional teams to deliver high-quality results.

Required Skills & Qualifications

5-10 years of Oracle Applications development experience using PL/SQL
2-3 years of Informatica development experience
Strong troubleshooting skills in SQL, PL/SQL, and Shell scripting
Strong Expertise in performance tuning of SQL queries, PL/SQL scripts, and ETL workflows
2-3 years of Shell/Python Scripting experience

Preferred Skills & Qualifications

Experience with relational database internals, query processing, and query planning
Knowledge of data modeling, key data structures, and algorithms
Familiarity with Python or other scripting/programming languages

Day-to-Day Responsibilities

Design and develop Oracle PL/SQL procedures, functions, triggers, and packages
Build and enhance ETL processes using Informatica
Conduct analysis and performance tuning of SQL queries, PL/SQL scripts, and ETL workflows
Perform logical and physical database design, indexing, and partitioning
Collaborate with data architects and analysts to ensure scalable and efficient solutions

Company Benefits & Culture

Inclusive and diverse work environment
Opportunities for professional growth and development
Supportive team culture focused on collaboration and innovation

For immediate consideration please click APPLY.