CrawlJobs Logo
Citi Logo Citi · IT - Software Development

ETL Engineer

Canada, Mississauga 120800.00 - 170800.00 USD / Year · Job Posted March 01, 2026
Apply Position
Job Link Share

Job Description

Accounting Technology team is seeking a Applications Development Technology Lead Analyst with strong experience in ETL development using AbINITIO, Shell Scripting and Databases. This is a senior level position responsible for establishing and implementing new or modernize existing application systems. The overall objective of this role is to lead applications systems analysis and programming activities related to Finance and Accounting Systems.

Job Responsibility

  • Lead architecture design, development of ETL Solutions using ABINITIO
  • Review Code, Conduct design walkthroughs and ensure adherence to enterprise standards
  • Drive performance tuning, optimization across ETL workflows and databases
  • Design & Develop complex ABINITIO graphs, plans and reusable components
  • Drive CI/CD implementation for ETL deployments and drive automation, DevOps best practices in data engineering
  • Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
  • 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

Requirements

  • 6+ years of relevant experience in Apps Development using ETL tools - AbInitio, Shell Scripting, Databases
  • Strong knowledge of ETL standards, frameworks and best practices
  • Extensive experience system analysis and in programming of software applications preferably in the Finance Domain
  • Experience in managing and implementing successful projects
  • Subject Matter Expert (SME) in at least one area of Applications Development
  • Ability to adjust priorities quickly as circumstances dictate
  • Demonstrated leadership and project management skills
  • Consistently demonstrates clear and concise written and verbal communication
  • Bachelor’s degree/University degree or equivalent experience
  • Master’s degree preferred
Citi - All Job Offers

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Suggested Tags: Frontend Developer Secretary Talent Manager Salesforce Administrator Data Analyst
Similar Jobs for

ETL Engineer

8 matching positions

ETL Engineer

The Applications Development Intermediate Programmer Analyst is an intermediate ...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2-5 years of relevant experience in the Financial Service industry
  • Intermediate level experience in Applications Development role
  • Consistently demonstrates clear and concise written and verbal communication
  • Demonstrated problem-solving and decision-making skills
  • Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements
  • Bachelor's degree/University degree or equivalent experience
  • 5+ years of relevant experience as a data engineer
  • Data Pipelining & ETL: Expertise in designing and implementing scalable data pipelines using Python/Pyspark, with experience in ETL tools (e.g., Microsoft BI/SSIS, IBM DataStage etc.)
  • Database Management: Advanced proficiency (3+ years) in RDBMS (T-SQL/PL/SQL) and NoSQL (e.g., MongoDB)
  • Big Data Platforms: Extensive experience (3+ years) with Hadoop ecosystem technologies (e.g., HDFS, Hive, Pig, Sqoop), preferably Cloudera
Job Responsibility
Job Responsibility
  • Utilize knowledge of applications development procedures and concepts, and basic knowledge of other technical areas to identify and define necessary system enhancements, including using script tools and analyzing/interpreting code
  • Consult with users, clients, and other technology groups on issues, and recommend programming solutions, install, and support customer exposure systems
  • Apply fundamental knowledge of programming languages for design specifications
  • Analyze applications to identify vulnerabilities and security issues, as well as conduct testing and debugging
  • Serve as advisor or coach to new or lower level analysts
  • Identify problems, analyze information, and make evaluative judgements to recommend and implement solutions
  • Resolve issues by identifying and selecting solutions through the applications of acquired technical experience and guided by precedents
  • Has the ability to operate with a limited level of direct supervision
  • Can exercise independence of judgement and autonomy
  • Acts as SME to senior stakeholders and /or other team members
  • Fulltime
Read More
Arrow Right

ETL Engineer

We’re looking for a Data Engineer with a solid foundation in building robust dat...
Location
Location
United States , Cambridge
Salary
Salary:
115000.00 - 130000.00 USD / Year
https://www.kayak.com/ Logo
KAYAK
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of professional experience in data engineering
  • Proficient in SQL and Python, and know how to write scalable, maintainable code
  • Worked with AI coding tools and are excited about how they’re shaping the future of development
  • Understand modern data architecture from ingestion to transformation to delivery
  • Built and operated Airflow pipelines (or something similar)
  • You’re comfortable estimating project scope, managing timelines, and delivering reliably
Job Responsibility
Job Responsibility
  • Design, build, and maintain high-performance data pipelines and orchestration workflows
  • Write clean, modular Python code to transform, parse, clean, and enrich large datasets
  • Support stakeholders by developing dashboards and visualizations
  • Partner closely with marketing analysts, engineers, and data scientists to define and deliver data needs
  • Actively participate in agile ceremonies, code reviews, and planning discussions
  • Experiment with and use AI coding tools to boost productivity and code quality
What we offer
What we offer
  • health benefits
  • flexible spending account
  • retirement benefits
  • life insurance
  • paid time off (including PTO, paid sick leave, medical leave, bereavement leave, floating holidays and paid holidays)
  • parental leave benefits
  • annual bonus eligibility
  • Fulltime
Read More
Arrow Right

Etl App Development Engineer - Ab Initio Staff Engineer

We are looking for a skilled Data Engineer with strong experience in Ab Initio, ...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong hands-on experience with Ab Initio (ETL development)
  • Good proficiency in SQL (intermediate to advanced level)
  • Experience with scripting (Unix/Shell preferred)
  • Solid understanding of ETL concepts and data warehousing principles
Job Responsibility
Job Responsibility
  • Design, develop, and maintain ETL solutions using Ab Initio
  • Build and optimize complex SQL queries for data transformation and analysis
  • Develop automation and support scripts using Unix/Shell or other scripting languages
  • Perform data validation, performance tuning, and troubleshooting of ETL workflows
  • Work with tools such as EME, Co-Op, ACE, BRE, Express IT/Query IT, and Control Center
  • Collaborate with stakeholders to understand data requirements and deliver scalable solutions
  • Adhere to best practices for data quality, performance, and security
  • Fulltime
Read More
Arrow Right

Lead QA Engineer (ETL)

Location
Location
India , Gurugram
Salary
Salary:
Not provided
spectramedix.com Logo
SpectraMedix
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum 8 years of experience working in Database testing and SQL scripting
  • Strong experience in creating complex SQL queries and query optimizations
  • Design, create and execute test cases for ETL and DB testing processes, covering data extraction, transformation, and loading
  • Experience in validating data reconciliation scripts for volume data validation in ETL and Data integration testing
  • Experience in SQL Query Automation
  • Experience in leading and managing teams
  • Experience on version control tools
  • Strong problem-solving and analytical skills
Job Responsibility
Job Responsibility
  • Understand ETL source-to-target mapping documents and prepare QA documents and related artifacts accordingly
  • Create test data for new features, data platform upgrades, and business requirements
  • Mentor the team and help them understand business requirements
  • Develop SQL scripts based on defined business rules
  • Work closely with Data Platform, product, and business teams to complete back-end validations as part of QA delivery
  • Create ETL, database validation, and other QA scripts in the offshore team, and coordinate with the onshore team to ensure execution and reporting are shared with business leads
  • Automate existing and newly developed SQL scripts during the product development and implementation lifecycle
  • Perform data and portal testing in both UAT and production environments
  • Fulltime
Read More
Arrow Right

Offshore ETL Engineer

The Data Engineer is responsible for the implementation of Python-based extract/...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 3–6 years of experience in data engineering or ETL/ELT development
  • Working knowledge of Python for data processing
  • Strong SQL skills
  • Hands-on or foundational experience with dbt
  • Familiarity with data warehouses and batch processing concepts
  • Experience working in offshore delivery teams
Job Responsibility
Job Responsibility
  • Develop Python scripts to extract data from source systems and load it into the target warehouse
  • Implement dbt models based on approved transformation designs and patterns
  • Write basic dbt tests and SQL validation queries
  • Support data reconciliation and defect resolution activities
  • Participate in SIT and UAT support cycles
  • Maintain clear and consistent documentation for developed pipelines and models
  • Collaborate with Senior Data Engineers and Technical Leads to clarify requirements and resolve issues
  • Fulltime
Read More
Arrow Right

Senior SQL / ETL Engineer

We are seeking a Senior SQL / ETL Engineer to support data migration, transforma...
Location
Location
Mexico
Salary
Salary:
Not provided
techholding.co Logo
Tech Holding
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong hands-on SQL development experience
  • Experience working with SQL Server environments
  • Advanced SQL query writing and optimization experience
  • Experience developing and maintaining stored procedures
  • Experience with ETL processes and data migration activities
  • Strong experience with data manipulation, cleanup, and transformation
  • Experience loading and validating data within relational database environments
  • Ability to troubleshoot and resolve data-related issues independently
  • Strong attention to detail and data accuracy
  • Excellent communication and collaboration skills
Job Responsibility
Job Responsibility
  • Develop, maintain, and optimize SQL queries, stored procedures, and database scripts
  • Load, transform, and validate large datasets within SQL Server environments
  • Support ETL-related workflows, including data extraction, transformation, cleansing, and migration activities
  • Perform data cleanup and manipulation tasks to improve overall data quality and consistency
  • Troubleshoot SQL performance issues and optimize complex queries
  • Collaborate with engineering and business stakeholders to understand data requirements and deliver accurate solutions
  • Assist with ongoing database maintenance and operational support activities
  • Ensure data integrity, validation, and reconciliation across systems
  • Create and maintain technical documentation related to database and ETL processes
Read More
Arrow Right

Senior Sql / Etl Engineer

We are seeking a Senior SQL / ETL Engineer, for a project based assignment, to s...
Location
Location
United States
Salary
Salary:
Not provided
techholding.co Logo
Tech Holding
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong hands-on SQL development experience
  • Experience working with SQL Server environments
  • Advanced SQL query writing and optimization experience
  • Experience developing and maintaining stored procedures
  • Experience with ETL processes and data migration activities
  • Strong experience with data manipulation, cleanup, and transformation
  • Experience loading and validating data within relational database environments
  • Ability to troubleshoot and resolve data-related issues independently
  • Strong attention to detail and data accuracy
  • Excellent communication and collaboration skills
Job Responsibility
Job Responsibility
  • Develop, maintain, and optimize SQL queries, stored procedures, and database scripts
  • Load, transform, and validate large datasets within SQL Server environments
  • Support ETL-related workflows, including data extraction, transformation, cleansing, and migration activities
  • Perform data cleanup and manipulation tasks to improve overall data quality and consistency
  • Troubleshoot SQL performance issues and optimize complex queries
  • Collaborate with engineering and business stakeholders to understand data requirements and deliver accurate solutions
  • Assist with ongoing database maintenance and operational support activities
  • Ensure data integrity, validation, and reconciliation across systems
  • Create and maintain technical documentation related to database and ETL processes
Read More
Arrow Right

Matillion ETL Engineer

Location
Location
United States , Austin
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 3+ years of professional experience in Data Engineering, ETL development, or a related role
  • Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field
  • Hands‑on experience with: Matillion ETL, Snowflake, AWS, Tableau (from a data modeling / data engineering perspective)
  • Experience building and maintaining ETL pipelines in a cloud data warehouse environment
  • Comfortable working with raw data, evolving schemas, and imperfect source systems
  • Basic understanding of data modeling concepts for analytics use cases
  • Exposure to cloud or data platform migrations
Job Responsibility
Job Responsibility
  • Build and maintain end‑to‑end ETL pipelines using Matillion to extract data from source systems, transform data (clean, join, aggregate), and load into Snowflake
  • Refactor existing pipelines to improve performance, reliability, and readability
  • Clean and standardize inconsistent or raw data from multiple sources
  • Redesign and improve data models to support Tableau reporting and analytics consumption (not a BI development role)
  • Partner with analytics and reporting teams to ensure data models are performant, intuitive, and accurate
  • Support ongoing data quality initiatives and pipeline monitoring
  • Assist with cloud‑based data initiatives, including exposure to data and platform migrations
  • Document ETL logic, data models, and pipeline processes as needed
What we offer
What we offer
  • medical, vision, dental, and life and disability insurance
  • enrollment in company 401(k) plan
  • Fulltime
Read More
Arrow Right