Senior Data Engineer – Informatica / Workday
Location: Indianapolis, Indiana
Country: United States
Category: ERP
Workplace Location: Remote
Employment Type: Contract
Posted Date: August 20, 2026
Job ID: 651131
Job Description
Job Details: Senior Data Engineer - Informatica IDMC / Workday
We are seeking a hands-on Senior Data Engineer with strong Informatica Cloud (IDMC/IICS) and Workday experience to design, build, and operate data pipelines that extract employee data, documents, and metadata from a legacy Workday environment and load it into a governed Oracle on-premises archive.
The consultant will build extraction pipelines using Informatica IDMC and Workday connectors across multiple Workday domains, including Core HCM, Payroll, Time Tracking, Benefits, Compensation, Learning, Performance, Recruiting, Onboarding, and Business Process History.
The role will involve sequencing and optimizing API calls across Workday Web Services, RaaS, and custom reports, while implementing retries, logging, checkpointing, and reconciliation mechanisms to ensure resilient and restartable extraction.
The consultant will model and load data into Oracle across a layered architecture while preserving keys and referential integrity across worker, position, organization, compensation, payroll, and benefits objects.
A key responsibility will be preserving effective-dated history and point-in-time views so employee lifecycle, compensation, organizational, payroll, and benefits changes can be reconstructed accurately.
The consultant will implement validation, reconciliation, and data-quality controls to demonstrate completeness, accuracy, and traceability against the source Workday environment.
The role will also involve applying security and compliance controls for sensitive employee data, including encryption in transit and at rest, RBAC/SSO, retention, legal hold, audit logging, and chain-of-custody requirements.
The consultant will support cutover readiness and hypercare, including dry runs, defect resolution, documentation, and knowledge transfer to operational teams.
Must Have Requirements- Hands-on Informatica Cloud (IDMC/IICS) pipeline development experience.
- Strong practical Workday data extraction experience using Web Services, RaaS, custom reports, and/or Workday connectors.
- Understanding of Workday's non-relational, effective-dated data structures and object relationships.
- Strong SQL and relational data modeling experience.
- Experience loading data into Oracle, preferably in an on-premises environment.
- Experience with data validation, reconciliation, and data-quality engineering, including record-count reconciliation, PK/FK integrity, null checks, and duplicate checks.
- Experience working with sensitive/personal data and implementing appropriate security, access, and audit controls.
- Ability to work hands-on across data extraction, transformation, loading, validation, and archival processes.
- Experience specifically with the Informatica Workday connector.
- Experience with large-scale migration or archival programs.
- Experience handling 100K+ documents or similarly large volumes of attachments.
- Experience preserving referential integrity across large enterprise datasets.
- Power BI or equivalent experience for validation dashboards and extraction summaries.
- 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 considerations.
Midsize International Consulting Partner
Reasons to Work Here- Opportunity to work on a technically complex, enterprise-scale data engineering and archival initiative.
- Hands-on experience across Informatica IDMC, Workday, Oracle, SQL, APIs, and data governance.
- Opportunity to work with complex effective-dated Workday data and large volumes of historical employee information and documents.
Start: ASAP
Interview: Video call, 1-2 round
Duration: 6 months
Schedule: 40 hours/week, full time
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.
