Senior Python Developer - Airflow & Oracle Automation

Cloud Analytics Technologies, LLC; Jersey City (NJ); On-site; USD 120,000 - 180,000; Full time

Job summary

Cloud Analytics Technologies, LLC is seeking an experienced Python Developer to lead automation and orchestration of complex data workflows. The role focuses on replacing legacy Perl/PLSQL scheduling with Python-based DAGs using Apache Airflow on Oracle 19c systems.

You will design robust, auditable pipelines, implement custom Airflow operators, and ensure data quality and recoverability across on-prem environments. Collaboration with DBAs and application teams is essential.

Qualifications

• 5+ years of Python development experience.
• 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.

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

Oracle 19c

SQL tuning

REST APIs

Tools

RunMyJob

Autosys

Git/Bitbucket

Jenkins

Job description

Cloud Analytics Technologies, LLC is seeking an experienced Python Developer to lead automation and orchestration of complex data workflows. The role focuses on replacing legacy Perl/PLSQL scheduling with Python-based DAGs using Apache Airflow on Oracle 19c systems.

You will design robust, auditable pipelines, implement custom Airflow operators, and ensure data quality and recoverability across on-prem environments. Collaboration with DBAs and application teams is essential.