Greeting!
My name is Rahul, and I am an Sr. Recruiter at Pentangle Tech Services. Pentangle Tech Services is a global contingency staffing firm service. we have an excellent job opportunity with one of our clients.
Role: Data Warehouse/BI Developer
Location: Richmond, VA (Hybrid)
Type: Contract
Note : Need Local Profile Only
Job Description:
Short Description-
Hybrid work location - Consultants will be required to work on site 2-3 days per week.
Full Job Description -
Essential Duties and Responsibilities:
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 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
- Knowledge, Skills, and Abilities:
· 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
· 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:
· 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
- Skills Matrix -
Skill Required / Desired Amount of Experience
Strong understanding of Workday's 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
Bachelor's 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
Questionnaires -
Question 1 Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment?
Question 2 Please list the candidate's email address.
Question 3 What city and state is your consultant currently located in?
Question 4 Is your candidate able to interview in person and work on site 2-3 days per week in Richmond VA?
Thanks & Regards
| | Rahul Sondhiya Lead Recruiter Pentangle Tech Services LLC |
Email: Rahul.sondhiya@pentangletech.com
LinkedIn URL: linkedin.com/in/rahul-sondhiya-51837340
Website: www.pentangletech.com
Address: 32969 Hamilton Court Suite 203, Farmington Hills, MI 48334
| | Pentangle Tech Services is one of the diversely growing Engineering Services firms in the region, providing services across Recruitment, Recruitment Process Outsourcing, Engineering Training, Projects Implementation and Talent Management to top-tier organizations looking for mid to senior level professionals. |
Address: 32969 Hamilton Court Suite 203, Farmington Hills, MI 48334.
Disclaimer: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited. Email transmission cannot be guaranteed to be secure or error-free, as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender, therefore, does not accept liability for any errors, omissions, or contaminations in the contents of this message which might have occurred as a result of email transmission.
No comments:
Post a Comment
Thanks
Gigagiglet
gigagiglet.blogspot.com