Overview: Job Title: Pentaho DeveloperLocation: NYC / Pittsburgh, PA / Lake Mary, FL / Remote
Type: Contract / C2H
Work Mode: Onsite
Job Summary We are looking for a skilled
Pentaho Developer with hands-on experience in
ETL design, data integration, and performance optimization. The ideal candidate should have strong SQL skills, solid understanding of
database systems (Oracle, MySQL, PostgreSQL), and the ability to build and manage
Pentaho Data Integration (PDI) workflows to support business intelligence and data migration projects.
Roles and Responsibilities - Design, develop, and maintain ETL jobs and transformations using Pentaho Data Integration (PDI).
- Analyze business requirements and translate them into scalable data integration solutions.
- Work with Oracle, MySQL, and PostgreSQL databases to write and optimize SQL queries, procedures, and triggers.
- Configure, administer, and maintain multiple Pentaho environments (Dev, Test, and Prod).
- Support data migration, cleansing, and transformation processes.
- Collaborate with cross-functional teams throughout the Agile SDLC to deliver high-quality solutions.
- Create and manage RFCs for production releases and ensure smooth deployment.
- Troubleshoot production issues, perform root cause analysis, and provide timely resolutions.
- Develop and maintain UNIX shell scripts or batch scripts for automation and job scheduling.
- Perform performance tuning and ensure ETL efficiency.
Required Skills and Experience - Total Experience: 7+ years in IT with at least 3+ years of Pentaho PDI experience.
- ETL Tools: Pentaho Data Integration (PDI).
- Databases: Oracle, MySQL, PostgreSQL.
- Programming: SQL, PL/SQL.
- Operating Systems: Linux, UNIX (Shell Scripting).
- Performance Tuning: Strong understanding of optimization techniques for SQL and ETL.
- Experience with data migration, transformation, and integration projects.
- Familiarity with Agile / Scrum methodology and team coordination.
- Strong problem-solving, debugging, and analytical skills.
- Excellent communication and collaboration abilities.
Nice to Have - Exposure to BI tools or reporting systems.
- Experience with environment administration and deployment automation.
- Understanding of data warehousing concepts.
Additional Information - Work Mode: Onsite
- Type: Contract / Contract-to-Hire (C2H)
- Location Options: NYC / Pittsburgh, PA / Lake Mary, FL / Remote