The ETL Developer is responsible for developing ETL code in pentaho ETL tool.
Objective is to work on a ERP upgrade project where multiple interfaces via DB links are to be migrated to pentaho ETL.
Required Knowledge and Skills
Development skill in Pentaho ETL tool.
Troubleshoot pentaho ETL issues.
Installation, configuration and administration of pentaho ETL in high availability environment.
ETL migrations and performance tuning.
Understanding the various features of Pentaho tool.
Development skill in Oracle and SQL Server Databases and queries.
Better understanding and working experience in SQL and PL / SQL
Major Areas of Responsibility
Migrate DB link interfaces to Pentaho ETLs
Develop the SQL and PL / SQL codes to use in pentaho ETL.
Optimize the existing ETL and database codes for better Performance.
Integrate data between Oracle Database and SQL Server Database.
Use PL / SQL for ETL works.