Data Warehouse/BI Developer 4

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 40 week(s)

Skills

SQL

Job Details

Data Warehouse/BI Developer 4
Primary Location: Richmond, Virginia

Hybrid position

V-Soft Consulting is currently hiring for a Data Warehouse/BI Developer 4 for our premier client in Richmond, Virginia.

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.
  • 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.

WHAT YOULL DO:
Job Responsibilities:
  • 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.
  • Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into the data warehouse.
  • 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.
  • Develop and run test cases and scripts.
  • 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.
  • 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.

Interested?
Qualified candidates should send their resumes to mkasoju@vsoftconsulting.com

V-Soft Consulting Group is recognized among the top 100 fastest growing staffing companies in North America, V-Soft Consulting Group is headquartered in Louisville, KY with strategic locations in India, Canada and the U.S. V-Soft is known as an agile, innovative technology services company holding several awards and distinctions and has a wide variety of partnerships across diverse technology stacks.

As a valued V-Soft Consultant, youre eligible for full benefits (Medical, Dental, Vision), a 401(k) plan, competitive compensation and more. V-Soft is partnered with numerous Fortune 500 companies, exceptionally positioned to advance your career growth.

V-Soft Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

For more information or to view all our open jobs, please visit www.vsoftconsulting.com or call (844) 425-8425.

#LI-MK2
#INDSP
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.