Oracle PL SQL Developer

Collabera
Jersey City, United States of America
1 month ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 141K

Job location

Jersey City, United States of America

Tech stack

Agile Methodologies
Data analysis
Databases
ETL
Data Systems
Data Virtualization
Data Visualization
Data Warehousing
Database Storage Structures
Hadoop
Python
Machine Learning
Microsoft Office
Oracle Applications
Oracle SQL Developer
Power BI
PL-SQL
Tableau
Data Processing
Data Ingestion
Database Performance
Generative AI
Change Data Capture
Physical Data Models

Job description

We are hiring an Oracle PL SQL Developer Day to Day: o Develop and deploy scalable data warehouse architectures to support enterprise data needs. o 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. o Build and maintain high-performance ETL frameworks to support data ingestion, transformation, and integration across systems. o Design conceptual, logical, and physical data models and manage database structures including partitions, indexes, CDC, and data lifecycle processes. o 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. o Assist with building ad hoc and operational reports and support data testing, validation, and quality assurance for applications and data workflows.

Requirements

o 12+ years of hands-on experience designing and implementing scalable data solutions in large-scale data warehousing environments. o A10+ years of experience developing complex Oracle PL/SQL code and performing DBA-related responsibilities including database performance tuning and optimization. o Strong ability to analyze Oracle execution/query plans and AWR reports to identify performance bottlenecks and implement improvements through query, table, and index optimization. o Proficiency designing conceptual, logical, and physical data models for enterprise data warehouse solutions. o Proven experience building high-performance ETL pipelines and frameworks with robust error handling and scalability. o Strong working knowledge of database partitions, indexes, change data capture (CDC), data purging, and data virtualization. o 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. o Experience working in Agile teams and collaborating with cross-functional stakeholders to deliver scalable data solutions. Plusses: o Experience with data visualization tools such as Tableau (preferred) or Power BI. o Experience with Python, Hadoop, or modern data processing technologies. o Exposure to Generative AI or Machine Learning concepts. o Financial Services or Banking industry experience.

Benefits & conditions

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)

About the company

At Collabera, we don't just offer jobs-we build careers. As a global leader in talent solutions, we provide opportunities to work with top organizations, cutting-edge technologies, and dynamic teams. Our culture thrives on innovation, collaboration, and a commitment to excellence. With continuous learning, career growth, and a people-first approach, we empower you to achieve your full potential. Join us and be part of a company that values passion, integrity, and making an impact.

Apply for this position