Design, develop, and implement ETL workflows using Pentaho Data Integration (PDI).
Extract data from various sources (RDBMS, flat files, APIs, etc.), transform it according to business rules, and load it into data warehouses or target systems.
Optimize ETL performance and troubleshoot any issues in data flows and transformations.
Work closely with data analysts, business analysts, and other stakeholders to understand requirements and deliver scalable data solutions.
Maintain data quality and consistency through effective validation and error handling mechanisms.
Develop and maintain technical documentation for ETL processes and data flow diagrams.
Automate and schedule ETL jobs using Pentaho Scheduler or external tools like Cron or Control-M.
Collaborate with DevOps/IT teams for deployment and monitoring of jobs in production environments
