Pentaho DI Engineer - ETL (10-16 yrs)

A Pentaho Data Integration (DI) Developer is responsible for designing, developing, and maintaining ETL (Extract, Transform, Load) workflows and data pipelines using the Pentaho Data Integration tool. This role involves working closely with stakeholders to ensure efficient data processing, integration, and transformation to support business intelligence and analytics needs.

Key Responsibilities :

ETL Development :

- Design and implement ETL workflows and data transformations using Pentaho Data Integration (PDI).

- Extract data from various source systems, transform it as per business requirements, and load it into target systems or data warehouses.

Data Integration :

- Develop and manage integrations between multiple databases, cloud systems, and applications.

- Optimize data flow and transformation processes to ensure high performance and scalability.

Requirement Analysis :

- Collaborate with business analysts and stakeholders to gather and analyze data integration requirements.

- Translate business requirements into technical specifications for ETL solutions.

Data Quality and Validation :

- Implement data quality checks and validation processes to ensure data accuracy and integrity.

- Debug and resolve issues in data workflows and pipelines.

Automation and Scheduling :

- Automate ETL jobs and processes using scheduling tools.

- Monitor scheduled jobs and address failures or performance bottlenecks.

Performance Tuning :

- Optimize ETL workflows and data pipelines for faster processing and reduced resource usage.

- Conduct regular performance reviews of data integration processes.

Documentation :

- Create and maintain comprehensive documentation for ETL workflows, data mappings, and integration processes.

- Provide training and guidance to team members on Pentaho DI usage.

Support and Maintenance :

- Provide ongoing support and maintenance for ETL processes and data integration solutions.

- Address production issues and ensure timely delivery of data to stakeholders.

Required Skills and Qualifications :

Technical Expertise :

- Hands-on experience with Pentaho Data Integration (Kettle) for ETL development.

- Strong knowledge of SQL and database systems such as MySQL, PostgreSQL, Oracle, or SQL Server.

- Familiarity with scripting languages like Python or Bash for automation.

- Experience with data warehousing concepts and tools.

Data Integration Knowledge :

- Understanding of ETL best practices, data modeling, and data quality processes.

- Familiarity with handling structured and unstructured data from diverse sources.

- ETL, Pentaho Data Integration (Kettle and Spoon), Designing and Troubleshooting and Performance tuning.

- AWS cloud, XML, Java scripts, java & Unix shell scripts.

Soft Skills :

- Strong analytical and problem-solving skills.

- Excellent communication and collaboration abilities.

- Ability to work in a fast-paced, team-oriented environment.

Preferred Qualifications :

- Bachelor's degree in Computer Science, Information Technology, or a related field.

- 3+ years of experience in ETL development using Pentaho DI or similar tools.

- Experience with big data platforms (e.g., Hadoop, Spark) and cloud technologies (AWS, Azure, GCP).

- Familiarity with BI tools such as Pentaho BI, Tableau, or Power BI.

- Certification in Pentaho or related ETL/BI technologies.

The Pentaho DI Developer role is crucial for building and maintaining efficient data integration pipelines that support business intelligence and decision-making processes.