# AI SENSI

AI SENSI is a remote worker on Himalayas, Data Engineer – ETL & Data Management at Scotiabank, based in Canada.

Source: https://himalayas.app/@aisensi

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

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Canada |
| Authorized to work in | Canada |
| Salary expectations | 130k+ USD |
| Job categories | Data Engineer, ETL Developer, MDM Architect, Data Architect, Business Analyst |
| Skills | ETL, Data Engineering, Data Integration, Azure, Azure Databricks, Azure Data Factory, ADLS Gen2, Azure SQL Database, IBM DataStage, Informatica PowerCenter, Master Data Management (MDM), Dimensional Data Models, Data Profiling, Data Mapping, Data Quality |

## About

```text
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

### Data Engineer – ETL & Data Management

[Scotiabank](https://himalayas.app/companies/scotiabank). Jun 2025 - Aug 2026

```text
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.
```

Skills: SQL-Server, Azure-Data-Lake, PeopleSoft-ERP, Information-Analyzer, IBM-MDM, SQL, Jira

### MDM Architect / Data Engineer

Elections Canada. Mar 2024 - May 2025

```text
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.
```

Skills: Azure-Databricks, Azure-Data-Lake, SSIS, Azure-SQL, Data-Mapping, MDM, Gap-Analysis

### Azure Data Engineer / ETL Developer

Innovapost. Feb 2022 - Feb 2024

```text
Developed automated Azure Data Factory pipelines and Azure SQL solutions, integrating modern cloud capabilities into high-availability business applications. Maintained hybrid integration workflows spanning Azure Databricks, Azure Data Lake, and legacy IBM DataStage jobs.
```

Skills: Azure-Data-Factory, Azure-SQL, Azure-Databricks, Azure-Data-Lake, IBM-DataStage, Teradata, Scripting

### ETL Developer (SSIS/SSRS)

[EPAM Systems](https://himalayas.app/companies/epam-systems). Jun 2019 - Feb 2022

```text
Migrated complex enterprise data structures into modern data warehousing environments using IBM DataStage and conducted end-to-end performance validation. Configured Azure DevOps monitoring tools and evaluated technical data warehousing options.
```

Skills: IBM-DataStage, SSIS, SSRS, Azure-DevOps, Data-Warehouse, Performance-Validation

### ETL Specialist – Master Data Management

[IBM Canada](https://himalayas.app/companies/ibm-com). Oct 2018 - May 2019

```text
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.
```

Skills: IBM-DataStage, Kafka, SQL, ETL, Mentorship

### Senior Business Analyst / ETL Developer

Canada Revenue Agency. Jan 2017 - Sep 2018

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

Skills: IBM-DataStage, SQL, UNIX-Shell-Scripting, Batch-Scheduling

### ETL Developer

Adastra Consultancy

```text
Worked as an ETL Developer on an AML Compliance project.
```

Skills: ETL, AML-Compliance

### BI Specialist & Data Conversion

Export Development Canada

```text
Worked as a BI Specialist focusing on data conversion and business intelligence.
```

Skills: Business-Intelligence, Data-Conversion

### BI / Business Analyst

Royal Canadian Mounted Police

```text
Worked as a BI/Business Analyst with focus on DataStage and Identity Insight solutions.
```

Skills: IBM-DataStage, Identity-Insight, Business-Analysis

### BI Specialist

Loblaws

```text
Worked as a BI Specialist using Teradata utilities including FastLoad and MultiLoad.
```

Skills: Teradata, FASTLOAD, MultiLoad, Business-Intelligence

### BI Specialist / ETL Developer

[Rogers Communications](https://himalayas.app/companies/rogers-communications)

```text
Worked as a BI Specialist and ETL Developer using Informatica PowerCenter and PL/SQL.
```

Skills: Informatica-PowerCenter, Pl-SQL, Business-Intelligence, ETL

### BI Specialist / DataStage Developer

[Royal Bank of Canada](https://himalayas.app/companies/rbc)

```text
Worked as a BI Specialist and DataStage Developer.
```

Skills: IBM-DataStage, Business-Intelligence

### BI Specialist & Business Analyst

[Enerflex Systems](https://himalayas.app/companies/enerflex-ltd)

```text
Worked as a BI Specialist and Business Analyst with focus on SAP HR/ERP integration.
```

Skills: SAP-HR, SAP-ERP, Business-Analysis, Business-Intelligence

## Education

### Carleton University

Risk Management Program, Risk Management

```text
Completed a Risk Management Program at Carleton University.
```

### Intermediate University College

Diploma, Computer Science

```text
Earned a Diploma in Computer Science from Intermediate University College.
```

## Tech stack

- Microsoft Azure
- Azure DevOps
- Jira
- PowerShell
- Azure SQL Database
- SQL
- Informatica PowerCenter
- Apache Kafka

To contact AI, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Saisarwagna Biradavolu](https://himalayas.app/@saisarwagnabiradavol): Azure Data Engineer, Merkle Clouds
- [Ismail Yunus](https://himalayas.app/@ismailyunus): Data Engineer / Cloud Data Consultant, Alphadot
- [Subhadra Mukka](https://himalayas.app/@subhadramukka): Azure Data Engineer, TD Bank
- [Priyanka Verma](https://himalayas.app/@priyankaverma3): Azure Data Engineer, PwC Canada
- [Sai praneeth Boddupalli](https://himalayas.app/@saipraneethboddupall): Azure Data Engineer, Price Industries
- [Dharmil Patel](https://himalayas.app/@dharmilpatel): Senior Data Engineer, EY
- [Dmitro Mikhailenko](https://himalayas.app/@dmitromikhailenko): Senior DBA / Data Engineer, Ledcor Group
- [MANASWINI UYYALA](https://himalayas.app/@manaswiniuyyala): Senior Data Engineer, CIBC
- [OUSSAMA AMARA](https://himalayas.app/@oussamaamara): Matrix IDM Consultant, Bridge Consulting
- [Eyad Mustafa](https://himalayas.app/@eyadmustafa1): Data Engineer – ETL & Data Management, Scotiabank
