Python Developer (Apache Airflow & Oracle)

Python Developer (Apache Airflow & Oracle)Location: Jersey City, NJ (Onsite/Hybrid as per Client Requirement) Job Type: Contract-to-Hire Duration: August 3, 2026 – August 6, 2027 Experience: 5+ YearsJob Summary: We are seeking a skilled Python Developer with strong expertise in Apache Airflow, Oracle 19c, and enterprise workflow automation to support a large-scale modernization initiative. The ideal candidate will be responsible for designing, developing, and maintaining robust, scalable, and fault-tolerant data orchestration pipelines while replacing legacy Perl and PL/SQL scheduling processes with modern Python-based Airflow workflows. This role requires strong experience in ETL orchestration, enterprise job scheduling, REST API integration, and production support within large-scale data environments.Required Skills5+ years of hands-on Python development experience.2+ years of experience building and managing production-grade Apache Airflow DAGs.Strong expertise in Python-based automation and workflow orchestration.Solid experience with Oracle 19c databases, SQL optimization, and PL/SQL.Experience developing enterprise ETL and batch processing pipelines.Hands-on experience integrating REST APIs, SFTP/FTP file transfers, and external data sources.Experience working with enterprise job schedulers such as RunMyJobs, AutoSys, or similar scheduling platforms.Strong debugging and troubleshooting skills across application logs, databases, and file systems.Excellent understanding of workflow dependency management, monitoring, and error recovery.Strong communication and collaboration skills.Preferred SkillsExperience migrating legacy Perl or PL/SQL-based scheduling solutions to Apache Airflow.Experience developing custom Airflow Operators, Sensors, and Hooks.Hands-on experience with Git, Bitbucket, Jenkins, and CI/CD pipelines.Knowledge of financial services or capital markets data, including Holdings, Transactions, NAV, or Tax Lots.Understanding of data governance, auditing, compliance, and operational risk management.Key ResponsibilitiesDesign, develop, and maintain Python-based automation solutions for enterprise data processing.Build scalable Apache Airflow DAGs to orchestrate complex ETL and batch workflows.Modernize legacy scheduling processes by migrating Perl, PL/SQL, and RunMyJobs workflows into Airflow.Develop custom Airflow operators, sensors, and reusable components for Oracle databases, REST APIs, SFTP/FTP integrations, and external systems.Collaborate with DBAs, application teams, and business stakeholders to understand workflow dependencies and optimize execution.Implement automated monitoring, logging, alerting, retry mechanisms, and SLA tracking for production workflows.Optimize SQL queries and database interactions to improve performance and reliability.Maintain comprehensive execution logs, audit trails, and operational documentation.Participate in code reviews, deployment activities, and continuous improvement initiatives.Troubleshoot production issues and ensure high availability of automated workflows.