Pentaho PDI Developer

Job description:

5+ Years Working experience on ETL tools with experience onPentahoData Integration.

Should have prior experience in Data modeling, data mapping, data conversion / migration

Develop, design, tune and maintain ETL routine to perform the ETL process.

Knowledge of SQL, oracle, Teradata etc

Design and develop stored procedures, functions, views, and triggers to be used during the ETL process.

Design and develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse.

Develops ETLtechnicalspecifications, designs, develops, tests, implements, and supports optimal data solutions.

Documents ETL data mappings, data dictionaries, processes, programs, and solutions as per established standards for data governance.

Integrates ETL development with existing projects to maximize object reuse.

Creates, executes, and documents unit test plans for ETL and data integration processes and programs.

Work with the data analysis team to assess and troubleshoot potential data quality issues at

key intake points such as validating control totals at intake.

Perform problem assessment, resolution, and documentation in existing ETL packages, mapping, and workflows in production.

Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations.