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.
Exp: 8 Years
Requirements
In this role you would be part of the data integrity/analysis team in the Banking and financial domain. You will be responsible to independently build data analysis around complex business problems from data available in the client owned or accessible systems. For these tasks you would be encouraged to understand the business ask/problem assess the scope quantity and quality of the available data prepare and build the Data pipeline and loading data in to DWH and Data Mart for downstream consumption team.
Responsibilities
- Oracle DB and Python Developer with extensive experience in PL/SQL and Python.
- 6 years of relevant experience and skilled in Oracle Database with hands on exposure.
- Exposure to data analysis and data crunching on database with very good SQL skills.
- Good handson on PL/SQL including Stored procedures functions view materialized views cursors and exception handling.
- Person shall have good knowledge on Window functions analytical functions CTE Merge.
- Very good experience in reading SQL plans performance tuning partitioning and other techniques.
- Very good SQL expertise in Joins Analytical functions and triggers.
- Person should have worked on python dtypes like list dictionaries
- Handson and good experience on python libraries like pandas sys os logger argument parser oracle conn libraries.
- Good exposure to string handling and email function using python.
- Experience in Agile/Scrum based project executions
- Good to have knowledge on CI/CD using Jenkins/Bamboo.
- Good to have python experience with handson experience on pandas snowpark data crunching connecting other RDBMS.
- Good to have Cloud knowledge on AWS services like S3
- Team player collaborative approach and excellent communication skills
- Candidate should be good in communication and articulation
Qualifications we seek in you
Minimum qualifications
- Graduate/B Tech/MCA
- Knowledge/exp. of Banking or Capital Markets is an added advantage for this position
Preferred qualifications
- Oracle DB and Python Developer with extensive experience in PL/SQL and Python.
- 6 years of relevant experience and skilled in Oracle Database with hands on exposure
- Exposure to data crunching and analysis on database with very good SQL skills.
- Good handson on PL/SQL including stored procedures functions views materialized view cursors and exception handling.
- Person shall have good knowledge on Window functions analytical functions CTE Merge.
- Very good SQL expertise in Joins Analytical functions.
- Person should have worked on python dtypes like list dictionaires tuples
- Good to have exposure on python libraries like pandas sys os logger argument parser oracle conn libraries.
- Good to have exposure to string handling and email function using python.
- Good to have experience in Python programming for ETL.
- Experienced in SQL performance tuning analytical functions joins and troubleshooting
- Knowledge on CI/CD using Jenkins/Bamboo
- Experience in Agile/Scrum based project executions
Benefits
Oracle DB and Python, PL/SQL, Oracle Database, Stored procedures, functions, view, materialized views, cursors and exception handling, Window functions, analytical functions, CTE, Merge. CI/CD, Jenkins/Bamboo
Education
B.E/B.Tech/MCA/MSC/MS
Employment Type
Full Time
