IT Specialist BI ETL PDI SSIS Pentaho or Tableau Sybase ASE or SQL Server Star Schema

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.