Client Technology - ETL Developer

Citi • Mississauga, ON

53d • Hybrid

About The Position

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.

Requirements

• 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.

Nice To Haves

• 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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level