Alignity
Oracle PL/SQL developer with Python
Alignity - New York, New York, us, 10261
Work at Alignity
Overview
- View job
Overview
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.
Jobseeker Video Testimonials Employee Glassdoor Reviews 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 http://alignity.io/careers. Alignity Solutions is an Equal Opportunity Employer, M/F/V/D.
CEO Message: Click Here
Clients Testimonial: Click Here
, 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.
Jobseeker Video Testimonials Employee Glassdoor Reviews 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 http://alignity.io/careers. Alignity Solutions is an Equal Opportunity Employer, M/F/V/D.
CEO Message: Click Here
Clients Testimonial: Click Here