Oracle PL/SQL Engineer

Gov Services Hub; Newark (NJ); Híbrido; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

Gov Services Hub in Newark, DE (Hybrid) seeks an experienced Oracle PL/SQL Engineer to lead complex data integration and warehousing initiatives. You will design data models, tune databases, and collaborate with up‑stream and downstream systems in an agile team.

Candidates should have a bachelor's in a quantitative field and 10+ years of PL/SQL, ETL, and analytics experience. Proficiency with DataStage, Informatica, BI tools like Tableau/MicroStrategy, and scheduling tools is essential for

Formación

• Minimum 10 years of experience in Oracle PL/SQL development and ETL processes.
• Design conceptual, logical, and physical data models to support data warehousing and analytics requirements.
• Work with upstream SOR systems and downstream data models.
• Perform database fine tuning and optimize performance.
• Streamline and improve data flow and quality, ensuring data integrity and value.
• Conduct independent data analysis on large datasets to identify patterns and present findings.
• Enhance existing processes and define new ones.
• Collaborate in an agile, fast-paced development environment.
• Demonstrate strong analytical, problem-solving, and communication skills.
• Work effectively as part of a development team with minimal supervision.

Responsabilidades

• Help design data models to support warehousing and analytics.
• Tune databases and improve performance.
• Collaborate with upstream SOR systems and downstream data models.
• Lead ETL development using DataStage, Informatica, or Alteryx.
• Use BI tools like Tableau or MicroStrategy for reporting and analytics.
• Work in an Agile, fast-paced development environment and communicate findings.

Conocimientos

Oracle PL/SQL

ETL processes

Data warehousing

Analytics

Agile development

Team collaboration

Business communication

Educación

Bachelor's degree in a quantitative field

Herramientas

DataStage

Informatica

Alteryx

Tableau

MicroStrategy

Autosys

Shell scripts

Excel

Descripción del empleo

Job Summary (List Format) Oracle PL/SQL Engineer, Newark, DE (Hybrid)

• Minimum 10 years of experience in Oracle PL/SQL development and ETL processes
• Design conceptual, logical, and physical data models to support data warehousing and analytics requirements
• Work with upstream SOR systems and downstream data models
• Perform database fine tuning and optimize performance
• Streamline and improve data flow and quality, ensuring data integrity and value
• Conduct independent data analysis on large datasets to identify patterns and present findings
• Enhance existing processes and define new ones
• Collaborate in an agile, fast-paced development environment
• Demonstrate strong analytical, problem-solving, and communication skills
• Work effectively as part of a development team with minimal supervision
• Hold a bachelor's degree (or equivalent) in a quantitative field (e.g. computer science, mathematics, engineering, finance)
• Utilize ETL tools such as DataStage, Informatica, or Alteryx
• Use BI tools like Tableau or MicroStrategy for reporting and analytics
• Familiar with job scheduling tools (e.g. Autosys, Shell scripts)
• Possess strong Excel skills