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.