Job description:

Pentaho Data Integration (PDI) Developer – 5+ Years’ Experience

Company: Pixel Solutionz

Job Type: Contractual – 9 Months (Extension Based on Performance)

Location: Remote / as per company requirement

Immediate Joiners Preferred

Job Summary:

Pixel Solutionz is looking for a highly skilled Pentaho Data Integration (PDI/Kettle) Developer with 5+ years of experience in designing, developing, and deploying end-to-end ETL pipelines across Data Warehouse and Data Lake environments. The ideal candidate must be strong in ETL development, data modeling, performance tuning, and managing ETL deployments across multiple environments.

Key Skills & Expertise

Pentaho Data Integration (PDI/Kettle)
- Strong experience in transformation design, job orchestration, parameterization, workflow branching
- Error handling, logging, repository migration & environment setup

ETL Development
- End-to-end development of data pipelines: Staging → EDW → Data Marts
- Experience with incremental loads, data cleansing, and business rule implementation

Data Integration




- Hands-on experience extracting data from:

Oracle, SQL Server, PostgreSQL, MySQL, APIs, flat files, and cloud-based data sources
- Loading into Data Warehouse/Data Lake environments

Database Skills
- Robust SQL expertise across Oracle, SQL Server, PostgreSQL, MySQL, Vertica

Cloud & Big Data
- Exposure to AWS, S3, Data Lake storage, Parquet file handling
- Understanding of distributed data processing

Data Quality & Governance
- Data profiling, validations, cleansing logic
- SCD Type 1 & 2 implementation
- Audit, reconciliation, and exception frameworks

Performance Optimization
- Transformation tuning, SQL optimization
- Lookup caching, memory management, parallel execution

Roles & Responsibilities
- Work closely with business users, BI teams, and data architects to understand reporting and analytics needs
- Develop PDI transformations & jobs to ingest, cleanse, validate, and integrate data from multipl

📌 Pentaho Data Integration (India)
🏢 pixel solutionz
📍 India