Oracle PL/SQL developer with Python

About the position

We are an IT Solutions Integrator/Consulting Firm helping our clients hire the right professional for an exciting long term project. 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. Learn how we are redefining the meaning of work, and be a part of the team raved by Clients, Job-seekers and Employees.

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.
• Contribute to CI/CD pipelines using Jenkins/Bamboo.
• Work with AWS services like S3 and other cloud-based tools.

Requirements

• 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.

Nice-to-haves

• 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.