Lead Python Developer for Airflow Data Orchestration on Oracle

Artifintech; Jersey City (NJ); On-site; USD 120,000 - 170,000; Full time

Job summary

Artifintech seeks an experienced Python Developer to lead automation of complex data workflows on Oracle 19c on-prem. You will design and implement Airflow DAGs to replace legacy Perl/PLSQL scheduling and ensure traceability and data quality.

You will build custom Airflow operators for Oracle, REST APIs, and file transfers, while driving observability, alerts, and recoverability across the pipeline.

Qualifications

• 5+ years of Python development experience, focusing on automation and orchestration.
• 2+ years of Apache Airflow building production DAGs.
• Solid Oracle 19c database, SQL tuning, and PL/SQL concepts.
• Experience moving large data volumes across enterprise systems.
• Familiarity with RunMyJob, Autosys, and similar schedulers.

Responsibilities

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

Skills

Python development

Apache Airflow

REST API integration

Oracle 19c

Data orchestration

ETL pipelines

Debugging & troubleshooting

Job schedulers knowledge

Git/Bitbucket

Tools

Git/Bitbucket

Jenkins/CI-CD

Job description

Artifintech seeks an experienced Python Developer to lead automation of complex data workflows on Oracle 19c on-prem. You will design and implement Airflow DAGs to replace legacy Perl/PLSQL scheduling and ensure traceability and data quality.

You will build custom Airflow operators for Oracle, REST APIs, and file transfers, while driving observability, alerts, and recoverability across the pipeline.