What are the responsibilities and job description for the Oracle PL SQL Developer position at Collabera LLC?
Job Title: Oracle PL SQL Developer
Location: Jerseycity ,NJ /Addison,TX (Onsite Interview , Local candidates only )
Work Arrangement:3days in Office (Hybrid )
Client Industry: Banking
Duration: 12 -18 months Contract
Schedule: Monday to Friday
About the Role
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.
- 12 years of hands-on experience designing and implementing scalable data solutions in large-scale data warehousing environments.
- A10 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.
- Experience with data visualization tools such as Tableau (preferred) or Power BI.
- Experience with Python, Hadoop, or modern data processing technologies.
- Exposure to Generative AI or Machine Learning concepts.
- Financial Services or Banking industry experience.
Hourly Rate: 65$-68$ per hour
This range reflects base compensation and may vary based on location, market conditions, experience, and candidate qualifications.
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, paid sick and safe time, hours of paid vacation time, weeks of paid parental leave, paid holidays annually - AS Applicable)
About Us
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.
Ready to Apply?
Apply now or reach out to Pritam Palai at for more information. We look forward to speaking with you!
Salary : $65