Client Technology - ETL Developer

Client Technology - ETL Developer Location: Mississauga Ontario Canada 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. Preferred Qualifications: 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. ------------------------------------------------------ This job opening is for an existing job vacancy. ------------------------------------------------------ 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.