Oracle PL​/SQL Developer

Location: Jersey City, NJ (Local Candidates, in-person interview)

Work Arrangement: 3 days in office (Hybrid)

Client Industry: Banking

Contract Duration: 12-18 months

Schedule: Monday to Friday

Oracle PL/SQL Developer

• Develop and deploy scalable data warehouse architectures to support enterprise data needs.
• Write, maintain, and optimize complex Oracle PL/SQL code, including packages, procedures, functions, and triggers while tuning queries, tables, and indexes using execution plans and AWR reports.
• Build and maintain high-performance ETL frameworks to support data ingestion, transformation, and integration across systems.
• Design conceptual, logical, and physical data models and manage database structures including partitions, indexes, CDC, and data lifecycle processes.
• Analyze datasets to identify trends and insights while collaborating with business and technology stakeholders to translate requirements into technical solutions, data mappings, and design artifacts.
• Assist with building ad hoc and operational reports and support data testing, validation, and quality assurance for applications and data workflows.

• 8-15 years of hands‑on experience designing and implementing scalable data solutions in large‑scale data warehousing environments.
• 10+ years of experience developing complex Oracle PL/SQL code and performing DBA‑related responsibilities including database performance tuning and optimization.
• Strong ability to analyze Oracle execution/query plans and AWR reports to identify performance bottlenecks and implement improvements through query, table, and index optimization.
• Proficiency designing conceptual, logical, and physical data models for enterprise data warehouse solutions.
• Proven experience building high‑performance ETL pipelines and frameworks with robust error handling and scalability.
• Strong working knowledge of database partitions, indexes, change data capture (CDC), data purging, and data virtualization.
• Experience performing data analysis, data exploration, and validation while working closely with business stakeholders to gather requirements and translate them into technical solutions and data workflows.
• Experience working in Agile teams and collaborating with cross‑functional stakeholders to deliver scalable data solutions.

65$‑68$ per hour. This range reflects base compensation and may vary based on location, market conditions, experience, and candidate qualifications.

The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long‑term disability insurance, short‑term disability insurance, paid parking/public transportation, paid time, paid sick and safe time, hours of paid vacation time, weeks of paid parental leave, paid holidays annually – as applicable.