Senior Developer - Oracle SQL / PL SQL & Python PySpark- Assistant Vice President

Job Description

We are seeking a highly experienced and technically proficient Senior Developer to join our team at Citi. The successful candidate will play a critical role in designing, developing, and optimizing data-driven solutions using Oracle SQL/PL SQL and Python with PySpark. This role requires deep expertise in database programming, data processing, and an ability to work with large datasets within a financial services context.

Key Responsibilities

• Design, develop, and maintain complex Oracle SQL and PL/SQL packages, stored procedures, functions, and triggers for critical business applications.
• Develop and implement robust data processing pipelines using Python and PySpark for large-scale data ingestion, transformation, and analysis.
• Optimize existing SQL queries, PL/SQL code, and PySpark jobs for performance, scalability, and efficiency.
• Collaborate with data architects, data scientists, and business stakeholders to understand data requirements and translate them into technical solutions.
• Ensure data quality, integrity, and security across all developed solutions.
• Participate in all phases of the software development lifecycle, including requirements gathering, design, coding, testing, deployment, and support.
• Troubleshoot and resolve complex database and data pipeline-related issues.
• Provide technical guidance and mentorship to junior developers.
• Stay abreast of new technologies and best practices in Oracle database development, Python, and big data processing (Spark).

Qualifications

• Bachelor's or Master's degree in Computer Science, Engineering, Information Technology, or a related field.
• 10+ years of progressive experience in software development, with a strong focus on Oracle database development and data engineering.
• Proven experience as a Senior Developer in a large enterprise environment, preferably within financial services.
• Strong domain knowledge and experience on the functionality of Customer Due Diligence (CDD) or Know Your Customer (KYC) platforms.

Technical Skills

• Expert-level proficiency in Oracle SQL and PL/SQL, including performance tuning and advanced database concepts.
• Strong expertise in Python programming, particularly with PySpark for big data processing.
• Extensive experience with data warehousing concepts, ETL/ELT processes, and data modeling.
• Proficiency with version control systems (e.g., Git).
• Experience with scripting languages (e.g., Shell scripting) is a plus.
• Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and their data services is a strong advantage.
• Experience with job scheduling tools (e.g., Control-M, Airflow) is desirable.
• Knowledge of data governance and data quality best practices.
• Strong analytical and problem-solving skills.

------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Applications Development

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Most Relevant Skills

Please see the requirements listed above.

------------------------------------------------------

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

 

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.