Data Warehouse / PL SQL Developer
Top Skills Required
• PL/SQL (hands-on development)
• Data Warehouse design & development
• Code review and code conversion
• Business requirements gathering
• Technical documentation
Job Description
We are seeking an experienced Data Warehouse / PL-SQL Developer to support active data and analytics initiatives while also maintaining and supporting existing production environments. The selected resource will assist in meeting project timelines, collaborate closely with business and technical teams, and continue providing support following project go-live.
This role requires strong hands-on programming experience, deep understanding of data warehouse architecture, and the ability to translate business requirements into well-documented technical solutions.
Key Responsibilities
• Prepare detailed design and technical specifications for complex, large-scale systems to support development and implementation efforts
• Design, develop, review, and convert code using PL/SQL and higher-level programming languages (3GLs and 4GLs)
• Maintain and support assigned systems, ensuring availability, performance, and reliability
• Diagnose and resolve complex application issues, implementing effective solutions to prevent recurrence
• Design and develop reusable subroutines and components to improve development efficiency
• Perform complex and specialized programming tasks to meet business and user requirements
• Manage multiple priorities while maintaining progress on active deliverables
• Work collaboratively with business users and technical teams using a customer-focused approach
• Participate in all phases of the SDLC within a shared team development environment
• Develop and maintain technical documentation, including design specifications and system documentation
• Support software testing activities as required
Required Qualifications
• Strong hands-on experience with PL/SQL development
• Experience developing systems using 3GL and 4GL programming languages
• Solid knowledge of Data Warehouse design and development principles
• Experience with Kimball methodology and dimensional modeling
• Hands-on experience with Star Schema design and implementation
• Experience reviewing and converting existing codebases
• Ability to work in an Oracle Cloud Infrastructure (OCI) environment
• Software testing experience
• Strong data and business analysis skills, including requirements gathering and documentation
Pay: $60.00 per hour
Expected hours: 40.0 per week
Work Location: Remote
Apply tot his job
Apply To this Job