Etl Pentaho Developer

5+ Years 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).

5+Years experience in reporting and analytics tools such as Pentaho or Tableau.

5+Years experience in complex SQL development leveraging analytics functions using in Sybase ASE or SQL Server.

2+ Years experience in Pentaho Data Integration (PDI) development.

5+ Years experience in Star Schema / Dimensional Modeling to support data warehouse environments.

5+Years months experience in doing data profiling and source to target mappings.

3+Years months experience in doing Web development using Java, HTML, and CSS

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.

Provide Web Development support to embade the anaytics reports on the Agency's internal portal (intranet).