Senior Software Engineer, Reference Data Platform; Python​/Oracle; Avp

Citi is seeking an experienced and driven Applications Development Senior Programmer Analyst (C12 / AVP) to join our Master Reference Data (MRD) technology organization. In this role, you will be responsible for the design, development, testing and implementation of the Operating Model & Aritifical Intelligence (OMAI) Fusion application - a critical enterprise platform responsible for centralizing, mastering and distributing high-quality reference data across Citi’s global business lines.

As a Senior Programmer Analyst, you will leverage your expertise in Python and Oracle database technologies to build high-performance data processing pipelines, optimize complex database architectures and deliver resilient software solutions that support mission‑critical enterprise operations.

• Application & Pipeline Development: Design, code, test and implement robust backend services, ETL data pipelines and batch/real‑time processing components for the Fusion platform using Python.
  Database Architecture & Optimization: Architect, optimize and maintain complex Oracle databases; write, tune and maintain advanced SQL queries, stored procedures, PL/SQL packages, triggers and views to handle large volumes of reference data efficiently.
  Master Reference Data Integration: Partner closely with business analysts, data stewards and upstream/downstream application teams to analyze reference data requirements and translate them into scalable technical implementations.
  System Performance & Scalability: Identify system bottlenecks, perform performance tuning across Python code and Oracle databases and implement partitioning, indexing and memory optimization strategies.
  Engineering Standards & Quality: Define and adhere to software development best practices, test‑driven development (TDD), automated unit/integration testing and code review processes to maintain high code quality and reliability.
  CI/CD & Dev Ops
  
  Collaboration:
  
  Work with modern CI/CD pipelines to support automated builds, deployments and environment configuration management.
  Production Support & Risk Mitigation: Assist in tier‑3 technical troubleshooting and root cause analysis for production incidents; ensure all implementations comply with Citi’s security, risk management and governance standards.
  Mentorship & Team
  
  Collaboration:
  
  Provide technical guidance and peer reviews to junior developers, actively participating in Agile/Scrum ceremonies and sprint planning.

• Experience: 5–8 years of professional experience in software engineering and application development, with a proven track record of delivering enterprise‑scale systems into production.
  Python Expertise: Strong hands‑on proficiency in Python ( for enterprise application development, data manipulation, object‑oriented design and automated testing.
  Oracle & SQL Mastery: Advanced proficiency with Oracle Database (12c/19c+), including complex SQL query design, PL/SQL programming, schema design, index optimization, query execution plan analysis and database performance tuning.
  Data Modeling & ETL: Strong understanding of relational data modeling, Master Data Management (MDM) concepts, data normalization/denormalization and large‑scale data ingestion and transformation pipelines.
  Development Practices: Practical experience with version control systems (Git), continuous integration/continuous deployment (CI/CD) pipelines and automated testing frameworks (, pytest, unittest).
  Problem Solving & Communication: Excellent analytical, troubleshooting and problem‑solving skills, with the ability to communicate technical concepts clearly to both technical peers and business stakeholders.
  Education: Bachelor’s degree in Computer Science, Software…