Senior Oracle Data Developer - Hybrid ETL & Migrations

Zenfreed, LLC; Town of Lansing (NY); Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Job summary

Zenfreed, LLC in Lansing, NY seeks a senior Application Data Developer with 8+ years of experience to design, develop, and maintain database structures in an Oracle environment and to lead data integrations across agency applications and vendor-hosted solutions.

You will collaborate with Data Architects, DBAs, and vendors, own data modeling and ETL tasks, and provide technical leadership on data migration, Web services, and performance tuning in a hybrid, on-site schedule.

Qualifications

• 8+ years of experience with Oracle databases and PL/SQL.
• Experience with data modeling, ETL, and data migration.
• Experience designing and maintaining database objects.
• Experience with web services (SOAP/REST).
• Experience supporting vendor-hosted or COTS systems.

Responsibilities

• Design, develop, and maintain database objects to support application and integration requirements.
• Develop PL/SQL packages, procedures, and functions for business logic and ETL processes.
• Lead data migration and data conversion tasks for new implementations and upgrades.
• Develop and consume web services used in data integrations between internal systems and vendor-hosted solutions.
• Collaborate with Data Architects and DBAs on performance tuning and best practices.
• Participate in planning and technical design sessions for new projects.

Skills

Oracle PL/SQL

Data modeling

ETL development

Data integrity

Vendor data integrations

Problem solving

Education

Bachelor's Degree

Tools

Toad

SQL Developer

Job description

Zenfreed, LLC in Lansing, NY seeks a senior Application Data Developer with 8+ years of experience to design, develop, and maintain database structures in an Oracle environment and to lead data integrations across agency applications and vendor-hosted solutions.

You will collaborate with Data Architects, DBAs, and vendors, own data modeling and ETL tasks, and provide technical leadership on data migration, Web services, and performance tuning in a hybrid, on-site schedule.