Epicareer Might not Working Properly
Learn More

ETL/ Data Warehouse Developer

Salary undisclosed

Apply on


Original
Simplified

Our government client is looking for an experienced ETL/ Data Warehouse Developer on a hybrid 12+ months renewable contract role in Mechanicsburg, PA.

Position- ETL/ Data Warehouse Developer

Role and Responsibilities:
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 analyze 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

Required/Desired Skills and Experience:

  • 4 year college degree or equivalent technical study with advanced study Required
  • 6 years of ETL experience (Including SSIS or other ETL tools) Required
  • 6 years of Data Analytics experience Required
  • 6 years of Data Warehouse knowledge and experience Required
  • 4 years of MS SQL Reporting Server (SSRS) Required
  • 3 years of Power BI Required
  • 3 years of Web API development experience Required

About Vector:
Vector Consulting, Inc., (Headquartered in Atlanta) is an IT Talent Acquisition Solutions firm committed to delivering results. Since our founding in 1990, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value. Our continuing growth has been and continues to be built around successful relationships that are based on our organization's operating philosophy and commitment to ** People, Partnerships, Purpose and Performance - THE VECTOR WAY

Celebrating 30 years of service.

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