Senior Python Application Developer, Sql And Snowflake, Capital Markets

NOTE:
Hybrid work model, 4 days per week in Toronto, Ontario officeRATE:
$90 to $100/hrCORE SKILLS:
Python, SQL, Oracle, PL/SQL, stored procedures, Snowflake, C#INDUSTRY:
Capital MarketsDESCRIPTION
We are seeking a
Senior Python Application Developer with strong SQL, Oracle, and Snowflake experience
to join the Risk Division of a major investment management organization.The successful candidate will enhance, refactor, test, and support existing applications as database dependencies transition from legacy Oracle environments to Snowflake and Azure Cloud. The work will include identifying Oracle database interactions within application code, updating database connectivity and data access logic, converting Oracle SQL and PL/SQL, remediating stored procedure dependencies, and validating application behaviour following migration.This is a hands on application development and modernization role requiring strong Python coding skills and extensive experience integrating applications with databases. The primary focus is coding, database querying, application repointing, and production support rather than data engineering or data modelling.RESPONSIBILITIES
Enhance, refactor, test, and support existing Python applications used by Capital Markets Risk and other Risk teamsAnalyze application code to identify Oracle database calls, embedded SQL, stored procedure dependencies, and data access logicUpdate Python application components as database integrations transition from Oracle to SnowflakeWrite clean, maintainable, modular, and testable Python code for business critical applicationsDevelop, troubleshoot, and optimize SQL queries used by applications, scheduled processes, and reporting integrationsUpdate database connection logic, application configurations, queries, and data access componentsConvert, rewrite, or replace Oracle SQL and PL/SQL logic to support Snowflake based application workflowsReview and remediate dependencies on Oracle stored proceduresRead and update selected C# components that interact with Oracle databases, queries, and stored proceduresTroubleshoot application defects, database connectivity issues, SQL errors, performance problems, and production incidentsCreate and execute unit, integration, regression, reconciliation, and data validation testsValidate application results following migration to ensure data accuracy and continuity of business critical processesSupport Power BI reporting migrations from Oracle data sources to Snowflake where requiredParticipate in code reviews, technical discussions, migration planning, release activities, and production readiness reviewsDocument application changes, database interfaces, testing results, known issues, and operational proceduresCollaborate with developers, Technology teams, risk professionals, and technical stakeholders throughout the modernization lifecycleREQUIREMENTS
5 or more years of professional software or application development experienceStrong hands on Python development experience, including enhancing, testing, debugging, and supporting production applicationsDemonstrated ability to write clean, maintainable, and testable Python codeAdvanced SQL skills with experience writing, troubleshooting, and optimizing complex application queriesStrong experience integrating Python applications with relational databasesExperience maintaining application modules, database connectivity components, and data access layersStrong Oracle experience, including Oracle SQL, PL/SQL, stored procedures, and database driven applicationsExperience analyzing, modifying, converting, or replacing stored procedure logicExperience with Snowflake application connectivity and SQL development, or experience with another modern cloud database platformExperience supporting a database migration, application modernization, or application repointing initiativeExperience debugging production applications and resolving database integration issuesExperience with application testing, regression testing, reconciliation, or data validationAbility to read, understand, and update C# application codeExperience with source control, code reviews, and collaborative development practicesStrong analytical, troubleshooting, organizational, and communication skillsDegree in Computer Science, Engineering, Mathematics, Statistics, Finance, or a related discipline, or equivalent experienceNICE TO HAVE
Experience modernizing Python applications from Oracle to SnowflakeExperience converting Oracle SQL, PL/SQL, or stored procedures for SnowflakeExperience supporting scheduled Python applications, calculation processes, or internal business toolsAzure Cloud or Power BI migration experienceExperience with Capital Markets, risk management, investment management, or financial services applicationsNOTE: As part of our hiring process, we use AI‑based systems to support initial applicant screening.
#J-18808-Ljbffr