Oracle PL/SQL Developer w/ capital markets domain expertise

Skill Years of Experience Level of Competence Oracle PL/SQL 10-15+yrs Proficient Snowflake 4-5 Yrs Relevant Competent SQL 10-15+yrs Proficient Python 10-15+yrs Proficient AWS 4-5 Yrs Relevant Intermediate
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.