Description

You will design, develop, and maintain data pipelines moving data from various sources into the data warehouse.

Responsibilities

• Extract data from legacy systems and transform it for compatibility with Workday HCM, collaborating with VRS business unit personnel.
• Define and document data field mappings between legacy systems and Workday data structures.
• Design, develop, and maintain ETL processes to extract, transform, and load data from multiple sources into the data warehouse.
• Monitor ETL pipelines for performance, troubleshooting bottlenecks and optimizing data processing workflows for efficiency.
• Maintain detailed documentation covering data mapping, transformation rules, and validation procedures.

Required Skills

• 6+ years of experience in data conversion/ETL projects, with at least 3 years migrating data from legacy systems to Workday HCM.
• Strong knowledge of SQL for database querying and manipulation, including T-SQL statements and stored procedures.
• Proven experience with ETL tools such as Informatica, Talend, or SSIS.
• Hands-on knowledge of Data Extraction, Data Transformation, Data Loading, and Data Quality Assurance.
• Strong understanding of Workday's data structures related to the HCM module.
• Experience in data integration from structured and unstructured sources.
• Familiarity with SSRS and SSAS for reporting.
• Ability to analyze data, identify issues, and validate data accuracy against defined standards.

Key Skills

Education

Any Graduate