ETL/Data Warehouse Developer

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

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

Required/Desired Experience:

• 6 years of Strong understanding of Workday's data structures pertaining to HCM module Desired
• 6 years of Hands on knowledge on Data Extraction, Data Transformation, Data Loading, Workflow Development, Performance Tuning Required
• 6 years of Hands on knowledge on Data Quality Assurance & Documentation and Collaboration Required
• 6 years of Proven experience in working with ETL tools such as Informatica, Talend, or SSIS Required
• 6 years of Strong knowledge of SQL for querying and manipulating data in databases Required
• 6 years of Experience in data integration from various data sources, including structured and unstructured data Required
• 6 years of Ability to troubleshoot and resolve performance issues in ETL pipelines Required
• 6 years of Strong analytical skills and attention to detail to ensure data quality Required
• 6 years of Ability to analyze data, identify issues, and validate data accuracy Required
• 6 years of Working knowledge with ETL process design, development and support Required
• 6 years of Working knowledge with ETL tools such as SSIS or equivalent Required
• 6 years of Working knowledge with Database Design and Data Modelling Required
• 6 years of T-SQL statements and stored procedures Required
• 6 years of Designing and implementing extraction, transformation, and loading data pipelines Required
• 6 years of Investigating data to anticipate any pipeline issues Required
• 6 years of Managing the maintenance of software Required
• 6 years of SSRS and SSAS Required
• 6 years of Working closely with data analysts on the ETL process Required
• 6 years of Troubleshooting and debugging database issues Required
• 6 years of Facilitating and training staff on ETL processes at each level Required
• 6 years of Working with stakeholders and managers to understand business goals Required
• 6 years of Implementing and updating new software Required
• 6 years of Designing and implementing SQL queries Required
• 6 years of Providing customer reporting Required
• 6 years of Bachelor’s degree in IT, Computer Science or closely related field Required
• 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 of Previous experience in migrations working with Kronos, Cornerstone, and Workday is a plus Desired

About Vector:
Vector Consulting, Inc., (Headquartered in Atlanta) is an IT Talent Acquisition Solutions firm committed to delivering results. Since our founding in 1990, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value. Our continuing growth has been and continues to be built around successful relationships that are based on our organization's operating philosophy and commitment to ** People, Partnerships, Purpose and Performance - THE VECTOR WAY