PLSQL Developer

Overview

Location: Jersey City, NJ (Only Local candidates who can come for in person interview)
Work Arrangement: Hybrid
Client Industry: Banking
Duration: 12 Months Contract

Key Focus Area: Oracle, PLSQL, SQL

We are hiring an 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.

• 5-8 years of hands-on experience designing and implementing scalable data solutions in large-scale data warehousing environments.
• 5-8 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.

Hourly Rate: $65-$68 per hour

Benefits: 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 off, paid sick and safe time, paid vacation time, paid parental leave, paid holidays annually where applicable.