Senior ETL & Data Integration Engineer

Citigroup; Mississauga; On-site; CAD 90,000 - 130,000; Full time

Job summary

Citigroup in Mississauga, Canada seeks an Applications Development Senior Programmer Analyst to contribute to applications systems analysis and programming. You will lead data processing script design using Oracle PL/SQL, Python, and Unix Shell scripting, and integrate with Spark-based ETL frameworks.

Responsibilities include data reconciliation, workflow automation, SQL tuning, and collaboration with architects and analytics teams to ensure data quality and scalable delivery.

Qualifications

• 4+ years of professional experience in Oracle PL/SQL development with Java/Python/Spark/Kafka/Ab Initio ETL tech and Oracle DB.
• Shell scripting for large-scale data processing and distributed computing experience.
• Thorough knowledge of Oracle Database and housekeeping activities.

Responsibilities

• Lead the design, development, and implementation of complex data processing scripts using Oracle PL/SQL, Python, and Unix Shell Scripting for large datasets.
• Collaborate with management to integrate with ETL frameworks and Spark-based solutions into data infrastructure.
• Design, build, and operate robust batch processes and data reconciliation workflows post ETL loads.
• Create reusable patterns for data ingestion, transformation, and automated testing.
• Mentor junior engineers and ensure coding standards align with architecture.

Skills

Oracle PL/SQL

Python scripting

Unix Shell Scripting

ETL Frameworks

Spark

SQL tuning

Data quality

Data architecture

Leadership

Education

Bachelor's in CS/Engineering

Master's degree preferred

Tools

Tableau

MicroStrategy

Kafka

Ab Initio

Job description

Citigroup in Mississauga, Canada seeks an Applications Development Senior Programmer Analyst to contribute to applications systems analysis and programming. You will lead data processing script design using Oracle PL/SQL, Python, and Unix Shell scripting, and integrate with Spark-based ETL frameworks.

Responsibilities include data reconciliation, workflow automation, SQL tuning, and collaboration with architects and analytics teams to ensure data quality and scalable delivery.