Senior ETL & Data Integration Engineer

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

Job summary

Citigroup Inc. seeks an Applications Development Senior Programmer Analyst in Mississauga to contribute to the design, development, and deployment of data-intensive applications in collaboration with the Technology team.

The role emphasizes Oracle PL/SQL, Python, Spark, and ETL frameworks, with a focus on data quality, automation, and operational tooling, while mentoring junior engineers and aligning with architects for scalable solutions.

Qualifications

• 4+ years of Oracle PL SQL program development with Java/Python/Spark/Kafka/ETL.
• Shell scripting experience for large-scale data processing.
• Hands-on Oracle Database and data infrastructure knowledge.
• Strong understanding of data architecture principles.
• Experience with Python in ETL applications.
• Proficiency with Oracle PL/SQL/SQL and tuning.
• UNIX knowledge and data migration experience.
• Excellent debugging and problem-solving skills.
• Experience mentoring junior engineers.
• Strong communication and collaboration abilities.

Responsibilities

• Lead design, development, and implementation of data processing scripts.
• Integrate ETL framework and Spark-based solutions into data infrastructure.
• Design, build, and operate robust batch processes.
• Develop reconciliation and automated testing workflows.
• Create reusable patterns for data ingestion, transformation, and testing.
• Collaborate with stakeholders and enterprise architects on data definitions.

Skills

Oracle PL/SQL

Python

UNIX Shell Scripting

Data Processing

Analytical Thinking

Mentoring

Education

Bachelor's degree in Computer Science or related field

Master's degree preferred

Tools

Spark

Kafka

ETL Frameworks

Tableau

SQL Tuning

Ab Initio ETL

Job description

Citigroup Inc. seeks an Applications Development Senior Programmer Analyst in Mississauga to contribute to the design, development, and deployment of data-intensive applications in collaboration with the Technology team.

The role emphasizes Oracle PL/SQL, Python, Spark, and ETL frameworks, with a focus on data quality, automation, and operational tooling, while mentoring junior engineers and aligning with architects for scalable solutions.