Sr.Pentaho ETL Consultant Job at Interon IT Solutions, Albany, NY

ekNGaWhRNEpWZnY5cDJkZlhCaE1uL0dpQkE9PQ==
  • Interon IT Solutions
  • Albany, NY

Job Description

Role: Sr. Pentaho ETL Consultant

Location: Albany, New York

Duration: 30 Months

  • 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 the ETL tools like Pentaho Data Integration (PDI), or SQL Server Integration Services (SSIS)
  • Develop reports and analytics using the tools like SQL Server Reporting Services (Pentaho or Tableau, Power BI)
  • Develop complex queries using Transact-SQL leveraging analytic functions
  • Perform necessary Testing
  • 10.Complete Documentation

Mandatory Requirements

  • Experience (12+ Years)
  • 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.

Requirements

  • 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 environments
  • 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

Job Tags

Similar Jobs

AccentCare

Home Health Occupational Therapist Job at AccentCare

 ...Job Description AccentCare is seeking a Home Health Occupational Therapist for a job in San Antonio, Texas. Job Description & Requirements...  ...minimal supervision Must be a licensed driver who can travel to all business locations Come As You Are At AccentCare,... 

RPI Philadelphia

Entry Level Recruiter & Human Resources Assistant - College Grads! Job at RPI Philadelphia

 ...Rocksteady Promotions is currently seeking an energetic, forward-thinking, and passionate team player to join our Recruiting & Human Resources team. As a Recruiting Interviewer and Human Resources Assistant, you will actively receive full training and apply new skill... 

V R Della Infotech Inc

Sterile Processing - Sterile Processing Technician Job at V R Della Infotech Inc

Mon-Fri 3:00p-11:30p Travel/ Local Rate- BR/BR CRCST - Cert Reg Central Service Tech or CSPDT - Cert Sterile Proc & Dist Tech 1 year experience

MARS Solutions Group

Travel Surgical Technologist - $2,320 per week Job at MARS Solutions Group

 ...reduction of fractures* Laser Safety* Pressure Ulcer Prevention* Assembly/Wrap* Endoscopes* Flexible Endoscope Reprocessing*...  ...industry. Benefits Employee assistance programs Continuing Education Medical benefits Dental benefits Vision benefits... 

Broad River Rehabilitation

Physical Therapist Assistant / PTA / PRN Job at Broad River Rehabilitation

Physical Therapist Assistant / PTA / PRN - Morganton, NC.We currently have a PRN opportunity for a Physical Therapist Assistant at our skilled...  ...Morganton, NC. Broad River Rehab is a rapidly growing therapy company that partners with providers across all settings...