Talent.com
Astra North Infoteck Inc.
ETL DataStage DeveloperAstra North Infoteck Inc. • Toronto, Ontario, Canada
ETL DataStage Developer

ETL DataStage Developer

Astra North Infoteck Inc. • Toronto, Ontario, Canada
23 days ago
Job type
  • Full-time
  • Permanent
Job description

Role: ETL DataStage Developer


Location: Toronto ON - Hybrid; 2-3 days a week on-site
The ETL Developer will support the design development enhancement implementation and production support of AML data solutions within the Enterprise Data Lake (EDL). The role focuses on building and maintaining scalable data pipelines supporting AML platforms including Name Screening Customer Risk Rating (CRR) Transaction Monitoring (TM) and FINTRAC Regulatory Reporting.

Key Responsibilities
Design develop enhance and maintain ETL/Data Integration solutions using DataStage Python SQL/HQL and UNIX.
Develop and support AML data pipelines within the Enterprise Data Lake environment.
Implement source-to-target mappings and complex transformation logic.
Onboard new data sources and enhance existing AML data feeds.
Build and maintain batch processing frameworks workflows and scheduling processes.
Develop data cleansing standardization reconciliation and validation routines.
Support AML initiatives related to:
Name Screening (ACRM)
Customer Risk Rating (CRR)
Transaction Monitoring (TM)
FINTRAC Reporting
Enhance data quality controls monitoring and lineage solutions.
Perform code remediation performance tuning optimization and software currency upgrades.
Execute unit testing defect resolution and production deployment activities.
Investigate and resolve production incidents and data issues.
Perform root cause analysis and implement permanent fixes.
Support release activities post-implementation validation and on-call production support when required.
Maintain technical documentation ETL specifications and operational procedures.

Required Skills & Experience
6 years of ETL/Data Engineering experience.
Strong hands-on experience with:
IBM DataStage
Python
SQL/HQL
UNIX Shell Scripting
Experience working with Enterprise Data Warehouse/Data Lake platforms.
Strong data analysis and troubleshooting skills.
Experience developing complex ETL jobs data transformations and data integration solutions.
Knowledge of data quality reconciliation and data lineage concepts.
Experience with SDLC testing deployment and production support processes.
Ability to analyze and optimize ETL performance and data processing workflows.

Preferred Qualifications
Banking AML Financial Crime or Regulatory Reporting domain experience.
Experience supporting Name Screening CRR Transaction Monitoring or FINTRAC reporting platforms.
Familiarity with Hadoop/Hive ecosystems.
Knowledge of Data Governance and Regulatory Compliance requirements.
Experience in Agile delivery environments.

Key Technologies
IBM DataStage Python SQL/HQL UNIX Shell Scripting Hive Enterprise Data Lake (EDL) Data Quality Data Lineage AML KYC FINTRAC Transaction Monitoring Customer Risk





Employment Type : Full Time
Experience: years
Vacancy: 1
Create a job alert for this search

ETL DataStage Developer • Toronto, Ontario, Canada

Similar jobs

Senior ETL Developer - DataStage Focus

Apptoza Inc.Toronto, ON, CA
Full-time

We are on the lookout for a Senior ETL Developer with expertise in DataStage and Talend to lead our ETL initiatives.Enhance enterprise data integration and analytics through your skills.As a Senior... Show more

 • Promoted

Data Engineer

searchlabsmarkham, on, Canada
Full-time

This Data Engineer role is a one-year contract, working on a hybrid in-office/remote model in the GTA.The compensation range is $60-$100/hr.Build and maintain ETL pipelines for enterprise data inte... Show more

 • Promoted

Datastage Etl Developer (Contract) - $32.4 - $50.6 An Hour

CapgeminiNorth York, Canada
Full-time

Develop and maintain ETL pipelines using IBM InfoSphere DataStage, ensuring data quality and performance. Show more

 • Promoted

Experienced Data Engineer - Hybrid Model

searchlabsmarkham, on, Canada
Full-time

Take on a one-year contract as a Data Engineer with a hybrid work model in the Greater Toronto Area, focusing on data integration and pipeline management.Your advanced technical skills are crucial.... Show more

 • Promoted

ETL Developer - Informatica PowerCenter

Aviva CanadaMarkham, York Region, CA
Full-time

ETL Developer / Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.Join to apply for the ETL Deve... Show more

 • Promoted

ETL/Datastage Developer

ROSSToronto, ON, CA
Full-time

Our client is a boutique consulting firm that is currently working on a project with a large Telco company.They are looking to an ETL Developer with 5-7 years experience.This is a 10 week engagemen... Show more

 • Promoted

Datastage ETL Developer

United States Digital Space LLCToronto, Ontario, Canada
Full-time

We are hiring for a Datastage ETL Position.Location: Toronto (Hybrid-4 Days Onsite).ETL Tool: Expert knowledge of IBM Info Sphere DataStage.Database: Strong SQL skills for complex querying and data... Show more

 • Promoted

Senior ETL Developer - D365 & Azure Data (Hybrid)

Source CodeToronto, ON, CA
Full-time

A tech company in Toronto is seeking a Senior Software Developer specializing in ETL for Microsoft D365.The role involves significant hands-on experience in enterprise-level data integration and da... Show more

 • Promoted

Talend Lead Developer — ETL & Data Integration

Aarorn Technologies IncToronto, ON, CA
Full-time

A technology firm is seeking a highly skilled Talend Lead Developer in Toronto, ON to design and optimize ETL workflows.The successful candidate will lead data engineering initiatives, ensuring dat... Show more

 • Promoted

Lead Data Architect in Azure and Databricks

Adastra Corporationmarkham, on, Canada
Full-time

Become a pivotal Lead Data Architect focusing on Microsoft Azure and Databricks at Adastra Corporation.Spearhead innovative data and AI solutions in a hybrid setting.In this senior role, you will o... Show more

 • Promoted

Senior ETL Engineer – Databricks, Delta Lake, Hybrid

Rubicon PathToronto, ON, CA
Full-time

A leading technology firm in Toronto seeks a Software Developer - ETL to design and implement ETL processes using Azure Databricks.This role involves optimizing data flow for analytics and data lak... Show more

 • Promoted

Sr. Guidewire Lead developer

Coforgemarkham, on, Canada
Full-time

Guidewire cloud, policy, Billing, Integration.Guidewire Lead developer with following skillset.Commercial Insurance Expertise.Extensive experience in underwriting, policy lifecycle, rating, endorse... Show more

 • Promoted

Lead Data Product Owner

OpenTextrichmond hill, york region, Canada
Full-time

Opentext - The Information Company.OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture.As a member... Show more

 • Promoted

DataStage ETL Lead: Hands-On Data Integration

Compunnel, Inc.Toronto, ON, CA
Full-time

A data solutions provider in Toronto, Ontario is seeking a Data Dev Lead to oversee data development activities.The role focuses on hands-on work using IBM DataStage for ETL workflows, and requires... Show more

 • Promoted

ETL DataStage Developer

Apptoza Inc.Toronto
Full-time

We are looking for a skilled DataStage and Talend Developer responsible for designing, developing, and maintaining ETL processes to support enterprise data integration, data warehousing, and analyt... Show more

 • Promoted

Data Platform Analyst (Azure)

Amphenol Corporationmarkham, on, Canada
Full-time

Amphenol Communications Solutions (ACS), a division of Amphenol Corporation, is a world leader in interconnect solutions for Communications, Mobile, RF, Optics, and Commercial electronics markets.A... Show more

 • Promoted

Senior ETL Engineer - Azure Data Lakes, D365 (Hybrid)

Source CodeToronto, ON, CA
Temporary

A leading technology company is seeking a Sr.Software Developer - ETL to work in a hybrid model in Toronto, ON.The ideal candidate will have over 8 years of experience in data integration and ETL d... Show more

 • Promoted

Databricks Data Engineer - ETL Lead (Hybrid Toronto)

SPECTRAFORCEToronto, ON, CA
Full-time

A leading financial technology provider in Canada is seeking a Mid-Senior level professional to lead ETL development and manage a Databricks platform for Capital Markets.This role requires strong e... Show more

 • Promoted

Datastage ETL Expert - Toronto, Hybrid

United States Digital Space LLCToronto, ON, CA
Full-time

Unlock new opportunities as a Datastage ETL Expert in Toronto.Enjoy a hybrid work model while utilizing your extensive ETL knowledge and SQL expertise to optimize our data processes.We are currentl... Show more

 • Promoted

Senior Engineer - ETL Data for Autonomous Vehicles

Waabitoronto, on, Canada
Full-time

Lead advancements in self-driving technology with Waabi as a Senior Engineer focused on ETL data pipelines.This key role develops critical data infrastructure for autonomous vehicle mapping solutio... Show more