Informatica Data Engineer

MPA Recruitment; Toronto; Remote; CAD 110,000 - 124,000; Full time

Job summary

MPA Recruitment is seeking an Informatica Data Engineer for a 4-month remote contract. The role focuses on designing, building, and deploying IDMC-based data migration and integration solutions, using SQL Server and Snowflake for large-scale transformations.

The ideal candidate has 5-7+ years in data engineering, strong knowledge of IDMC/CDI, and experience with data migration programs within ERP modernization projects. Remote, contract-based engagement with Agile delivery expectations.

Qualifications

• Experience with Informatica Cloud (IDMC) and CDI.
• Proficient with Snowflake and SQL Server.
• Strong background in data migration and ETL/ELT design.

Responsibilities

• Design, develop, and deploy IDMC data migration and integration solutions.
• Leverage SQL Server and Snowflake for data conversion, validation, reconciliation.
• Support enterprise-scale migration efforts and Workday EDM-related initiatives.

Skills

Data engineering

Stakeholder communication

Agile methodologies

Education

5-7+ years of data engineering experience

Tools

Informatica Cloud IDMC

Cloud Data Integration

Mass Ingestion

Data Quality

Mapping Designer

Taskflows

Parameter Files

Error Handling & Monitoring

Snowflake

Microsoft SQL Server

T-SQL

Query Optimization

Data Modeling

ETL/ELT Design

Data Migration

Data Reconciliation

Data Profiling

Metadata Analysis

Performance Tuning

Job description

Informatica Data Engineer

4 month contract (remote)

$80-90/hour

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

Our client is undertaking a one-time migration of worker documents from its legacy SAP/OpenText repositories and the converted XFT files into the Workday Electronic Document Management (EDM) platform. This migration aims to replace fragmented legacy archives with a unified, compliant, and scalable enterprise document management solution within Workday. The services described herein reflect the mutually understood technical approach, integration patterns, metadata requirements, an ingestion processes defined in these discussions.

Required Skills:Informatica 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

• ETL / ELT Design
• Data Migration
• Data Reconciliation
• Data Profiling
• Metadata Analysis
• Performance Tuning

Preferred Experience

• Minimum 5-7+ years of data engineering experience.
• Experience delivering enterprise-scale migration programs.
• Experience supporting Workday, ERP modernization, or legacy system decommissioning initiatives.
• Familiarity with Agile delivery methodologies.
• Strong stakeholder communication and documentation skills