Python (Ab Initio) Engineer

Citigroup Inc.; Mississauga; On-site; CAD 132,000 - 197,000; Full time

Job summary

Citigroup Inc. is seeking an Applications Development Senior Programmer Analyst to contribute to complex data processing and analysis, leveraging Oracle PL/SQL, Python, Spark, and ETL frameworks.

You will collaborate with technology teams to design, implement, and optimize data-driven applications. The role emphasizes hands-on coding, data integration, reconciliation, and operational tooling, with mentorship of junior engineers and a focus on performance, reliability, and adherence to Citi's

Qualifications

• 4+ years of Oracle PL/SQL development using Java/Python/Spark/Kafka/Ab Initio ETL.
• Experience with shell scripting for large-scale data processing.
• Strong Oracle Database knowledge and data housekeeping.
• Understanding of data architecture and data infrastructure.
• Hands-on Python in ETL applications.
• Proficiency with PL/SQL, SQL, and performance tuning.
• Unix knowledge.
• Experience with data conversion/migration.
• Excellent debugging and troubleshooting skills.
• Experience with coding standards, testing, and debugging.
• Ability to mentor junior engineers.
• Strong analytical and problem-solving skills.
• Strong communication and collaboration with stakeholders.
• Knowledge of risk assessment, data security, performance and scalability.
• Exposure to Tableau or MicroStrategy.

Responsibilities

• Lead design, development, and implementation of data processing scripts using Oracle PL/SQL and Python.
• Integrate ETL frameworks and Spark-based solutions into data infrastructure.
• Design, build, and operate robust batch data processing.
• Develop data reconciliation workflows post ETL loads.
• Create reusable ingestion, transformation, and testing patterns.
• Build Python-based utilities for data loads.
• Provide technical leadership and mentor junior engineers.
• Write and tune complex SQL with optimization and CDC patterns.
• Implement data validation, auditability, and monitoring for SLAs.
• Contribute to system architecture and data contracts.
• Collaborate with application teams, architects, and analytics users.
• Participate in release planning and production support.
• Resolve high-impact problems through analysis of processes.
• Drive compliance with laws and Citigroup policies.

Skills

Data processing

SQL tuning

Analytical thinking

Mentoring

Leadership

Communication

Education

Bachelor's degree in Computer Science or related field

Master’s degree preferred

Tools

Oracle

PL/SQL

Python

Spark

Kafka

Ab Initio

Unix Shell

ETL

Tableau

MicroStrategy

Job description

The Applications Development Senior Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.

Responsibilities

• Lead the design, development, and implementation of complex Data processing and analysis script using Oracle PL SQL programming, Python scripting , Unix Shell Scripting ,etc. for processing large datasets, leveraging expertise in distributed computing and data manipulation.
• Partner with management teams to seamlessly integrate with ETL Framework & Spark-based solutions into existing data infrastructure, ensuring optimal performance .
• Data integration delivery: Design, build, and operate robust batch process
• Create Reconciliation process to validate data post ETL batch data load process : Develop and optimize workflows using smart automated data reconciliation
• Create reusable patterns for ingestion, transformation, and automation data testing
• Good to have knowledge to build Python engineering: Build Python-based utilities and frameworks for data loads,
• Expert in automation, validation, reconciliation, and operational tooling.
• SQL excellence: Write and tune complex SQL (query optimization, indexing strategy awareness, incremental loads, CDC patterns, and performance troubleshooting).
• Data quality and controls: Implement validation rules, error handling, auditability, and reconciliation controls; create monitoring/alerting to meet SLAs
• Architecture and design: Contribute to system architecture and integration design decisions (data contracts, schemas, versioning, resiliency).
• Collaboration: Work closely with different workstream of application teams, enterprise architects, and analytics consumers to align on data definitions and delivery priorities.
• Operational ownership: Participate in release planning, production support, incident triage, and continuous improvement to enhance reliability and reduce run-time cost.
• Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
• Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
• Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
• Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
• Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
• Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications

• 4+ years of extensive professional experience in Oracle PL SQL program development using Java/Python/Spark/Kafka/Abinitio ETL technologies and Oracle as database.
• Proven experience with shell scripting for large-scale data processing and distributed computing.
• Thorough knowledge and hands-on experience with Oracle Database and Database housekeeping activities.
• Strong understanding of data architecture principles and data infrastructure.
• Good to have hands on Experience on Python in developing complex ETL applications.
• Proficiency with Oracle PL/SQL or SQL, SQL tuning, writing packages, triggers, functions and procedures.
• Expert in UNIX knowledge
• Experience with data conversion / migration
• Excellent trouble shooting and debugging skills.
• Experience with developing and maintaining coding standards, testing, and debugging for complex applications.
• Demonstrated ability to provide technical leadership and mentor junior engineers.
• Excellent analytical, problem-solving, and critical thinking skills.
• Strong communication and collaboration abilities, with experience partnering with various stakeholders.
• Knowledge of risk assessment, data security, performance optimization, and scalability considerations.
• Good to have exposure and hands on reporting tools like Tableau, Micro strategy, etc.

Education

• Bachelor's degree in Computer Science, Engineering, or a related field.
• Master’s degree preferred

Job Family Group

Technology

Job Family

Applications Development

Time Type

Full time

Primary Location Full Time Salary Range

$94,300.00 - $141,500.00

Most Relevant Skills

Please see the requirements listed above.

Other Relevant Skills

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

Automated Processing and AI

We use automated processing, including artificial intelligence, for our legitimate business interests (or our reasonable and appropriate business purposes) to identify and align the candidate's skills and abilities with a specific job opening. Additionally, if you so choose, or consent, we can match your skills and abilities to other suitable roles at Citi.

Importantly, all our hiring processes and decisions, including determining your suitability for a role, are conducted, checked, and decided by individuals. Our automated processing and AI do not involve relying on automatic or autonomous decision-making. Please refer to any Jurisdictional Considerations, with specific provisions for your country (where relevant) for further details.

This job opening is for an existing job vacancy.

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.