Data Warehouse Developer

Client: State of PennsylvaniaJob Title: Data Warehouse DeveloperDuration: 12+ MonthsStart Date: ASAPLocation: 1920 Technology Parkway, Mechanicsburg, PA 17050 (Hybrid)Position Type: ContractInterview Type: In person/Telephonic/WebcamCeipal ID: SPA_DATA363_VHRequirement ID: DOC - SAR2 A4 SC3 (Data Warehouse/ETL/BI/API Developer)(749363)This position is hybrid (one day onsite (1920 Technology Parkway, Mechanicsburg, PA 17050) for now but it can change to more days).The resource is expected to go onsite to get commonwealth-issued equipment and possibly do badgingThe interview process is- 1. Phone Interview 2. virtual via Teams 3. if needed, then onsite in-person.DescriptionDOC is looking for a Data Warehouse, ETL, Business Intelligence Developer and API Developer staff augmentation resource.ResponsibilitiesOptimize, develop and maintain integration solutions using SQL Server SSIS and ETL Framework (BIDS) as necessary to connect legacy data stores, the data warehouseDevelops, maintains and optimizes al effort related to Data Warehouse (SSIS, Stored procedures, Views etc.)Creates data warehouse components using best practices methodologiesBuilds and maintains through documentation of the data and how it is moved through layersPerform data conversion from OLTP to DW using tools like SSIS/Data FactoryIdentify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrityEnsure the stabilization and high performance of existing ETL processesTroubleshoot and complex data related issues as well as provide support to productionDevelop and deploy ETL job workflow with reliable error/exception handling and rollbackMust have experience working on SSRSPower BI experience is preferredExperience with Crystal Report will be beneficialAPI Development experience is prefferedMay be involved with manual testingPerform other related duties as required.Required Skills4-year college degree or equivalent technical study with advanced study (Required)ETL experience (Including SSIS or other ETL tools) (Required 6 Years)Data Analytics experience (Required 6 Years)Data Warehouse knowledge and experience (Required 6 Years)MS SQL Reporting Server (SSRS) (Required 4 Years)Power BI (Required 3 Years)Web API development experience (Required 3 Years)V Group Inc. is an IT Services company which supplies IT staffing, project management, and delivery services in software, network, help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: AR, CA, DE, FL, GA, IL, KY, MD, ME, MI, NC, NJ, NY, OH, OR, PA, SC, TX, VA, and WA. If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.Please share my contact information with others working in Information Technology.Website: www.vgroupinc.comLinkedIn: www.linkedin.com/company/v-group/Facebook: www.facebook.com/VGroupITTwitter: www.twitter.com/vgroupinc