What are the responsibilities and job description for the PL/SQL Developer position at Arbor TekSystems?
Role: Database(PL/SQL) Developer
Location: Jersey City, NJ (Hybrid)
Job Type: Contract
Duration: 12 months with possible extension
Who are we looking for?
We are looking for 8 Years of database development experience should have min 6 years of relevant experience. Strong SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions & User defined data types.
Technical Skills:
Looking for 8 Years of database development experience and should have min 6 years of relevant experience
Strong PLSQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions & User defined data types.
Expertise in using Oracle Performance tuning concepts with Oracle hints and EXPLAIN PLAN tool
Strong experience using SQL and PL/SQL features like Built In Functions, Analytical Functions, Cursors, Cursor variables, Native dynamic SQL, bulk binding techniques and Packages/Procedures/Functions wherever applicable to process data in an efficient manner
Strong understanding of Data Warehousing and Extraction Transformation Loading (ETL)
Sound understanding of RDBMS (Oracle)
Should have used Oracle SQL Loader/External File Utilities to load files
Strong experience using Python or Perl
Good to have experience with Snowflake cloud data platform including Snowflake utilities like SnowSQL, SnowPipe, data loading within cloud (AWS or Azure)
Exposure in Investment Management (Evaluation, Cash Flow, Projections, Analytics)
Strong written and oral communication skills
Excellent problem-solving and quantitative skills
Demonstrated ability to work as part of a team.
Investment Management experience in the past
