Source description
About the role
Job Summary We are seeking a highly experienced Senior Python Developer with deep expertise in Oracle PL/SQL to lead and execute the migration of complex stored procedures, functions, and packages to Python-based services. The role requires strong banking domain knowledge and the ability to work onsite with business and technical stakeholders to modernize legacy data and processing 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. Migrate business-critical logic related to banking operations such as payments, accounts, transactions, risk, or reporting. Use PyCharm IDE for Python development, debugging, and code optimization. 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 data validation post-migration. Document migration approaches, code logic, and technical designs. Support deployment, post-go-live stabilization, and knowledge transfer.
Required Skills & Qualifications Technical Skills 10+ years of overall software development experience. Strong hands-on experience with Python (preferably Python 3.x). Advanced proficiency using PyCharm IDE . Extensive experience with Oracle Database (11g/12c/19c). Expert-level knowledge of PL/SQL : Stored Procedures Packages Functions Cursors Exception Handling Performance tuning Strong SQL optimization and query tuning skills. Complete cycle of migration from Oracle stored procedures to Python based procedures Experience migrating monolithic PL/SQL logic to Python services or batch jobs . Familiarity with: REST APIs ETL/data processing pipelines Object-oriented and functional programming patterns in Python Banking / Financial Domain ( Preferred) Strong understanding of banking systems and data models . Experience working with Regulatory or risk-related data Experience in high-volume, high-accuracy financial systems.
Nice to Have Experience with cloud platforms (AWS / Azure / GCP). Knowledge of Python frameworks (FastAPI, Flask, Django). Experience with CI/CD pipelines and DevOps practices. Exposure to data migration or modernization programs in banks. Experience replacing Oracle logic with microservices or event-driven architectures.
Soft Skills Self Starter Strong analytical and problem-solving abilities. Excellent communication skills for onsite stakeholder interaction. Ability to work independently and lead technical discussions. Strong documentation and mentoring capabilities.
More at Scadea