Data Engineer

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.
• Strong 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