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 About the Role We are hiring an Oracle PL/SQL Developer Responsibilities (Day to Day) 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. Qualifications (Must Haves) 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 Hourly Rate: $65-$68 per hour Benefits 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. #J-18808-Ljbffr Collabera