Oracle PL/SQL Developer

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).