Pentaho Data Integration (PDI) Developer

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

• Strong 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 multiple systems
• Implement business rules, quality checks, exception handling within ETL workflows
• Build and maintain dimensional models – fact tables, dimensions, surrogate keys, SCD logic
• Optimize ETL workflows for performance, efficiency, and reliability
• Manage scheduling, monitoring & alerts for routine ETL jobs using Kitchen/Pan and OS schedulers
• Troubleshoot ETL failures, perform root cause analysis, and provide long-term fixes
• Collaborate with DBAs, cloud engineers, and infrastructure teams for performance tuning and environment setup
• Maintain clear technical documentation: mapping sheets, ETL logic, runbooks, deployment guides, SDS/SRS docs
• Support UAT, production releases, and post-deployment checks

Education

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Science, or equivalent field

How to Apply

Send your CV to:

• [email protected]

Immediate joiners are highly preferred.

Pay: ₹120,000.00 per month

Experience:

• Pentaho Data Integration (PDI) Developer : 5 years (Required)

Work Location: Remote