Opens LinkedIn
- Employment type
- Contract
- Experience level
- Senior · 5+ years
- Posting language
- English
- Working hours
- 40 hours per week
- Seniority
- Mid-Senior level
- Application method
- Apply on LinkedIn (LinkedIn sign-in required)
Job summary
Design, develop, and maintain ETL/ELT integrations using Informatica IDMC, including mappings, taskflows, and parameter-driven processes. Support data migration and modernization initiatives using Snowflake and SQL Server, including profiling, reconciliation, troubleshooting, and performance optimization.
Job details
🚀 WE'RE HIRING: SENIOR DATA ENGINEER! 🌎 Location: Canada – 100% Remote 💻 Tech Stack: Informatica IDMC | Snowflake | SQL Server | ETL/ELT 📊 Experience: 5–7+ Years Preferred Are you a Senior Data Engineer who thrives on solving complex data challenges? Do you have strong experience with Informatica Cloud (IDMC), Snowflake and SQL Server? Are you passionate about building reliable data pipelines, delivering complex data migrations and helping organizations modernize their data environments? 💡 The Opportunity Our client is seeking an experienced Senior Data Engineer with strong technical expertise in Informatica Intelligent Data Management Cloud (IDMC), Snowflake and Microsoft SQL Server. The role focuses on enterprise data integration, ETL/ELT development, data migration and optimization. We're looking for someone who combines strong hands-on engineering capabilities with experience delivering complex data solutions. 🔧 What You'll Be Working On ✅ Designing and developing ETL/ELT processes using Informatica Cloud (IDMC). ✅ Working with Informatica Cloud Data Integration (CDI), Mass Ingestion and Data Quality (DQ). ✅ Developing and maintaining mappings, taskflows and parameter-driven integration processes. ✅ Implementing effective error handling, monitoring and troubleshooting. ✅ Working with Snowflake and Microsoft SQL Server to support data integration and migration activities. ✅ Developing and optimizing SQL and T-SQL queries. ✅ Performing data profiling, reconciliation and metadata analysis. ✅ Supporting data modelling, query optimization and performance tuning. ✅ Contributing to enterprise-scale data migration and modernization initiatives. 🎯 What We're Looking For Core Technical Skills: 🔹 Informatica Cloud (IDMC) – Strong hands-on experience with Cloud Data Integration (CDI), Mass Ingestion, Data Quality, Mapping Designer and Taskflows. 🔹 Snowflake – Experience working with Snowflake in data engineering environments. 🔹 Microsoft SQL Server / T-SQL – Strong SQL development, optimization and database experience. 🔹 ETL / ELT – Experience designing, developing and maintaining data integration processes. 🔹 Data Migration – Experience supporting complex migration, reconciliation and validation activities. 🔹 Performance Optimization – Strong understanding of data modelling, query optimization and performance tuning. ⭐ Even Better If You Have... ✔️ 5–7+ years of professional data engineering experience. ✔️ Experience delivering enterprise-scale data migration programs. ✔️ Experience supporting Workday implementations, ERP modernization or legacy system decommissioning. ✔️ Experience working within Agile delivery environments. ✔️ Excellent stakeholder communication and technical documentation skills. 🌟 Why Consider This Opportunity? 🌎 100% Remote Across Canada – Work remotely while contributing to enterprise data engineering initiatives. 💻 Modern Data Technologies – Work with Informatica Cloud, Snowflake and SQL Server. 🚀 Complex Engineering Challenges – Apply your expertise to data integration, migration and modernization activities. 🤝 Collaborative Delivery – Bring your technical expertise and stakeholder communication skills to data engineering projects If you're an experienced Data Engineer with strong Informatica IDMC, Snowflake and SQL Server skills, we'd love to hear from you. 📩 Apply directly or send me a message to discuss the opportunity. Know someone who could be a great fit? Feel free to share this opportunity with your network!
What you’ll do
Design, develop, and maintain ETL/ELT integrations using Informatica IDMC, including mappings, taskflows, and parameter-driven processes. Support data migration and modernization initiatives using Snowflake and SQL Server, including profiling, reconciliation, troubleshooting, and performance optimization.
Requirements
The role seeks strong hands-on experience with Informatica IDMC, Snowflake, SQL Server/T-SQL, and ETL/ELT development, along with data migration and performance optimization expertise. Five to seven or more years of data engineering experience is preferred; enterprise migration, Workday or ERP modernization, Agile delivery, and strong communication and documentation skills are advantageous.
Listed skills
- SQL · Preferred
- Agile · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Informatica IDMC
- Cloud Data Integration
- Mass Ingestion
- Data Quality
- Snowflake
- Microsoft SQL Server
- SQL
- T-SQL
- ETL/ELT
- Data Migration
- Data Profiling
- Data Reconciliation
- Data Modeling
- Query Optimization
- Performance Tuning
- Agile
Job areas
- Data & Analytics
- Technology
- Software
- Engineering
More jobs from Focus on WD
Data Solution Architect
- Remote
- Canada
- Posted Oct 29, 2026
Senior Workday HCM Business Analyst (Functional)
- On-site
- Posted Oct 14, 2026
Workday Compensation Functional Lead
- On-site
- Posted Oct 14, 2026
Workday Compensation and Benefits Manager
- On-site
- Posted Oct 14, 2026
