Workday HCM Consultant

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 Workdays 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 Workdays 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:

• Bachelors 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 Workdays 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

Bachelors 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 :

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.