Position: Oracle Pl/SQL Developer with Financial Domian
Location: New Jersey, US (Need Locals)
Exp Range : 12 Years
Note : Please look for resources who can do code & go for In person Interview
Following are the critical observations, they may help in picking the right candidates.
The associates have faltered on PL/SQL mainly. They are unable to tell cursors, analytical solutions using pl/sql, exception handling, analytical functions.
They have written many things in resume, but they are not able to answer if asked few things from resume (example person mentioned snowflake but was not able to answer.
Person should know what the have mentioned in their resume if its different from current JD (example AWS, CI/CD, Snowflake etc). But definitely they shall know PL/SQL and Python.
In python person should be able to write codes using list/dictionary, Connecting and loading data to pl/sql
Responsibilities
Oracle Pl/SQL 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 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 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
Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
...Schedule:** Full-time**Shift** : Days**Location:** 2350 MEADOWS BLVD, Castle Rock, 80109**The role you'll contribute:**The Safety Officer will develop, coordinate, and monitor programs to assure compliance with requirements of The Joint Commission Environment of Care...
...PRIMARY PURPOSE: This Director of Business Development is responsible for expanding utility sales of Grip-Tite anchors and related... ...national network of authorized dealers. This includes developing, managing, and supporting the dealer network to ensure consistent growth...
FRESH. FORWARD. FLOWERS. Flowers Foods, Inc. (NYSE:FLO) is not just about baking; it's about crafting moments of joy with every delicious bite. With 2024 sales of $5.1 billion, and as one of the leading producers of packaged bakery goods in the United States, Flowers...
...retail, online commerce, consumer marketing, and supply chain management. Since 1986, the company has partnered the world's finest brands... ...work effectively in multi-cultural situations. Benefits Private Health Insurance Performance Bonus Training &...
...customers with effective, efficient, and exceptional package deliveries within Erie County. We are looking for safe, reliable, energetic... ...to join our team in our drive for success. Delivery Associates drive our vehicles to deliver packages from our clients to residences...