Senior Data Engineer - Informatica / Workday

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

#TECH