Hello Professional,
Greetings,
Need a ETL Developer Local to Pennsylvania only.
Position: DOC – SAR2 A4 SC3 (Data Warehouse/ETL/BI/API Developer)
Location: 1920 Technology Parkway, Mechanicsburg, PA 17050 (Hybrid)
Client: Commonwealth of PA
Agency: DOC
Interview Type: Webcam then in person
Position ID: 749363
Job Description:
- Optimize, develop and maintain integration solutions using SQL Server SSIS and ETL Framework (BIDS) as necessary to connect legacy data stores, the data warehouse
- Develops, maintains and optimizes al effort related to Data Warehouse (SSIS, Stored procedures, Views etc.)
- Creates data warehouse components using best practices methodologies
- Builds and maintains through documentation of the data and how it is moved through layers
- Perform data conversion from OLTP to DW using tools like SSIS/Data Factory
- Identify and analyse data discrepancies and data quality issues and work to ensure data consistency and integrity
- Ensure the stabilization and high performance of existing ETL processes
- Troubleshoot and complex data related issues as well as provide support to production
- Develop and deploy ETL job workflow with reliable error/exception handling and rollback
- Must have experience working on SSRS
- Power BI experience is preferred
- Experience with Crystal Report will be beneficial
- API Development experience is preferred
- May be involved with manual testing
- Perform other related duties as required
SKILL MATRIX: –
|
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
|
|
|
Data Analytics experience
|
Required
|
|
|
Data Warehouse knowledge and experience
|
Required
|
|
|
MS SQL Reporting Server (SSRS)
|
Required
|
|
|
Power BI
|
Required
|
|
|
Web API development experience
|
Required
|
|
Regards,
Himanshu Shukla
Recruitment Associate
Flairsoft Limited
CMMi and ISO 9001 Certified
Office : 614-888-0700 Ext-245
Fax: 614-573-7255
www.flairsoft.net
We Deliver. You Succeed.
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