Senior Data Engineer – Informatica Cloud / IDMC & Snowflake

Location: Remote – Canada

Sector: Industrial / Manufacturing

About the Role

Our client is seeking an experienced Senior Data Engineer to support a major enterprise data migration and modernization initiative within the industrial/manufacturing sector.

The Senior Data Engineer will be responsible for designing, developing, and deploying Informatica Cloud (IDMC) data migration and integration solutions , leveraging Microsoft SQL Server and Snowflake to support large-scale data conversion, validation, reconciliation, and modernization activities.

The role will support the migration of worker documents from legacy SAP/OpenText repositories and converted XFT files into Workday Electronic Document Management (EDM) .

This initiative is focused on transitioning from fragmented legacy archives to a unified, compliant, and scalable enterprise document management solution within Workday.

Key Responsibilities The Senior Data Engineer will be responsible for:

- Designing, developing, and deploying Informatica Cloud / IDMC data integration and migration solutions.
- Developing and supporting ETL/ELT processes for large-scale enterprise data migration.
- Utilizing Informatica Cloud Data Integration (CDI) and Mass Ingestion capabilities.
- Developing mappings using Informatica Mapping Designer .
- Building and managing Taskflows and Parameter Files .
- Implementing effective error handling, monitoring, and data quality processes .
- Working with Microsoft SQL Server, T-SQL, and Snowflake throughout the migration lifecycle.
- Supporting large-scale data conversion, validation, and reconciliation activities.




- Performing data profiling and metadata analysis to understand source data and migration requirements.
- Supporting data modeling activities.
- Performing query optimization and performance tuning to support efficient processing.
- Supporting the migration and ingestion of legacy worker document data into Workday EDM .
- Contributing to the technical approach, integration patterns, metadata requirements, and ingestion processes required for the migration.
- Producing clear technical documentation and communicating effectively with project stakeholders.

Candidates should demonstrate strong hands-on experience with:

Informatica Cloud / IDMC

- Informatica Cloud / Intelligent Data Management Cloud (IDMC)
- Cloud Data Integration (CDI)
- Mass Ingestion
- Data Quality (DQ)
- Mapping Designer
- Taskflows
- Parameter Files
- Error Handling and Monitoring

Database Technologies

- Snowflake
- Microsoft SQL Server
- T-SQL
- Query Optimization
- Data Modeling

Data Engineering & Migration

- ETL / ELT Design
- Enterprise Data Migration
- Data Conversion
- Data Reconciliation
- Data Validation
- Data Profiling
- Metadata Analysis
- Performance Tuning

Experience

- 5–7+ years of Data Engineering experience.
- Experience delivering enterprise-scale data migration programs .
- Robust experience designing and developing data integration and migration solutions using Informatica Cloud / IDMC .
- Experience working with Snowflake and Microsoft SQL Server .

Preferred Experience

- Workday
- Workday Electronic Document Management (EDM)
- ERP modernization
- Legacy system decommissioning
- Large-scale enterprise migration initiatives

📌 Sr Data Engineer (Canada)
🏢 Focus on WD
📍 Canada