Company name
Mvp Consulting Plus, Inc.
Location
Albany, NY, United States
Employment Type
Contract
Industry
It, Sql
Posted on
Jun 14, 2023
Profile
HBITS-04-12811
Daily tasks will include: Gather and validate of BI and reporting requirements
Document requirements & solutions
Perform Data profiling on the source systems
Design and review star schema dimensional model to support data warehouse and data marts
Perform Source to Target Mapping between source system database and data warehouse target database
Develop ETL transformations using one of the ETL tools like Pentaho Data Integration (PDI), or SQL Server Integration Services (SSIS)
Develop reports and analytics using one of the tools like SQL Server Reporting Services (Pentaho or Tableau)
Develop complex queries using Transact-SQL leveraging analytic functions
Perform necessary Testing
Complete Documentation
IT Specialist
Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
Senior 60 - 84 months: Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education. 60 months experience in building extraction and transformation of transactional data to drive data warehouse loads and end user BI as well as reporting requirements using ETL tools like Pentaho Data Integration (PDI) or SQL Server Integration Services (SSIS)
60 months experience in reporting and analytics tools such as Pentaho or Tableau
60 months experience in complex SQL development leveraging analytics functions using in Sybase ASE or SQL Server
24 months experience in Pentaho Data Integration (PDI) development.
60 months experience in Star Schema / Dimensional Modeling to support data warehouse environmen
60 months experience in doing data profiling and source to target mappings.
60 months experience in internal and external stakeholder communications and outreach, including the development of presentations and other materials
Toll Free:
855-818-5109
Local:
518-218-1700
Map
& visit our office
Corporate - Albany NY
435 New Karner Rd, Ste 202
Albany NY 12205
Chicago
63E Lake Street, Ste 201
Chicago, IL 60601
Florida
17258 SE 121st Ave
Summerfield, FL 34491
© 2018 MVP Consulting Plus. All Rights Reserved.
Company info
Mvp Consulting Plus, Inc.