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

Dynamics ATS

Shop Helper Job at Dynamics ATS

Shop Helper JOB-10044086 Anticipated Start Date June 16, 2025 Location Houston, TX Type of Employment Contract Employer Info Our client develops and deploys the most advanced technologies to serve energy and industrial companies ...

BYD(B)

Assembly (Senior) Mechanical Engineer Job at BYD(B)

1. Conduct regular inspections of the workshop's mechanical equipment operation, supervising and guiding equipment operators and maintenance personnel in the correct usage and maintenance of equipment.2. Responsible for preparing first and second-level maintenance plans... 

ProHealth Partners Inc.

Occupational Therapist Job at ProHealth Partners Inc.

Are you a Occupational Therapist that is looking for the perfect opportunity to further your career in home health care? Has flexibility been...  ...Bachelor's degree in Occupational Therapy Ability to travel to patient's home or facility Strong communication skills... 

Tekgo

Sterile Processing Technician Job at Tekgo

 ...START DATE 6/9/25 Shift: 2:30pm-11pm Sterile Processing Tech - Pittsburg, PA Seeking a Dedicated Sterile Processing Tech Tekgo, a...  ...career with a company committed to employee development. Travel Opportunities: Explore new locations while gaining valuable... 

Career Strategies

MDS Coordinator Job at Career Strategies

 ...Responsibilities: Coordinate the Minimum Data Set (MDS) process for residents in accordance with regulatory guidelines Conduct comprehensive assessments of residents' health status and care needs Collaborate with interdisciplinary teams to develop individualized...