DOC - SAR2 A4 SC3 Data WarehouseETLBIAPI Developer
DOC - SAR2 A4 SC3 Data WarehouseETLBIAPI Developer
Posted on :
20-10-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
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/NA/NA 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/NA6/NA/26.***
Start date can be IDd upon after compliant PATCH and DOCrelated clearance has been processed and approved.
***This requisitions PO is funded through 6/NA/NA 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/NA6/NA/26.***
***This position is hybrid (one day onsite (1NA0 Technology Parkway Mechanicsburg PA 1NA50) for now but it can change to moredays).***
***The resourceis 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
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
