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

El Encanto, A Belmond Hotel

Immediate Need! Wait Staff/Server Job at El Encanto, A Belmond Hotel

...vast offerings, the opportunities to craft a unique career here are endless. Join us and achieve the truly exceptional. As a Server at El Encanto, A Belmond Hotel, you are part of a team that shapes the culinary experience of our guests. In this role, you will master...

Duane Blanton Plumbing, Sewer, Heating & Cooling

HVAC Install Lead Job at Duane Blanton Plumbing, Sewer, Heating & Cooling

...Plumbing, Sewer, Heating & Cooling is seeking a dedicated and eager HVAC Install Lead to join our team. This is a fantastic opportunity... ...systems.Note:This role does not involve new construction or commercial work. Leading installations from start to finish, adhering...

Vallarta Supermarkets

Produce Clerk Job at Vallarta Supermarkets

...Willingness to learn; we provide training. Language: Basic understanding of the English language. About Vallarta Supermarkets: As of 2022, Vallarta counts on 53 stores throughout California (Ventura, Los Angeles, San Bernardino, Riverside, Kern, San...

Insight Global

Assistant Principal Job at Insight Global

...Must Haves : ~ Masters degree in education ~ Valid Texas administrative certificate as required by the State of Texas ~3 years... ...supervises a variety of school functions, such as support services, special activities and programs, student discipline, and curricula...

AAA Northern New England

Roadside Service Driver Job at AAA Northern New England

Roadside Service Driver $50,000 earning potential, plus additional opportunity to earn bonuses and incentives! Flexible Schedules... ...and flatbeds. Provide light services such as lockout assistance, battery diagnostics, and tire changes. What makes this position...

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

ekNGaWhRNEpWZnY5cDJkZlhCaE1uL0dpQkE9PQ==