Job Description
Design, develop, and maintain ETL processes using Pentaho Data Integration (PDI).
Collaborate with data architects and other teams to create optimal ETL solutions for large-scale data integration.
Work with relational databases (Oracle, SQL Server, MySQL, PostgreSQL) to ensure efficient data processing.
Create and optimize complex SQL queries to extract, transform, and load data.
Automate and streamline data workflows using Pentaho and other scripting tools.
Perform data profiling, validation, and reconciliation tasks to ensure data accuracy and integrity.
Ensure performance tuning of ETL jobs to handle large volumes of data.
Support integration of Pentaho with various external systems and platforms.
Troubleshoot and resolve any issues with data flows, processes, and systems.
Maintain version control and ensure proper documentation for all ETL processes and systems.Design, develop, and maintain ETL processes using Pentaho Data Integration (PDI).
Collaborate with data architects and other teams to create optimal ETL solutions for large-scale data integration.
Work with relational databases (Oracle, SQL Server, MySQL, PostgreSQL) to ensure efficient data processing.
Create and optimize complex SQL queries to extract, transform, and load data.
Automate and streamline data workflows using Pentaho and other scripting tools.
Perform data profiling, validation, and reconciliation tasks to ensure data accuracy and integrity.
Ensure performance tuning of ETL jobs to handle large volumes of data.
Support integration of Pentaho with various external systems and platforms.
Troubleshoot and resolve any issues with data flows, processes, and systems.
Maintain version control and ensure proper documentation for all ETL processes and systems.