PL/SQL Developer, Data Warehouse, Code review, gathering business requirements, Technical Docum[...]

Cygnus Professionals Inc.; Augusta (ME); On-site; USD 82,656 - 86,788; Part time

Job summary

A technology consulting firm in Augusta is seeking a Mid-Senior Level Data Warehouse Developer to support the DAFS Datawarehouse team. The role requires expertise in TSQL and PLSQL, alongside strong problem-solving skills in a dynamic environment. Key responsibilities include designing complex systems and maintaining production environments. Competitive hourly pay is offered based on skills and experience.

Qualifications

• Experience with TSQL and PLSQL.
• Proven knowledge in Data Warehouse design and development.
• Ability to review and convert coding efficiently.

Responsibilities

• Prepare detailed design specifications for complex systems.
• Maintain systems and resolve issues for continuous availability.
• Develop complex applications and diagnose software problems.

Skills

TSQL – PLSQL

Data Warehouse Design and Development

Review & Convert Coding

Job description

Overview

The DAFS Datawarehouse team is looking for an individual to assist in meeting the timeline of the existing PRISM and OMS ReFRAME projects, while supporting agency users with the current production environments. Resource will provide continued support after projects go-live.

Responsibilities

• 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 3GLs, 4GLs, 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.
• Manage multiple priorities while maintaining momentum on current work and ensuring timely delivery.
• Provide a customer-focused approach when working with other teams and business contacts.
• Operate in a shared team development environment, performing tasks across all aspects of the SDLC.
• Complete work in an Oracle Cloud Infrastructure (OCI) environment.
• Apply Data Warehouse design and development principles with knowledge of Kimball methodology, star schema, and related concepts.
• Conduct software testing and perform data/business analysis to gather requirements and create technical documents.

Required Skills

• TSQL – PLSQL
• Data Warehouse Design and Development
• Review & Convert Coding

Preferred Skills

• Kimball Method
• State Experience

Job Details

• Seniority level: Mid-Senior level
• Employment type: Contract
• Job function: Information Technology

Base pay range: $60.00/hr - $63.00/hr. This range is provided by Cygnus Professionals Inc. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.