Senior Data Engineer – Informatica / Workday
Location: Toronto, Ontario
Country: Canada
Category: ERP
Workplace Location: Remote
Employment Type: Contract
Posted Date: August 21, 2026
Job ID: 651131
Job Description
Senior Data Engineer - Informatica IDMC / Workday
Location: Canada-Based Remote | Toronto Preferred
Employment Type: Contract
Duration: 6 Months
Schedule: Full-Time, 40 Hours/Week
Start: ASAP
About the Opportunity
We're seeking a Senior Data Engineer with strong Informatica Cloud (IDMC/IICS) and Workday data extraction experience to support a large-scale enterprise data extraction and archival initiative.
This is a highly hands-on opportunity focused on extracting historical employee data, documents, attachments, metadata, and business-process history from a legacy Workday environment and loading it into a governed Oracle on-premises archive.
The project involves a complex, API-driven extraction process spanning numerous Workday endpoints and requires careful preservation of effective-dated history, object relationships, business-process history, and referential integrity.
What You'll Do
- Design, build, and operate data extraction and integration pipelines using Informatica Cloud (IDMC/IICS).
- Extract data from Workday using Web Services, RaaS, custom reports, and/or Workday connectors.
- Work across multiple Workday domains, including:
- Core HCM
- Payroll
- Time Tracking
- Benefits
- Compensation
- Learning
- Performance
- Recruiting
- Onboarding
- Business Process History
- Sequence and optimize API calls while implementing retries, logging, checkpointing, and restartability.
- Transform and load data into Oracle using a layered data architecture.
- Preserve keys, relationships, and referential integrity across complex Workday datasets.
- Ensure effective-dated history and point-in-time views can be accurately reconstructed.
- Develop data validation, reconciliation, and quality controls to verify completeness and accuracy.
- Support extraction of large volumes of historical documents and attachments.
- Implement appropriate security and compliance controls around sensitive employee data.
- Support dry runs, cutover readiness, defect resolution, hypercare, documentation, and knowledge transfer.
Required Qualifications
- Hands-on Informatica Cloud (IDMC/IICS) pipeline development experience.
- Strong practical Workday data extraction experience.
- Experience with Workday Web Services, RaaS, custom reports, and/or Workday connectors.
- Understanding of Workday's effective-dated data structures and object relationships.
- Strong SQL and relational data modeling experience.
- Experience loading data into Oracle, preferably an on-premises environment.
- Experience with data validation, reconciliation, and data quality engineering.
- Understanding of record-count reconciliation, primary/foreign key integrity, null checks, duplicate checks, and related controls.
- Experience working with sensitive or personal data and implementing appropriate security, access, and audit controls.
- Ability to work hands-on across extraction, transformation, loading, validation, and archival processes.
Preferred Qualifications
- Experience with the Informatica Workday connector.
- Experience supporting large-scale data migration or archival programs.
- Experience working with large volumes of documents and attachments.
- Experience preserving referential integrity across large enterprise datasets.
- Power BI or similar experience for validation dashboards and extraction reporting.
- Familiarity with HIPAA and/or PIPEDA requirements.
- Experience with encryption, RBAC, audit logging, retention, legal hold, and chain-of-custody controls.
- Familiarity with Workday IDMC/Workday Connector procurement and setup.
Why This Opportunity?
- Work on a technically complex, enterprise-scale data engineering and archival initiative.
- Gain hands-on experience across Informatica IDMC, Workday, Oracle, SQL, APIs, and data governance.
- Work with complex effective-dated Workday data and large volumes of historical employee information.
- Opportunity to contribute to a project where data accuracy, traceability, and preservation are critical.
Ideal Candidate
The ideal candidate is a hands-on Senior Data Engineer who can operate comfortably across the entire data pipeline--from Workday extraction and API orchestration through transformation, Oracle loading, validation, reconciliation, and archival.
Strong candidates will have particularly deep IDMC/IICS + Workday extraction experience and be comfortable working with complex enterprise data structures, sensitive employee information, and large-scale integration processes.
#LI-EM1
#TECH
EEO Statement
The staffing industry has seen an increase in people falsely representing themselves as recruiters to gather personal information from job seekers. For your safety, do not provide sensitive data to anyone you have not spoken with thoroughly, never provide banking information during the application process, and always double check the email address of the Recruiter to ensure it’s from an official Planet domain (@theplanetgroup.com or @launchcg.com) - and not a domain with an alternative extension like .net, .org, or .jobs.
The Planet Group and our companies are equal opportunity employers. It is our practice not to discriminate against any employee or applicant based on any criteria, condition or basis protected by laws or regulations in the locations where we do business. All qualified applicants are encouraged to apply. We celebrate diversity and are committed to providing an environment of mutual respect. We believe that diversity, equity, and inclusion enable us to better meet our mission and values while serving our clients across the globe. If you have a disability or handicap and would like us to accommodate you in any reasonable way, please inform your recruiter, or contact us, so that we can discuss the appropriate alternatives available.
Apply Now
Apply Via
Stay Up To Date With The Latest Jobs.
Similar Jobs
About The Planet Group
The Planet Group is a global professional services firm delivering strategic staffing and advisory solutions. We operate at the intersection of talent and transformation – connecting the right people with the right opportunities in the areas of technology, engineering, accounting & finance, digital marketing, and manufacturing.
As one of the largest staffing companies in the US, we operate with a global reach and a performance-first mindset. We partner with clients to move fast, stay agile, and drive measurable results – building high-impact teams that fuel transformation and growth.
