Overview
On Site
USD 60.00 - 65.00 per hour
Contract - W2
Skills
Jersey
Capital Market
Pl/Sql Developer
Life Insurance
Management
Oracle
Data Cleansing
Analytics
FOCUS
SQL
Database
Shell
Scripting
Real-time
SAP BASIS
Database Design
Data Modeling
Specification Gathering
Flowchart
Interfaces
Financial Services
Performance Tuning
PL/SQL
Unix
Shell Scripting
Python
Reporting
Extract
Transform
Load
SQL*Loader
Amazon Web Services
Computer Science
Taxes
Insurance
Law
Management Consulting
Finance
Regulatory Compliance
Job Details
Description:
Hybrid role, 2 weeks a month onsite in Jersey City, NJ
Interview, virtual then onsite at your own expense.
We are looking for a Senior Pl/SQL Developer to support our client's capital markets area.
Data is coming from internal systems as an upstream from Oracle. They also have external data coming in. Data moving all over the place in a lot of different directions.
Financial services experience would be preferred. 10+ years' experience including hands-on experience as a Pl/SQL Developer.
Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.
Rate: $60 - $65 / hr. w2
Responsibilities:
Designing and developing Oracle procedures, functions, triggers, packages, materialized views, and views using advanced features of Oracle 11g and 12c.
Manage ETL processing with Python, Oracle, and Unix, including both batch ETL and real-time stream processing.
Load and process large data sets from multiple vendors, performing data cleansing, transformation, and analytics with a focus on data modeling.
Perform performance tuning for existing SQL and PL/SQL objects and build optimized database components.
Create complex Unix shell scripts to automate batch job processing and generate real-time and daily reports on a weekly basis.
Conduct logical and physical database design, data modeling, and prepare design specifications to analyze dependencies and assess risks.
Develop and maintain technical specifications, data mappings, program logic, and flowcharts for all change requests.
Write advanced queries to identify and remediate potential issues when interfaces fail
Experience Requirements:
Financial services experience would be preferred. 10+ years' experience including hands-on experience with:
1) Performance tuning existing or new
2) Oracle SQL & PL/SQL
3) Experience dealing with massive data sets.
4) Unix shell scripting and Python
5) Some reporting tool experience
6) For ETL, we use SQL loader.
*NICE-TO-HAVE*
AWS.
Education Requirements:
BS in Computer Science or Equivalent experience.
Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.
W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality.
Please be advised- If anyone reaches out to you about an open position connected with Eliassen Group, please confirm that they have an Eliassen.com email address and never provide personal or financial information to anyone who is not clearly associated with Eliassen Group. If you have any indication of fraudulent activity, please contact
About Eliassen Group:
Eliassen Group is a leading strategic consulting company for human-powered solutions. For over 30 years, Eliassen has helped thousands of companies reach further and achieve more with their technology solutions, financial, risk & compliance, and advisory solutions, and clinical solutions. With offices from coast to coast and throughout Europe, Eliassen provides a local community presence, balanced with international reach. Eliassen Group strives to positively impact the lives of their employees, clients, consultants, and the communities in which they operate.
Eliassen Group 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.
Don't miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!
Hybrid role, 2 weeks a month onsite in Jersey City, NJ
Interview, virtual then onsite at your own expense.
We are looking for a Senior Pl/SQL Developer to support our client's capital markets area.
Data is coming from internal systems as an upstream from Oracle. They also have external data coming in. Data moving all over the place in a lot of different directions.
Financial services experience would be preferred. 10+ years' experience including hands-on experience as a Pl/SQL Developer.
Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.
Rate: $60 - $65 / hr. w2
Responsibilities:
Designing and developing Oracle procedures, functions, triggers, packages, materialized views, and views using advanced features of Oracle 11g and 12c.
Manage ETL processing with Python, Oracle, and Unix, including both batch ETL and real-time stream processing.
Load and process large data sets from multiple vendors, performing data cleansing, transformation, and analytics with a focus on data modeling.
Perform performance tuning for existing SQL and PL/SQL objects and build optimized database components.
Create complex Unix shell scripts to automate batch job processing and generate real-time and daily reports on a weekly basis.
Conduct logical and physical database design, data modeling, and prepare design specifications to analyze dependencies and assess risks.
Develop and maintain technical specifications, data mappings, program logic, and flowcharts for all change requests.
Write advanced queries to identify and remediate potential issues when interfaces fail
Experience Requirements:
Financial services experience would be preferred. 10+ years' experience including hands-on experience with:
1) Performance tuning existing or new
2) Oracle SQL & PL/SQL
3) Experience dealing with massive data sets.
4) Unix shell scripting and Python
5) Some reporting tool experience
6) For ETL, we use SQL loader.
*NICE-TO-HAVE*
AWS.
Education Requirements:
BS in Computer Science or Equivalent experience.
Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.
W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality.
Please be advised- If anyone reaches out to you about an open position connected with Eliassen Group, please confirm that they have an Eliassen.com email address and never provide personal or financial information to anyone who is not clearly associated with Eliassen Group. If you have any indication of fraudulent activity, please contact
About Eliassen Group:
Eliassen Group is a leading strategic consulting company for human-powered solutions. For over 30 years, Eliassen has helped thousands of companies reach further and achieve more with their technology solutions, financial, risk & compliance, and advisory solutions, and clinical solutions. With offices from coast to coast and throughout Europe, Eliassen provides a local community presence, balanced with international reach. Eliassen Group strives to positively impact the lives of their employees, clients, consultants, and the communities in which they operate.
Eliassen Group 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.
Don't miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!
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.