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

Design and operate data extraction pipelines using Informatica Cloud to migrate historical employee data from Workday to an Oracle archive. Ensure the preservation of referential integrity, effective-dated history, and security compliance for sensitive data.

Requires hands-on experience with Informatica IDMC/IICS and Workday data extraction via Web Services or RaaS. Proficiency in SQL, Oracle loading, and managing complex relational data structures is essential.

• SQLSouhaitée

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• Informatica IDMC
• Informatica IICS
• Workday Data Extraction
• Oracle Database
• SQL
• Relational Data Modeling
• Web Services
• RaaS
• Data Validation
• API Orchestration
• Data Archival
• Data Governance

• Data & Analytics
• Technology
• Software
• Engineering
• Consulting

Expérience minimale

5+ ans

Postuler avant le

12 mars 2027

Langue de l’offre

anglais

Heures de travail

40 heures par semaine

Niveau d’expérience

Mid-Senior level

Mode de candidature

La candidature directe est offerte