Senior Python Developer Oracle PL/SQL Migration (Banking Domain)

Senior Python Developer Oracle PL/SQL Migration (Banking Domain)

Employment Type: Full-Time (W2) Work Model: Hybrid 3 days onsite per week

Locations (Onsite Options) Tampa, FL New Jersey Irving, TX Toronto, Canada

Compensation Salary: $100,000 $130,000 per annum + benefits

Job Summary
We are seeking a highly experienced Senior Python Developer with strong Oracle PL/SQL expertise to lead the migration of complex stored procedures, functions, and packages into scalable Python-based services. The ideal candidate will have banking domain experience, hands-on expertise with PyCharm (mandatory), and the ability to collaborate onsite with business and technical stakeholders to modernize legacy systems.

Key Responsibilities
Analyze and understand complex Oracle PL/SQL stored procedures, packages, triggers, and functions used in banking systems.
Design and implement Python-based equivalents using industry best practices.
Lead migration of business-critical banking logic (payments, accounts, transactions, risk, reporting).
Perform Python development, debugging, and optimization using PyCharm IDE.
Ensure functional parity, performance, and data integrity between Oracle PL/SQL and Python implementations.
Optimize SQL queries and refactor procedural logic into modular, scalable Python code.
Collaborate onsite with DBAs, architects, business analysts, and QA teams.
Perform unit testing, integration testing, and post-migration data validation.
Document migration approaches, technical designs, and code logic.
Support deployment, post-go-live stabilization, and knowledge transfer.

Required Skills & Qualifications
10+ years of overall IT / software development experience.
5+ years of hands-on Python development (Python 3.x preferred).
Advanced, hands-on experience with PyCharm (mandatory).
Extensive experience with Oracle Database (11g / 12c / 19c).

Expert-level Oracle PL/SQL skills:
Stored Procedures
Packages
Functions
Cursors
Exception Handling
Performance Tuning
Strong SQL optimization and query tuning experience.
Proven experience migrating Oracle stored procedures to Python-based services.
Experience modernizing monolithic PL/SQL logic into Python services or batch jobs.

Familiarity with:
REST APIs
ETL / data processing pipelines
Object-Oriented and Functional programming in Python
Banking / Financial Domain (Preferred)
Strong understanding of banking systems and data models.
Experience with regulatory, risk, or compliance-related data.
Experience working in high-volume, high-accuracy financial systems.

Nice to Have
Experience with cloud platforms (AWS, Azure, or Google Cloud Platform).
Knowledge of Python frameworks (FastAPI, Flask, Django).
CI/CD and DevOps exposure.
Experience in data migration or large-scale modernization programs.
Exposure to microservices or event-driven architectures replacing Oracle logic.

Soft Skills
Self-starter with strong ownership mindset.
Excellent analytical and problem-solving skills.
Strong communication skills for onsite stakeholder engagement.
Ability to work independently and lead technical discussions.
Strong documentation and mentoring capabilities.