Sr Data Engineer

Job summary

Design, develop, and deploy Informatica Cloud/IDMC integration and migration solutions, using SQL Server and Snowflake to support enterprise-scale data conversion, validation, and reconciliation. Support the migration of legacy worker documents into Workday EDM, including ingestion processes, monitoring, data quality, performance tuning, and technical documentation.

Job details

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

What you’ll do

Design, develop, and deploy Informatica Cloud/IDMC integration and migration solutions, using SQL Server and Snowflake to support enterprise-scale data conversion, validation, and reconciliation. Support the migration of legacy worker documents into Workday EDM, including ingestion processes, monitoring, data quality, performance tuning, and technical documentation.

Requirements

Requires 5–7+ years of data engineering experience, experience delivering enterprise-scale data migration programs, and strong hands-on expertise with Informatica Cloud/IDMC. Candidates should also have experience with Snowflake and Microsoft SQL Server; Workday EDM, ERP modernization, and legacy system decommissioning are preferred.

Listed skills

• Data Validation · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Informatica Cloud / IDMC
• Cloud Data Integration (CDI)
• Mass Ingestion
• Snowflake
• Microsoft SQL Server
• T-SQL
• ETL/ELT
• Data Migration
• Data Validation
• Data Reconciliation
• Data Profiling
• Metadata Analysis
• Data Modeling
• Query Optimization
• Performance Tuning
• Workday EDM

Job areas

• Data & Analytics
• Technology
• Software
• Manufacturing