PL/SQL & Data Warehouse Engineer (State exp need)
Posted 4 days ago by 1757482844
Negotiable
Outside
Remote
USA
Summary: The PL/SQL & Data Warehouse Engineer role involves designing and developing complex systems, maintaining system functionality, and addressing software issues within an Oracle Cloud environment. The position requires expertise in PL/SQL, data warehousing, and the ability to gather business requirements and create technical documentation. A customer-focused approach and familiarity with the SDLC are essential for success in this role. The position can be performed remotely or in Augusta, ME.
Key Responsibilities:
- Prepare detailed design specifications for complex systems.
- Maintain assigned systems and resolve system problems.
- Develop systems using higher-level programming languages and tools.
- Diagnose and isolate complex application software problems.
- Design and develop subroutines to support system development.
- Perform complex programming assignments to meet user needs.
- Manage multiple priorities while maintaining work momentum.
- Collaborate with teams and business contacts with a customer-focused approach.
- Work within a shared team development environment across the SDLC.
- Complete work in an Oracle Cloud environment.
- Apply data warehouse design and development principles.
- Understand and apply the Kimball method.
- Utilize data warehouse structure and star schema experience.
- Conduct software testing.
- Perform data/business analysis to gather requirements and create documentation.
Key Skills:
- PL/SQL
- Data Warehouse
- Review & Convert Coding
- Experience gathering business requirements
- Experience creating technical documentation
- Knowledge of Data Warehouse design principles
- Understanding of the Kimball method
- Data Warehouse Structure and Application / Star Schema experience
- Software testing experience
- Data/Business analysis skills
- Ability to work in an Oracle Cloud environment (OCI)
- Customer-focused approach
- Familiarity with SDLC
- Ability to manage multiple priorities
Salary (Rate): undetermined
City: Augusta
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Job Title: PL/SQL & Data Warehouse Engineer
Work Location: Augusta, ME (Remote)
Top Skills:
PL\SQL
Data Warehouse
Review & Convert Coding
Experience gathering business requirements
Experience creating technical documentation
Prepares detailed design specifications for highly complex and large-scale systems to plan and facilitate system development and programming.
Maintains assigned systems, responding to and resolving system problems to ensure systems are continuously available and function properly.
Develop systems employing higher level languages such as 3 GL's, 4 GL's, enterprise class application development tools, system utilities, and project management tools to prepare systems for implementation.
Diagnoses and isolates complex application software problems; formulates and implements effective solutions considering system capacity, limitations, time requirements, and desired results to resolve system problems and prevent reoccurrence.
Design and develop subroutines in support of system development efforts to achieve maximum productivity.
Perform difficult, complex, and specialized programming assignments to ensure users and business needs are met.
The ability to switch between multiple priorities while maintaining momentum on current work.
Customer focused approach when working with other teams and business contacts.
Familiar with a shared team development environment, including the ability to perform tasks for all aspects of the SDLC.
Ability to complete work in an Oracle Cloud environment (Oracle Cloud Infrastructure - OCI).
Knowledge and application of Data Warehouse design and development principles.
Understanding Kimball method and how it is applied.
Data Warehouse Structure and Application / Star Schema experience.
Software testing experience.
Data/Business analysis skills needed to gather business requirements and create technical documents.