Client Technology - ETL Developer

PowerToFly; Mississauga; Hybrid; CAD 128,000 - 193,000; Full time

Job summary

A leading financial services firm in Mississauga is seeking a highly skilled ETL Developer to design and deploy advanced ETL solutions. The ideal candidate will have 5+ years of experience in software engineering, particularly with PySpark and Python. This hybrid position emphasizes technical leadership and collaboration with cross-functional teams to deliver scalable solutions. Candidates with a finance industry background will be preferred. A full-time role offering competitive salary packages is available.

Qualifications

• 5+ years of software engineering experience with hands-on coding.
• Experience in the finance industry is a plus.
• Strong hands-on experience with developing ETL solutions.

Responsibilities

• Design, implement, and deploy highly scalable ETL solutions.
• Develop ETL jobs that can automate complex tasks.
• Stay abreast of the latest advancements in ETL domain.

Skills

ETL development

Python

PySpark

SQL

Data modeling

Containerization

BI tools

AI/ML frameworks

Education

Bachelor’s degree in computer science or related field

Tools

IBM DataStage

Talend

Apache Airflow

SSIS

Tableau

Docker

OpenShift

Kubernetes

Job description

We are seeking a highly skilled and pragmatic ETL Developer (Applications Development Sr Programmer Analyst - C12) to design, develop, and deploy advanced ETL solutions. This multifaceted role involves creating smart ETL solutions by understanding goals and executing tasks with minimal human intervention. The ideal candidate will possess a strong understanding of ETL principles, application data flows, database development and highly performant processing solutions. This hybrid position emphasizes technical leadership, focusing on rapid prototyping, iterative improvement, and delivering measurable business value by translating research ideas into robust, scalable production systems.

Responsibilities

• ETL Development: Design, implement, and deploy highly scalable ETL solutions, ensuring high performance, reliability, and security.
• Task Automation & Workflow Optimization: Develop ETL jobs that can automate complex tasks, optimize workflows, and solve real-world problems across various domains.
• Rapid Delivery: MVP first approach, iterative improvement approach with a focus on "time to value" (quick iterations, hypothesis testing, A/B experiments).
• Research and Innovation: Stay abreast of the latest advancements in ETL domain, actively participating in the development of proofs of concept (POCs) and exploring new methodologies.
• Collaboration & Leadership: Work closely with cross-functional teams to integrate with broader products and services.
• Documentation: Create comprehensive technical documentation for design, implementation, and operational procedures.
• 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.

Required Qualifications

• 5+ years of software engineering experience with hands‑on coding, with a track record of delivering quality solutions on time.
• Experience in the finance industry is a plus.
• Strong hands‑on experience with developing ETL solutions with PySpark and Python.
• Create ELT data pipeline, optimize Spark clusters on containerized environments.
• Strong database development skills with SQL, Stored Procedures and Data Modeling.
• Good knowledge of S3 bucket and/or NAS storage systems.
• ETL Tools: Development experience with one or more ETL tools such as IBM DataStage, Talend, Apache Airflow, SSIS, etc.,
• BI Tools: Experience with BI tools like Tableau, etc.,
• Containerization: Experience with OpenShift, Docker and Kubernetes.
• AI/ML: Experience with ML frameworks, LLMs, etc.

Education

• Bachelor’s degree/University degree in computer science or related field, or equivalent experience

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

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.

Automated Processing and AI Notice

This job opening is for an existing job vacancy.

Equal Opportunity Employer

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.