Onsite Python & Airflow Orchestrator for Oracle ETL

Yoh Services LLC; Jersey City (NJ); On-site; USD 96,000 - 117,000; Full time

Benefits offered by this job

Medical, Prescription, Dental & Vision

Health Savings Account

Life & Disability Insurance

401K Retirement Savings Plan

Direct Deposit & weekly epayroll

Certification and training opportunit

Job summary

Yoh, a Day & Zimmermann company, is seeking a Python Oracle Linux Airflow Developer to lead the automation of complex data workflows in Jersey City, NJ. Onsite final interview required; USC/GC only; no visas.

Responsibilities include building Airflow DAGs, migrating Perl/PLSQL logic to Python-based orchestration, integrating with Oracle 19c, and developing robust, auditable pipelines with error handling and monitoring.

Qualifications

• 5+ years of Python development experience, with strong understanding of system/process automation.
• 2+ years of Apache Airflow building production DAGs.
• Solid understanding of Oracle 19c database, SQL tuning, and PL/SQL concepts.
• Experience orchestrating jobs that move large volumes of data across enterprise systems.
• Familiarity with job schedulers (RunMyJob, Autosys, etc.) and how to replace/abstract them using orchestration tools.
• Strong debugging skills across logs, databases, and filesystem for failed jobs or partial runs.
• Experience building REST API integrations, SFTP/file movement logic, and parameter-driven automation.

Responsibilities

• Develop, deploy, and maintain Python-based automation scripts to orchestrate jobs across Oracle 19c on-prem systems.
• Design and implement Airflow DAGs to manage complex interdependent ETL workflows.
• Migrate existing job logic from Perl, RunMyJob, and PL/SQL-based scheduling into modular, observable Airflow DAGs.
• Build custom Airflow operators/sensors for integration with Oracle, REST APIs, file drops (SFTP/FTP), and external triggers.
• Implement robust error handling, alerting and retry mechanisms across job pipelines.
• Collaborate with DBAs and application teams to understand job dependencies, critical paths, and data lineage.
• Establish job execution logs, audit trails, and SLA monitoring dashboards.
• Participate in code reviews, documentation, and onboarding new jobs into the orchestrator.

Skills

Python automation

Airflow development

REST API integrations

SFTP/FTP file movement

Debugging logs/dbs

Job orchestration

Tools

Oracle 19c

RunMyJob

Autosys

PL/SQL

Git/Bitbucket

Jenkins CI/CD

Job description

Yoh, a Day & Zimmermann company, is seeking a Python Oracle Linux Airflow Developer to lead the automation of complex data workflows in Jersey City, NJ. Onsite final interview required; USC/GC only; no visas.

Responsibilities include building Airflow DAGs, migrating Perl/PLSQL logic to Python-based orchestration, integrating with Oracle 19c, and developing robust, auditable pipelines with error handling and monitoring.