Epicareer Might not Working Properly
Learn More

Need Data Warehouse/ETL/BI/API Developer in Mechanicsburg, PA - On-Site - Candidates must be located within the Greater Harrisburg/ Mechanicsburg/ Central PA Area

Salary undisclosed

Apply on


Original
Simplified

We have a Contract assignment available with our client in Harrisburg, PA.

Position: Data Warehouse/ETL/BI/API Developer

Location: Harrisburg, PA

Duration: 6+ Months

***Candidates must be located within the Greater Harrisburg/ Mechanicsburg/ Central PA Area to be considered for this position.***

Start date can be ID'd upon after compliant PATCH and DOC-related clearance has been processed and approved. ***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 badging.*** ***The interview process is- 1. Phone Interview 2. virtual via Teams 3. if needed, then onsite in-person.***
DOC is looking for a Data Warehouse, ETL, Business Intelligence Developer and API Developer staff augmentation resource.


(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.

Required/Desired Skills

Skill

Required / Desired

Amount

of Experience

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

Required

3

Years

Thanks & Regards,

Salveer Singh Pahade

Sarum LLC

p:

e:

w:

a:

68-60 Austin Str., STE. 403, Forest Hills, NY 11375

[https://]

While every effort was made to ensure this email was sent to its intended recipient, if you ve received it in error, please keep it confidential, let the sender know and delete the original and any copies. Disclosing, copying or sharing its contents is prohibited and may be unlawful. Thank you.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job