Data Warehouse Arch

Job Description

Job Location :   Chesterfield, VA(Hybrid)

Note :

Candidate will need to be experienced with Azure Data Factory Pipeline or SSIS packages for Sql Server environments.

Minimum 10 years of profile.

Job Description :

• Working with our business partners to develop data mapping from one system to another is required.
• As such the candidate will be expected to manage data mapping from a legacy system to a new system.
• The candidate will have a solid attention to detail and be able to manage tedious tasks.
• The candidate needs to be proficient with Azure Data Factory Pipelines and Sql Server stored procedures or SSIS packages.
• There may also be some work required to create or support packages on local servers as well.

Skill Matrix :

Requirements

Skills Set : Skill Required / Desired Experience Experience as a Business Analyst on PeopleSoft HCM on implementation or upgrade projects Required 8 years Experience with PeopleSoft HCM 9.2 Payroll or Time & Labor Required 8 years Experience as a Business Analyst in identifying requirements and creating formal functional documents for key business stakeholders and SMEs Required 8 years Experience as a Business Analyst in conducting formal work sessions and functional analysis presentations Required 8 years Experience in performing hands-on end-to-end system integration and external interface testing Required 8 years at least 4) Experience with Microsoft O365 applications (Word, Excel, PowerPoint, Teams, Visio) Required 8 years Experience working with a public sector organization (Federal, State, or Local Government) Required 4 years Experience working with the Comptroller of Public Accounts (CPA) CAPPS Financials Required 2 years Experience with PeopleSoft HCN 9.2 Payroll or Time & Labor Required 2 years Experience with PeopleSoft Approval Workflow Engine (AWE) Required 2 years Experience with SharePoint Required 2 years Experience with Jira Required 1 year Experience working with the Scrum framework Required 1 year