Oracle PLSQL Developer

Jersey, NJ - USA

Monthly Salary: Not Disclosed

Posted on: 2 hours ago

Vacancies: 1 Vacancy

Job Summary

Oracle PL/SQL Developer

Jersey City NJ / Addison TX

Note: Looking for Local and W2 Candidates only

Work split:

Oracle PL/SQL / Shell / Python / Vertica - 70%

ETL transformations (Informatica) - 10%

Unix shell scripting Python - 20%

Required Qualifications:

10 years of experience with relational and non-relational databases focusing heavily on Oracle SQL and PL/SQL.

Strong experience designing and implementing Oracle-driven data integration pipelines using SQL PL/SQL and Unix shell scripting.

Experience automating Oracle processes using job schedulers (Autosys preferred).

10 years of professional experience in SQL/PLSQL development including packages functions procedures triggers and bulk processing.

Ability to refine requirements participate in story sizing and help drive Agile delivery.

Ability to perform POCs/spikes to test new Oracle features or solution patterns.

Develop test and deliver Oracle-based solutions that meet acceptance criteria and adhere to compliance standards.

Strong understanding of how to integrate multiple architectural components (data application business).

Good understanding of dimensional modeling star/snowflake schemas facts dimensions and hierarchies.

Skilled in leading and developing complex Oracle data flows connecting to heterogeneous databases such as Oracle and MS SQL Server.

Hands-on experience developing complex Oracle procedures functions and PL/SQL packages used in APIs reporting and data warehousing.

Ability to conduct both proactive and reactive Oracle performance tuning using explain plans indexing strategies statistics hints and SQL optimization best practices.

Strong hands-on experience developing and supporting Unix shell scripts (critical skill).

Oracle PL/SQL Developer Jersey City NJ / Addison TX Note: Looking for Local and W2 Candidates only Work split: Oracle PL/SQL / Shell / Python / Vertica - 70% ETL transformations (Informatica) - 10% Unix shell scripting Python - 20% Required Qualifications: 10 years of experienc...