Senior Oracle Data Developer - PL/SQL & ETL Specialist

Fasttek; Lansing (MI); On-site; USD 95,000 - 135,000; Full time

Benefits offered by this job

Medical & Dental

Vision

PTO

Long-term Disability

Life Insurance

401(k) with match

Job summary

FastTek Global in Lansing, MI is seeking a senior Application Data Developer with 8+ years of experience to support enterprise applications within an Oracle environment. You will design, develop, and maintain database structures, PL/SQL code, and data integrations across systems.

The role requires leadership in data modeling, ETL development, and bringing vendor-hosted or COTS data into our ecosystem, collaborating with Data Architects, DBAs, and vendors to optimize data structures and processes.

Qualifications

• 8+ years of experience designing, developing, and maintaining Oracle database structures.
• Proficient in PL/SQL and developing data integrations in Oracle environments.
• Experience with data modeling, ETL, and integrating vendor COTS solutions.
• Ability to lead data migration and data conversion tasks.

Responsibilities

• Design, develop, and maintain Oracle database objects (tables, views, indexes, triggers, constraints).
• Develop and optimize PL/SQL packages, procedures, and functions to support business logic, data services, and ETL processes.
• Support data design and modeling activities, including logical and physical data models and normalization.
• Lead and execute data migration and data conversion tasks for new implementations, upgrades, and system integrations.
• Develop and consume web services (SOAP/REST) used in data integrations between internal systems and vendor-hosted COTS solutions.
• Analyze data and metadata to ensure accuracy, integrity, and compliance with agency standards.
• Work closely with Data Architects and DBAs on performance tuning, code reviews, and database best practices.
• Troubleshoot data issues, identify root causes, and implement corrective solutions.
• Participate in planning, estimation, documentation, and technical design sessions for both new projects and ongoing maintenance efforts.

Skills

PL/SQL

Data modeling

Normalization

Data analysis

Data quality

Metadata management

Web services

Data migration

Data conversion

COTS integration

Tools

Toad

SQL Developer

Job description

FastTek Global in Lansing, MI is seeking a senior Application Data Developer with 8+ years of experience to support enterprise applications within an Oracle environment. You will design, develop, and maintain database structures, PL/SQL code, and data integrations across systems.

The role requires leadership in data modeling, ETL development, and bringing vendor-hosted or COTS data into our ecosystem, collaborating with Data Architects, DBAs, and vendors to optimize data structures and processes.