Oracle PL/SQL developer with Python

We are seeking a highly skilled Oracle PL/SQL Developer with Python to join our data integrity/analysis team in the Banking and Financial domain. The ideal candidate will have extensive experience in Oracle SQL, PL/SQL, and Python, with a strong focus on data analysis, performance tuning, and data pipeline development.

The candidate must have hands-on expertise in all required skills and will be subjected to a coding test in Oracle/SQL and Python.

Responsibilities:

• Develop and optimize SQL queries, stored procedures, and functions in Oracle PL/SQL.
  

• Perform advanced data analysis and troubleshooting of complex SQL queries.
  

• Build and manage data pipelines for integrating data into Data Warehouse (DWH) and Data Marts.
  

• Design and implement PL/SQL objects such as stored procedures, views, materialized views, cursors, and exception handling.
  

• Implement performance tuning strategies including partitioning, indexing, and SQL plan optimization.
  

• Utilize Python for data manipulation, automation, and integration with Oracle databases.
  

• Work with Python libraries such as pandas, sys, os, logger, argument parser, and Oracle connection libraries.
  

• Develop string handling and email automation functions using Python.
  

• Collaborate with business teams to understand data requirements and provide analytical insights.
  

• Work within an Agile/Scrum framework for project execution.
  

• (Preferred) Contribute to CI/CD pipelines using Jenkins/Bamboo.
  

• (Preferred) Work with AWS services like S3 and other cloud-based tools.
  

Required Skills & Experience:

• 6+ years of relevant experience in Oracle PL/SQL and Python development.
  

• Strong expertise in SQL joins, window functions, analytical functions, CTE, and merge statements.
  

• Experience in SQL performance tuning and understanding execution plans.
  

• Good knowledge of PL/SQL constructs such as triggers, cursors, and exception handling.
  

• Proficiency in Python data structures (lists, dictionaries, tuples) and file handling.
  

• Experience with Python for ETL and data analysis.
  

• Hands-on experience with data manipulation using Pandas.
  

• Strong debugging and problem-solving skills.
  

• Excellent communication and teamwork skills.
  

Preferred Qualifications:

• Knowledge of Banking or Capital Markets.
  

• Experience in Python-based data processing in Snowflake/Snowpark.
  

• Familiarity with CI/CD tools (Jenkins, Bamboo).
  

• Exposure to AWS services like S3.