ETL/Database 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

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