Scalence L.L.C. · 4 months ago
Oracle PL/SQL Developer
Chicago, IL
Full-time
Onsite
Senior Level
$65/hr - $70/hr
5+ years expScalence L.L.C. is seeking an Oracle PL/SQL Developer to join their collaborative GIS team. The role involves designing and developing Oracle PL/SQL procedures, enhancing ETL processes, and collaborating with data architects to ensure efficient solutions.
Information Technology & Services
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
Qualification
Required
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
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
Benefits
Inclusive and diverse work environment
Opportunities for professional growth and development
Supportive team culture focused on collaboration and innovation
Company
Scalence L.L.C.
In today’s dynamic and competitive market, success hinges on mastering three key areas: Data Intelligence, Business Resilience, and Digital Experience.
501-1000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase