Data WarehouseETLBIAPI Developer
Data WarehouseETLBIAPI Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Hello
Hope you are doing well
Job: DOC SAR2 A4 SC3 (Data Warehouse/ETL/BI/API Developer)
Location : Harrisburg Pa
Client : State of PA
Duration: Long Term
Where does your candidate currently reside Please provide city and state. ***Candidates must be located within the Greater Harrisburg/ Mechanicsburg/ Central PA Area to be considered for this position.***
The interview process is 1. Phone Interview (in the candidates summary of qualifications did you include the phone number) 2. virtual via Teams (in the candidates summary of qualifications did you include the email address) 3. if needed then onsite inperson.***
DOC is looking for a Data Warehouse ETL Business Intelligence Developer and API Developer staff augmentation resource.
Start date can be IDd upon after compliant PATCH and DOCrelated clearance has been processed and approved.
***This requisitions PO is funded through 6/30/25 so use that date in the RTR. Contract end date is dependent on the final schedule and projected needs. Historically additional funding should then last a year and occur from 7/1/256/30/26.***
***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 commonwealthissued equipment and possibly do badging.***
***The interview process is 1. Phone Interview 2. virtual via Teams 3. if needed then onsite inperson.***
(1) Optimize develop and maintain integration solutions using SQL Server SSIS and ETL Framework (BIDS) as necessary to connect legacy data stores the data warehouse
(2) Develops maintains and optimizes al effort related to Data Warehouse (SSIS Stored procedures Views etc.)
(3) Creates data warehouse components using best practices methodologies
(4) Builds and maintains through documentation of the data and how it is moved through layers
(5) Perform data conversion from OLTP to DW using tools like SSIS/Data Factory
(6) Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
(7) Ensure the stabilization and high performance of existing ETL processes
(8) Troubleshoot and complex data related issues as well as provide support to production
(9) Develop and deploy ETL job workflow with reliable error/exception handling and rollback
(10) Must have experience working on SSRS
(11) Power BI experience is preferred
(12) Experience with Crystal Report will be beneficial
(13) API Development experience is preffered
(14) May be involved with manual testing
(15) Perform other related duties as required
4 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
Thanks & Regards.
Manikanta Yerra
Technical Recruiter
1601 N Harrison Ave STE # 2B Pierre SD 57501
Email:
Our thoughts hold the power to build bend or break our circumstances.
Certified Minority Business Enterprise (MBE)
An EVerify Company
DISCLAIMER: The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review retransmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error please contact the sender and delete the material from any computer or if you want to be REMOVED please reply with REMOVE in the Subject line of this email.
Employment Type
Full Time
