Oracle PL/SQL Developer

Sr. PL/SQL Developer

Skills: Good with ETL automation, PL/SQL, stored procedure, Python, Oracle Database, functional business knowledge, good to have snowflake.

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 to Cloud environment - preferably AWS (S3) *      Exposure to data movement between Oracle to other RDBMS and vice versa using Python *      Good hands-on on PL/SQL including bulk collects, procedures, functions, 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. *      Person should have worked on python dtypes like list, dictionaires, tuples *      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 know Snow SQL, Snow Pipes, Streams, Views, Procedures, performance tuning. *      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, Lambda, Athena or Blob *      Team player, collaborative approach and excellent communication skills *      Candidate should be good in communication and articulationMinimum qualifications *      Graduate/B Tech/MCA *      Knowledge/exp. of Banking or Capital Markets is an added advantage for this positionPreferred 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 to Cloud environment - preferably AWS (S3) *      Exposure to data movement between Oracle to other RDBMS and vice versa using Python *      Good hands-on on PL/SQL including bulk collects, procedures, functions, 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. *      Person should have worked on python dtypes like list, dictionaires, tuples *      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. *      Good 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

Job Type: Contract

Pay: $60.00 - $65.00 per hour

Ability to Commute:

• Jersey City, NJ 07395 (Required)

Ability to Relocate:

• Jersey City, NJ 07395: Relocate before starting work (Required)

Work Location: In person

Salary : $60 - $65