Senior SQL & ETL Developer, Citi

Citi

Location:
Canada, Mississauga

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

94300.00 - 141500.00 USD / Year

Save Job

Apply Position

Job Description:

As an AVP, SQL & ETL Developer, you will play a critical role in the design, development, optimization, and maintenance of robust and scalable data solutions. This position requires deep expertise in SQL, database systems, and Extract, Transform, Load (ETL) processes, coupled with an understanding of data warehousing principles. Crucially, you must possess strong domain knowledge in banking, specifically related to liquidity management, stress modeling, and markets data, to effectively translate complex business requirements into data solutions.

Job Responsibility:

Design, develop, and optimize complex SQL queries, stored procedures, functions, and views for data extraction, transformation, and loading
Lead the design, development, and implementation of robust, scalable, and automated ETL processes
Develop and maintain data pipelines for ingesting data from diverse sources into target data warehouses or data marts
Apply strong understanding of data warehousing concepts (e.g., Kimball, Inmon methodologies), dimensional modeling, and OLAP principles
Lead small to medium-sized data development projects from inception to completion
Provide technical guidance and mentorship to junior developers
Diagnose and resolve complex data-related issues, including data discrepancies, performance bottlenecks, and ETL job failures
Collaborate effectively with cross-functional teams including business users, data analysts, data scientists, architects, and IT operations

Requirements:

5+ years of progressive experience in SQL development and ETL design/implementation
Must have significant experience in the banking or financial services domain
Demonstrated strong domain knowledge in one or more of the following areas: Liquidity Management, Stress Modeling, and Markets Data
Proven experience in leading data projects and/or mentoring junior team members
Experience working with large datasets and complex enterprise data architectures
Expert-level proficiency in SQL (e.g., T-SQL, PL/SQL, PostgreSQL, MySQL) with strong experience in query optimization, stored procedures, functions, and triggers
Extensive experience with at least one major ETL tool such as Informatica PowerCenter, Microsoft SSIS, IBM DataStage, Talend, or equivalent cloud-native ETL services
Strong understanding of data warehousing concepts and dimensional modeling
Experience with database management systems (e.g., SQL Server, Oracle, DB2, PostgreSQL)
Bachelor's degree/University degree or equivalent experience

Nice to have:

Experience with BigData technologies
Familiarity with scripting languages (e.g., Python, PowerShell) for automation
Knowledge of version control systems (e.g., Git) and SDLC methodologies (Agile/Scrum)
Experience with job scheduling tools (e.g., Autosys, Control-M)
Familiarity with cloud platforms (AWS, Azure, GCP) and their data services

Additional Information:

Job Posted:
September 18, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

Senior SQL & ETL Developer