Description

You will design, develop, and maintain ETL workflows using Pentaho to modernize data processes and support new solutions.

This role is on-site.

Responsibilities

• Re-engineer existing data processes from Shell scripts or Java into Pentaho (PDI) workflows.
• Implement scalable data integration pipelines to meet evolving business requirements.
• Analyze and reverse-engineer legacy workflows to build equivalent solutions in Pentaho.
• Support migration of on-prem or custom data solutions to Azure Cloud, integrating Azure Blob Storage and ADF.
• Develop parameterized, modular transformations with robust data quality, error handling, and audit logging.

Required Skills

• 5+ years refactoring legacy scripts into ETL jobs using visual tools like Pentaho.
• Strong background in data processing workflows implemented in Shell scripts or Java.
• Hands-on experience with Azure Data Factory, Azure Blob Storage, Azure SQL, and Azure Key Vault.
• Proficiency in SQL, stored procedures, and performance tuning across Oracle, PostgreSQL, and SQL Server.
• Experience handling integration via APIs, CSV, JSON, and XML sources and targets.
• Familiarity with Git/GitLab for version control and CI/CD concepts for ETL.
• Experience with data validation and implementing data retention policies.

Preferred Skills

• Knowledge of Agile methodologies and tracking tasks in JIRA.

Key Skills

Education

Any Graduate