Oracle PL/SQL developer with Python

Do you love a career where you Experience , Grow & Contribute at the same time, while earning at least 10% above the market? If so, we are excited to have bumped onto you.

Learn how we are redefining the meaning of work , and be a part of the team raved by Clients, Job-seekers and Employees.

If you are a Oracle PL/SQL developer with Python looking for excitement, challenge and stability in your work, then you would be glad to come across this page.

We are an IT Solutions Integrator/Consulting Firm helping our clients hire the right professional for an exciting long term project. Here are a few details.

Check if you are up for maximizing your earning/growth potential, leveraging our Disruptive Talent Solution.

Role: Oracle PL/SQL developer with Python

Location: NYC

Exp: 8+Years

Requirements

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 .
  

Benefits

Visit us at . Alignity Solutions is an Equal Opportunity Employer, M/F/V/D.

CEO Message: Click Here

Clients Testimonial: Click Here