ETL Developer

3 weeks ago

Schenectady, United States VGroup Inc Full time
Job DescriptionJob DescriptionClient: State of New York
Job Title: ETL Developer
Duration: 30 Months
Start Date: ASAP
Location: 500A Balltown Road, Schenectady, NY, 12304 (Hybrid)
Position Type: Contract
Interview Type: Webcam Interview
Ceipal ID: SNY_ETL558_VH
Requirement ID: HBITS-06-13558
Information Technology Services (ITS)
Description
This position is with the ITS CTO Business Solutions HHS team and will be responsible for the design and development of a large multi-level system that will ETL (extract, transform and load) from an external OLAP database to an internal system.
Responsibilities:
  • Use Microsoft Visual Studio to create and maintain SSIS packages and projects.
  • Extract data from various sources, such as databases, spreadsheets, flat files, or APIs.
  • Create and maintain database stored procedures and functions.
  • Contribute to the design of a data warehouse architecture that supports data storage, retrieval, and analysis.
  • Optimize query performance by creating indexes.
  • Diagnose and troubleshoot various rules, calculations, and data issues on application reports using Crystal Reports.
  • Report status of current tasks and outstanding issues to supervisor.
Required/Desired/Highly desired Skills:
  • 84 months ETL (Extract, Transform, and Load) experience creating SQL Server SSIS objects
  • 84 months SQL Server Programming; views, stored procedures, and functions.
  • 60 months of experience with Data Warehousing.
  • 60 months experience with OLAP (On-line Analytical Processing).
V Group Inc. is an IT Services company which supplies IT staffing, project management, and delivery services in software, network, help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: AR, CA, DE, FL, GA, IL, KY, MD, ME, MI, NC, NJ, NY, OH, OR, PA, SC, TX, VA, and WA. If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.

Please share my contact information with others working in Information Technology.

Website: www.vgroupinc.com
LinkedIn: www.linkedin.com/company/v-group/
Facebook: www.facebook.com/VGroupIT
Twitter: www.twitter.com/vgroupinc

  • Data Integration Specialist

    2 weeks ago

    Schenectady, New York, United States Brandon Consulting Associates, Inc. Full time

    Job Description**Job Summary**Brandon Consulting Associates, Inc. is seeking a highly skilled Data Integration Specialist to join our team. As a key member of our data analytics team, you will be responsible for designing and developing a large-scale data integration system that extracts, transforms, and loads data from external OLAP databases to our...