What are the responsibilities and job description for the Oracle PL/SQL developer with Python position at Tekfortune Inc.?
Job Details
Role: Oracle PL/SQL developer with Python
Location: New York, NY (Onsite 5 days in a week)
Duration: 3-6 months (with possible extension for long term)
Job Description: 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 hands-on 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
- Hands-on 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 hands-on 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 hands-on 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
