Job added in hotlist
Applied job
Contract job
90-day-old-job
part-time-job
Recruiter job
Employer job
Expanded search
Apply online not available
View more jobs in Albany, NY
View more jobs in New York

Job Details

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

Company name
Mvp Consulting Plus, Inc.

Location
Albany, NY, United States

Employment Type
Contract

Industry
It, Sql

Posted on
Jun 14, 2023

Apply for this job






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.

Similar Jobs:
HBITS-04-12752 Daily tasks will include: Participate on teams for projects that have a Web functional component. Prepare size and scope analysis and timeline documentation. Analyze and document business requirements by partic...
Senior SQL Developer (100% Remote)
Location : Albany, NY
Description If you have a desire to make a difference and have a 'real' impact, we want to talk to you! The Senior Software Engineer codes software applications based on business requirements. The Senior Software Engineer work a...
EmploymentCrossing was helpful in getting me a job. Interview calls started flowing in from day one and I got my dream offer soon after.
Jeremy E - Greenville, NC
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
SQLCrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
SQLCrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2024 SQLCrossing - All rights reserved. 21 192