Python Developer (Apache Airflow & Oracle)

Argyllinfotech

NULL, NJ

JOB DETAILS
SKILLS
Apache, Application Programming Interface (API), Auditing, Automation, CA Workload Automation AE (AutoSys Edition), Capital Markets, Code Reviews, Communication Skills, Consulting, Continuous Deployment/Delivery, Continuous Improvement, Continuous Integration, Data Management, Data Processing, Database Extract Transform and Load (ETL), Database Optimization, Debugging Skills, Documentation, Error Recovery, FTP (File Transfer Protocol), File Systems, Financial Services, Git, High Availability, Identify Issues, Jenkins, Operational Audit, Operations Management, Oracle, Oracle Database, Oracle PL-SQL, Performance Management, Perl Programming Language, Production Control, Production Management, Production Support, Python Programming/Scripting Language, Query Optimization, REST (Representational State Transfer), Reliability Engineering, Risk Management, SQL (Structured Query Language), SQL Databases, Scalable System Development, Secure/SSH File Transfer Protocol (SFTP), Service Level Agreement (SLA), Software Engineering, Team Player
LOCATION
NULL, NJ
POSTED
8 days ago
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+ Years
Job 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 Skills
  • 5+ 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 Skills
  • Experience 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 Responsibilities
  • Design, 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.
Technical Environment
  • Python
  • Apache Airflow
  • Oracle Database 19c
  • SQL & PL/SQL
  • REST APIs
  • SFTP / FTP
  • RunMyJobs / AutoSys
  • ETL & Batch Processing
  • Git / Bitbucket
  • Jenkins
  • CI/CD Pipelines

About the Company

A

Argyllinfotech