Logo
Jobs via Dice

Oracle / SQL Database Developer with Data Modeling, ERWIN, PL/SQL, ETL, etc.

Jobs via Dice, Albany, New York, United States

Save Job

Oracle / SQL Database Developer (Data Modeling, ERWIN, PL/SQL, ETL, etc.) Job ID: HBITS-07-14515

Location: 80 South Swan St, Albany, NY, 12210 (Hybrid – Onsite)

Seniority Level: Mid‑Senior

Employment Type: Full‑time

Job Function: Information Technology

Industry: Software Development

Note: Direct prime vendor with the State of New York.

Job Description

84 months experience creating views, triggers, stored procedures, functions, and writing SQL in Oracle 12c or higher

84 months experience using a data modeling tool such as ERWIN to create physical and logical data models, reverse engineer existing databases, and compare databases in Oracle 12c or higher

84 months experience developing complex ETL processes using shell scripts (Korn, Bash, PowerShell), SQL scripts, and PL/SQL

84 months experience performing data analysis and creating reports for customers

84 months experience optimizing SQL queries and debugging PL/SQL objects (packages, functions, and procedures)

60 months experience developing Korn shell and Bash shell scripts in a Linux environment

#J-18808-Ljbffr