Overview
On Site
Depends on Experience
Contract - W2
Skills
PL/SQL
DML
ETL
RDBMS
AWS
Job Details
Email is the best way to reach me Please Don t reach me on WhatsApp
Role: PL/SQL Database Developer
Location: Jersey City, NJ (Hybrid). (Need Only Locals)
Mail:
Technical Skills:
- Looking for 11+ 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
Process Skills:
- Ability to evaluate, analyze, design, and implement solutions based on technical requirements.
- Develop and peer review of LLD (Initiate/ participate in peer reviews)
- Strong design and technical skills, ability to translate business needs into technical solutions and able to analyze the impact.
Behavioral Skills:
- Resolve technical issues of projects and explore alternate designs.
- Participates as a team member and fosters teamwork by inter-group coordination within the modules of the project.
- Effectively collaborates and communicates with the stakeholders and ensure client satisfaction.
- Train and coach members of project groups to ensure effective knowledge management activity.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.