Oracle PLSQL developer with Python
Oracle PLSQL developer with Python
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
8years
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
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.
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 handson 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 .
(Preferred) Contribute to CI/CD pipelines using Jenkins/Bamboo.
(Preferred) Work with AWS services like S3 and other cloudbased 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 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.
Handson experience with data manipulation using Pandas.
Strong debugging and problemsolving skills.
Excellent communication and teamwork skills.
Preferred Qualifications:
Knowledge of Banking or Capital Markets.
Experience in Pythonbased data processing in Snowflake/Snowpark.
Familiarity with CI/CD tools (Jenkins Bamboo).
Exposure to AWS services like S3.
Benefits
Oracle SQL PL/SQL Python Data Analysis Performance Tuning Stored Procedures Joins Analytical Functions CTE Merge Partitioning Pandas Exception Handling Cursors Triggers DWH Data Pipeline Agile Scrum
Education
B.E/B.Tech/MCA/MSC/MS
Employment Type
Full Time
