Oracle PL/SQL Developer w/ capital markets domain expertise

TechDigital Group; Edison (NJ); On-site; USD 90,000 - 150,000; Full time

Job summary

An established industry player is seeking a seasoned application developer with extensive experience in Oracle SQL and Python. This role involves designing and maintaining robust applications, optimizing performance, and collaborating across teams to deliver innovative features. The ideal candidate will have a strong background in database programming and ETL processes, with a keen eye for detail and problem-solving abilities. Join a dynamic environment where your expertise will drive impactful solutions and help shape the future of technology in a collaborative setting.

Qualifications

• 12+ years of experience in Oracle, Python, and shell scripting.
• Strong database programming skills with Oracle PL/SQL and SQL.

Responsibilities

• Design, develop, and maintain applications using Oracle SQL and Python.
• Collaborate with teams to define and ship new features.

Skills

Oracle SQL

PL/SQL

Python

Unix

Shell Scripting

Problem-Solving

Database Programming

ETL Processes

Performance Tuning

Agile Methodologies

Tools

Informatica

Tivoli Workload Scheduler

AWS

Snowflake

Job description

JD Responsibilities:

• Design, develop, and maintain applications using strong Oracle SQL and PL/SQL, Python and Unix technologies.
• Collaborate with cross-functional teams to define, design, and ship new features.
• Optimize application performance and ensure scalability.
• Troubleshoot, debug, and upgrade existing systems.
• Write clean, maintainable, and efficient code.

Requirements:

• 12+ years of experience building solutions using Oracle, Python and shell scripting.
• Proficiency in Oracle PL/SQL and SQL.
• Experience in translating functional and technical requirements into detailed design.
• Experience in coding and unit testing, support SIT, UAT and production deployments.
• Must have good database programming skills covering design/development of stored procedures, functions, tables, and triggers and tuning SQL queries for optimal performance.
• Develop ETL processes using Informatica to manage data integration tasks.
• Proficiency in shell scripting.
• Experience with performance tuning and optimization of Oracle databases.
• Document system configurations, procedures, and best practices.
• Excellent problem-solving skills and attention to detail.
• Ability to work collaboratively in a team environment.

Preferred Qualifications:

• Experience with Tivoli Workload Scheduler (TWS).
• Experience with cloud services preferably AWS.
• Experience with Snowflake.
• Knowledge of DevOps practices and tools.
• Familiarity with Agile methodologies.