Job Title:
Workday HCM Consultant (Hybrid Onsite)
Location:
Richmond, VA
Duration:
10 Months
Pay Rate:
$70/hr on C2C / 1099 all inclusive (OR) $65/hr on W2
Interview Process:
In Person Only Locals preferred
Job Description
We are seeking an experienced ETL Developer to design, develop, and maintain robust data pipelines that move data from various sources to our data warehouse. You will work with a team of data engineers, analysts, and stakeholders to ensure data quality, transform complex datasets, and support our business intelligence efforts. The ideal candidate will have experience with ETL tools, data integration, and SQL, and will be passionate about building efficient and scalable data pipelines.
Key Responsibilities:
Work with VRS business unit personnel, and other stakeholders to extract data from legacy systems and transform it into a format compatible with Workday HCM.
Define and document the mapping of data fields between legacy systems and Workday's data structures.
Ensure the transformed data that is ready to be loaded into Workday is accurate, complete, and adheres to data quality standards through various validation techniques.
Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into the data warehouse.
Work closely with the data team to ensure data integrity, quality, and availability.
Monitor ETL pipelines for performance and troubleshoot any issues or bottlenecks.
Optimize data processing workflows to ensure scalability and efficiency.
Document ETL processes and maintain best practices for data integration.
Identify and resolve data-related issues that arise during the conversion process.
Maintain detailed documentation of data mapping, transformation rules, and validation procedures.
Develop and run test cases and scripts
Knowledge, Skills, and Abilities:
Strong understanding of Workday's data structures pertaining to HCM module.
Hands on knowledge on Data Extraction, Data Transformation, Data Loading, Workflow Development, Performance Tuning, Data Quality Assurance & Documentation and Collaboration.
Proven experience in working with ETL tools such as Informatica, Talend, or SSIS.
Strong knowledge of SQL for querying and manipulating data in databases.
Experience in data integration from various data sources, including structured and unstructured data.
Ability to troubleshoot and resolve performance issues in ETL pipelines.
Strong analytical skills and attention to detail to ensure data quality.
Ability to analyze data, identify issues, and validate data accuracy.
Working knowledge with the following tools and technologies:
ETL process design, development and support
ETL tools such as SSIS or equivalent
Database Design and Data Modelling
T-SQL statements and stored procedures
SSRS and SSAS
Designing and implementing extraction, transformation, and loading data pipelines
Investigating data to anticipate any pipeline issues
Managing the maintenance of software
Working closely with data analysts on the ETL process
Troubleshooting and debugging database issues
Facilitating and training staff on ETL processes at each level
Working with stakeholders and managers to understand business goals
Implementing and updating new software
Designing and implementing SQL queries
Providing customer reporting
Education and Experience:
Bachelor's degree in IT, Computer Science or closely related field
Total 6 (six) years' experience in data conversion/ETL projects with at least three (3) years in migrating data from legacy systems to Workday HCM.
Previous experience in migrations working with Kronos, Cornerstone, and Workday is a plus
Top Skills & Years of Experience
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
| Strong understanding of Workday's data structures pertaining to HCM module. | Desired | 6 | Years |
| Hands on knowledge on Data Extraction, Data Transformation, Data Loading, Workflow Development, Performance Tuning | Required | 6 | Years |
| Hands on knowledge on Data Quality Assurance & Documentation and Collaboration. | Required | 6 | Years |
| Proven experience in working with ETL tools such as Informatica, Talend, or SSIS. | Required | 6 | Years |
| Strong knowledge of SQL for querying and manipulating data in databases. | Required | 6 | Years |
| Experience in data integration from various data sources, including structured and unstructured data. | Required | 6 | Years |
| Ability to troubleshoot and resolve performance issues in ETL pipelines. | Required | 6 | Years |
| Strong analytical skills and attention to detail to ensure data quality. | Required | 6 | Years |
| Ability to analyze data, identify issues, and validate data accuracy. | Required | 6 | Years |
| Working knowledge with ETL process design, development and support | Required | 6 | Years |
| Working knowledge with ETL tools such as SSIS or equivalent | Required | 6 | Years |
| Working knowledge with Database Design and Data Modelling | Required | 6 | Years |
| T-SQL statements and stored procedures | Required | 6 | Years |
| Designing and implementing extraction, transformation, and loading data pipelines | Required | 6 | Years |
| Investigating data to anticipate any pipeline issues | Required | 6 | Years |
| Managing the maintenance of software | Required | 6 | Years |
| SSRS and SSAS | Required | 6 | Years |
| Working closely with data analysts on the ETL process | Required | 6 | Years |
| Troubleshooting and debugging database issues | Required | 6 | Years |
| Facilitating and training staff on ETL processes at each level | Required | 6 | Years |
| Working with stakeholders and managers to understand business goals | Required | 6 | Years |
| Implementing and updating new software | Required | 6 | Years |
| Designing and implementing SQL queries | Required | 6 | Years |
| Providing customer reporting | Required | 6 | Years |
| Bachelor's degree in IT, Computer Science or closely related field | Required | 6 | Years |
| Total 6 (six) years' experience in data conversion/ETL projects with at least three (3) years in migrating data from legacy systems to Workday HCM. | Required | 6 | Years |
| Previous experience in migrations working with Kronos, Cornerstone, and Workday is a plus | Desired | 6 | Years |
Recruiter Details:
Name : Karthikeya at gsksolutions dot com
Contact : Two eight one Three eight five Nine one one one
About US:
GSK Solutions Inc. is a premier information technology services company dedicated to delivering exceptional consulting solutions and staff augmentation to our valued clients. With an unwavering commitment to quality, timeliness, and budgetary considerations, we consistently strive to exceed client expectations, building a strong reputation through our reliable execution. Our expertise spans commercial and custom product development, covering information security, software development, consulting, and IT audits. We excel in managing critical, time-sensitive projects for Fortune 500 clients nationwide, ensuring their success is always at the forefront of our mission.
...Oversees inmates during transport and in their quarters, testifies in court and processes arrest/booking paperwork for detention and courts.... .... Follows office policy and procedure. Studies applicable Federal, State, and local laws and ordinances. Attends education...
...design principles to enhance the overall learning process. Additionally, they may conduct assessments to measure the effectiveness of training programs and continuously update content to align with educational goals and industry standards. Strong communication and project...
...The role of the Soccer Academy Coach is to develop U6-U12 youth soccer players at the YMCA of Central Texas in accordance with the mission, philosophy, and core values of our association. The Academy Coach is expected to deliver quality soccer guidance and education...
...Trade Advisory practice is a national practice within Deloitte Tax LLP's International Tax business and advises U.S. and foreign multinational... ...-locate in person 2 - 3 days per week + 3+ years relevant SAP consulting or industry experience+ Hands-on functional configuration and...
...Essel is seeking a skilled Journeyman Electrician to join our team. In this role, you will utilize your expertise to install, maintain, and repair electrical systems across a variety of projects. Your work will be critical in ensuring the safe and efficient operation...