Oracle PL/SQL developer with Python Job at Alignity Solutions, New York, NY

OEZlTGpuZ1BLcG1DeTEzZjRwTkRGWXJkbHc9PQ==
  • Alignity Solutions
  • New York, NY

Job Description

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

Job Tags

Contract work,

Similar Jobs

Hire it People, Inc

.Net Developer Job at Hire it People, Inc

Job Seekers, Please send resumes to ****@*****.*** Must Have Skills:~ Experience in C#, .Net, MVC, SQL, MySQL, JavaScript, HTML, CSS, JQuery, design patterns. Job Description: ~ As a .NET Developer Solution Specialist, you can share innovative ideas...

Wellpath

Psychiatric Nurse Practitioner - Psych NP - Days Job at Wellpath

 ...clinical resources for training, education, and point of care support. How you make a difference The Psychiatric Nurse Practitioner (Psych NP) follows established policies and procedures and state guidelines, ensuring compliance with supervision requirements through... 

Lovisa

Retail Keyholder- Gateway Mall Job at Lovisa

Retail Keyholder POSITION DESCRIPTION AND KEY MEASURES Department: Retail Operations Location: Store Location Report to: DM Number of direct reports: POSITION PURPOSE AND EXPECTATION: Position Summary: We're seeking an energetic and responsible...

Hyatt

Guest Service Agent Job at Hyatt

 ...For more information, please visit our website at waterfordhotelgroup.com EOE/M/F/D/V This position is at a location where Hyatt is not the employer. The employer of individuals working at this hotel may be a third-party management company that is responsible for... 

CRH

Category Manager (Wal-Mart/Sam's Club) - Remote Job at CRH

 ...Manager is responsible for developing and executing category growth strategies that balance the needs of Oldcastle APG and Wal-Mart/Sams Club. Candidates intelligent and self-motivated with the ability to support various Brands & Categories for strategic growth....