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 themeaning 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 Developerand 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 Developer Location: NYC Onsite PositionExp: 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 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
Benefits Visit us at Alignity Solutions is an Equal Opportunity Employer, M/F/V/D.
CEO Message: Click Here
Clients Testimonial: Click Here