Skip to main content
AI SENSIAS
Looking for a job

AI SENSI

@aisensi

Data Engineer at Scotiabank who engineered ETL pipelines for PeopleSoft HR data and modernized enterprise data systems on Azure.

Canada
Message

At Scotiabank, I engineered ETL pipelines that moved complex PeopleSoft human resources data into a centralized data hub, using SQL Server and Azure Data Lake. I also improved data profiling and standardization ahead of integration into IBM MDM.

At Elections Canada, I architected Azure data pipelines and designed data mappings and MDM standards to guide engineering teams. At Innovapost, I developed Azure Data Factory pipelines and maintained hybrid workflows connecting cloud services with IBM DataStage.

Across banking, government, telecom, and retail organizations, I’ve worked on enterprise ETL and data integration, including migrations from legacy platforms to cloud environments. My toolkit includes Azure Databricks, Azure Data Factory, IBM DataStage, and Informatica PowerCenter; I hold a Databricks Certified Data Engineer Associate certification.

Experience

Work history, roles, and key accomplishments

Scotiabank logoSC

Data Engineer – ETL & Data Management

Jun 2025 - Aug 2026 (1 year 2 months)

Engineered robust ETL pipelines using SQL Server and Azure Data Lake to extract, cleanse, and transform complex human resources data from enterprise PeopleSoft ERP systems into a centralized data hub. Optimized data quality processes using IBM InfoSphere Information Analyzer and architected a standardized SQL code repository.

Elections Canada logoEC

MDM Architect / Data Engineer

Elections Canada

Mar 2024 - May 2025 (1 year 2 months)

Architected cloud-native Azure data pipelines and managed the end-to-end Azure resource lifecycle. Constructed scalable data movement workflows using Azure Databricks, Azure Data Lake, and SSIS, and established enterprise Master Data Management standards.

IBM Canada logoIC

ETL Specialist – Master Data Management

Oct 2018 - May 2019 (7 months)

Designed a real-time IBM DataStage solution to ingest streaming data from Apache Kafka queues, powering downstream demographic and address pipelines. Mentored junior developers on enterprise ETL engineering patterns and SQL scripting.

Canada Revenue Agency logoCA

Senior Business Analyst / ETL Developer

Canada Revenue Agency

Jan 2017 - Sep 2018 (1 year 8 months)

Automated complex IBM DataStage sequences driven by custom-tuned SQL against target ADW tables, utilizing Unix Shell Scripting to schedule batch executions.

Adastra Consultancy logoAC

ETL Developer

Adastra Consultancy

Worked as an ETL Developer on an AML Compliance project.

Education

Degrees, certifications, and relevant coursework

Carleton University logoCU

Carleton University

Risk Management Program, Risk Management

Completed a Risk Management Program at Carleton University.

IC

Intermediate University College

Diploma, Computer Science

Earned a Diploma in Computer Science from Intermediate University College.

Interested in hiring AI?

You can contact AI and 90k+ other talented remote workers on Himalayas.

Message AI

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan