| 767150 |
Data Warehouse/BI Developer 4 |
Yakshna Solutions, Inc., (YSI) is a CMMI Level 3 assessed, ISO 9001, 20000:1, 27001 certified, woman-owned small business enterprises, headquartered in Herndon, Virginia, USA. YSI provides professional IT solutions and services to business corporations and government organizations. YSI is committed to serve its business communities as a leading IT vendor providing innovative, quality, and cost-effective IT business solutions and services.
We offer a competitive benefits package that includes the following: 401(k), health, dental, and vision insurance, Life insurance, short-term and long-term disability insurance, paid time off, training, and professional development assistance.
The Virginia Retirement Services is seeking an experienced ETL Developer to serve their Richmond Office. We are seeking an 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
Required skills 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
YSI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
|