Data Integration Lead

JD: Skill Set : Primary (Must have): Python, Oracle 19c, SQL Tuning, Apache Airflow, PL/SQL Secondary (Good to have): Jenkins, GIT Required Skills and Experience: • 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. ⸻ Bonus / Preferred Experience: • Prior experience modernizing legacy data workflows from Perl or PL/SQL stored procs. • Hands-on knowledge of Git/Bitbucket, Jenkins, CI/CD pipelines for code-controlled job rollouts. • Familiarity with financial data models (e.g., holdings, transactions, NAVs, tax lots). • Basic understanding of data governance, audit, and operational risk in financial systems. About the Role: We’re seeking an experienced Python Developer to lead the automation and orchestration of complex data workflows. The ideal candidate will have hands-on experience designing robust, fault-tolerant, and auditable pipelines across on-prem Oracle systems, integrating with job schedulers like RunMyJobs, and modernizing legacy processes using Apache Airflow. You will play a critical role in replacing legacy Perl/PLSQL scheduling logic with modern, Python-based DAG orchestration while ensuring traceability, data quality, and recoverability.