Workday Studio Integration Consultant – Payroll Data Validation at DRC Systems

Only W2 (No H1B No OPT No C2C No 1099) Job Title: Workday Studio Integration Consultant Payroll Data Validation (12 yrs) Location: Remote Must-Have Skills: Workday Studio integration development (SFTP connectors XSLT transformations document handling) High-volume payroll data validation (datasets in the millions) Experience working within Workday Studio runtime limitations for large datasets Nice-to-Have Skills: ADP payroll file structures & change file formats ServiceNow integration for automated ticket creation Life sciences / pharmaceutical industry experience Role Overview: Seeking a highly experienced Workday Studio Integration Consultant to build a data validation utility supporting ADP Workday Prism payroll history reconciliation. This role ensures accuracy and completeness of historical payroll data loaded into Workday Prism Analytics. Primary Responsibilities: Develop a Workday Studio based validation utility to retrieve ADP change files via SFTP and perform in-memory comparison against Wage Type Validation Reports. Implement comparison logic across Pay Group wage type and amount hierarchies to detect source-target discrepancies. Generate discrepancy reports and configure alerts/notifications for validation failures. Design the utility without staging tables leveraging efficient in-memory processing within Studio runtime constraints. Support Phase 2 enhancements such as automated ServiceNow ticket generation and routing discrepancies to appropriate HR/Payroll resolution teams. Collaborate closely with IT and HR/Payroll teams for issue resolution and ADP coordination. Required Qualifications: 10 years of experience with Workday integrations specifically Workday Studio. Strong hands-on expertise with SFTP connectors XSLT transformations document handling. Understanding of Workday Prism Analytics data loading and publishing. Proven ability to validate and process large-scale payroll datasets. Familiarity with ADP payroll structures and change file formats. Ability to design high-performance solutions within the 4-hour Studio runtime window. Preferred Qualifications: Experience with ADP-to-Workday migrations. Exposure to ServiceNow integrations and automated workflows. Industry experience in life sciences or pharmaceuticals. Key Skills Children Activity,Change Management,API,Front Office Management,Information Technology Sales,Airlines Employment Type : Full Time Experience: years Vacancy: 1