Data Integration Engineer (PeopleSoft, Finance Data)
- Location
- New York, New York, United States
- Salary
- Not specified
- Company
- Akash pawar
Job description
Role & Company / Project Overview: We are seeking an experienced Data Integration Specialist with deep expertise in PeopleSoft and Finance Data to support a comprehensive Budget and Finance data migration from PeopleSoft to Workday for The City University of New York (CUNY). The specialist will collaborate with functional leads, Workday consultants, database administrators, and cybersecurity teams to ensure an accurate, secure, and seamless transition. Key Responsibilities & Daily Duties: • Develop, optimize, and execute comprehensive data extraction and transformation processes specifically for Budget and Finance modules. • Optimize complex SQL queries, PeopleSoft Application Engine programs, and SQR scripts. • Map PeopleSoft data fields to Workday equivalents, identify schema gaps, and resolve data inconsistencies. • Implement and maintain ETL tools, data migration pipelines, and post-migration validation checks. • Conduct extensive data reconciliation, data integrity testing, and post-load verification. • Prepare, standardize, and maintain detailed data conversion documentation, mapping sheets, and procedural runbooks. • Collaborate closely with functional stakeholders, Workday implementation consultants, database administrators, and cybersecurity teams to support enterprise identity management practices and data security. Required Qualifications, Skills & Experience: • 15+ years of overall Information Technology experience. • Minimum 84 months (7 years) of dedicated experience developing and executing data extraction and transformation processes for Budget and Finance. • Minimum 84 months (7 years) of experience optimizing SQL queries, PeopleSoft Application Engine, and SQR scripts. • Minimum 84 months (7 years) of experience mapping PeopleSoft data fields to Workday equivalents and troubleshooting discrepancies. • Minimum 84 months (7 years) of experience utilizing ETL tools and conducting post-migration data validation. • Minimum 84 months (7 years) of collaborative work alongside functional teams and Workday consultants. • Minimum 84 months (7 years) of preparing and managing technical data conversion documentation. • Minimum 84 months (7 years) of cross-functional collaboration with PeopleSoft, Workday, DBA, and cybersecurity teams supporting identity management practices. • Hands-on experience with PeopleSoft Financials and Budgeting modules (preferred). • Prior project experience in PeopleSoft-to-Workday financial data migrations (preferred). • Strong proficiency in PL/SQL, Application Engine, SQR, and enterprise ETL utilities. • Familiarity with Workday financial data models, structures, and integration patterns. • Knowledge of enterprise data governance, access controls, and security standards. Working Hours, Shifts & Location Details: • Location: New York, NY 10006. • Work Mode: 100% Remote. • Contract Duration: 12 Months (C2C). • Hours: 40 hours per week. • Interview Mode: Video interview. • Visa Eligibility: Any valid work authorization. Compensation & Benefits: • Competitive hourly contract / C2C rate. Application Instructions: • Interested candidates should submit their updated resume along with all required submission documentation.