IT Specialist BI ETL PD SSIS Pentaho or Tableau Sybase ASE or SQL Server

Profile

HBITS-04-12801

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.

Expert 84 months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. 84 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)

84 months experience in reporting and analytics tools such as Pentaho or Tableau

84 months experience in complex SQL development leveraging analytics functions using in Sybase ASE or SQL Server

48 months experience in Pentaho Data Integration (PDI) development.

60 months experience in Star Schema / Dimensional Modeling to support data warehouse environmen

84 months experience in doing data profiling and source to target mappings.

84 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.