Oracle developer

Collabera Inc.

Collabera Inc.

Software Engineering
Plano, TX, USA
USD 60-65 / hour
Posted on Apr 23, 2025

Oracle developer

Contract: Plano, Texas, US

Salary Range: 60.00 - 65.00 | Per Hour

Job Code: 361253

End Date: 2025-05-22

Days Left: 28 days, 11 hours left

Position Details:
Industry: Multinational Investment Bank And Financial Services Corporation
Work Location: Plano, TX
Job Title: Oracle developer
Duration: 12 Months

DayToDay Responsbilities:

  • Design & Implement Data Warehouse Solutions: Develop and deploy efficient, scalable data warehouse designs.
  • Optimize Oracle Performance: Tune queries, tables, and indexes using execution plans and AWR reports.
  • Develop & Maintain ETL Processes: Build robust, scalable ETL frameworks with error handling.
  • Model Data & Manage Databases: Create data models and manage database partitions, indexes, CDC, and virtualization.
  • Write & Optimize PL/SQL: Develop and refine complex Oracle PL/SQL code.

Must Have:

  • Data Warehousing Expertise: 12+ years of hands-on experience designing effective data solutions in large-scale data warehousing environments.
  • Advanced Oracle PL/SQL & DBA: 10+ years of experience with advanced Oracle PL/SQL and DBA responsibilities, including performance tuning.
  • Performance Optimization: Ability to analyze Oracle execution/query plans and AWR reports to identify and resolve performance bottlenecks through query, table, and index optimization.
  • Data Modeling: Proficient in designing conceptual, logical, and physical data models for data warehouse requirements.
  • ETL Framework Development: Proven experience building high-performance, scalable ETL data frameworks with robust error handling.
  • Database Management: Strong working knowledge of database partitions, indexes, change data capture (CDC), data purging, and data virtualization.

NiceToHave:

  • Data Visualization: Proficiency with data visualization tools (Tableau preferred, Power BI, etc.).
  • Technical Skills: Experience or exposure to Python, Hadoop, and Generative AI/Machine Learning (Gen AI/ML).
  • Industry Experience: Financial Services or Banking industry experience is a plus.
Job Requirement
  • Data Warehousing
  • oracle
  • PL/SQL
  • Visualization
  • Hadoop
  • DBA
  • database
  • developer
  • ETL process
  • financial
  • banking
  • investment
Reach Out to a Recruiter
  • Recruiter
  • Email
  • Phone
  • Sakshi Kothari
  • sakshi.kothari@collabera.com
Apply Now
Apply Now