Pentaho ETL developer

7 days ago


Thiruvananthapuram, Kerala, India Guidehouse Full time ₹ 9,00,000 - ₹ 12,00,000 per year

Job Family
Software Application & Development (India)

Travel Required
None

Clearance Required
None

What You Will Do

  • Design, develop, and optimize ETL workflows using Pentaho Data Integration (PDI/Kettle) to extract, transform, and load data from various sources into target databases and data warehouses.
  • Collaborate with business analysts and other team members to understand "Business", data requirements and translate them into effective ETL solutions.
  • Develop and maintain robust and efficient SQL queries, stored procedures, and database objects to support ETL processes and data management needs.
  • Assist in troubleshooting and resolving data quality issues and performance bottlenecks within ETL jobs and database systems.
  • Work closely with report developers and other stakeholders to ensure data availability and accuracy for reporting and analytical purposes.
  • Document ETL processes, data flows, and technical specifications for maintainability and knowledge sharing.
  • Contribute to the continuous improvement of data integration processes and best practices.
  • Work in Azure Datawarehouse solutions as a part of modernization
  • Work on challenging and impactful data projects.

What You Will Need

  • Bachelor's degree in computer science, Information Technology, or any related field.
  • 2-3 years of professional experience in ETL development, preferably with Pentaho Data Integration (PDI/Kettle).
  • Strong understanding of relational databases and database concepts, including data modelling and SQL programming (e.g., writing complex queries, stored procedures).
  • Familiarity with data warehousing concepts and principles.

What Would Be Nice To Have

  • Experience with Pentaho Business Analytics components (e.g., Pentaho Report Designer, Analyzer) for creating reports and dashboards.
  • Exposure to other BI tools and platforms.
  • Knowledge of scripting languages like Python or Java for advanced data manipulation or integration tasks.
  • Familiarity with performance tuning techniques for databases and ETL processes.

What We Offer
Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

About Guidehouse
Guidehouse is an Equal Opportunity Employer–Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at or via email at All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including or Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.

If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse's Ethics Hotline. If you want to check the validity of correspondence you have received, please contact Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant's dealings with unauthorized third parties.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.


  • Pentaho ETL developer

    2 weeks ago


    Thiruvananthapuram, Kerala, India Guidehouse Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Job Family:Software Application & Development (India)Travel Required:NoneClearance Required:NoneWhat you will do Design, develop, and optimize ETL workflows using Pentaho Data Integration (PDI/Kettle) to extract, transform, and load data from various sources into target databases and data warehouses.Collaborate with business analysts and other team members...

  • ETL Tester

    3 weeks ago


    Thiruvananthapuram, Kerala, India Zafin Full time

    We are looking for a QA Engineer with experience in ETL testing, Kafka/Redpanda, and MongoDB. The role involves testing large-scale data pipelines, ensuring data accuracy, consistency, and throughput in event-driven systems. Major Responsibilities: Test ETL processes and perform data reconciliation across systems. Validate Kafka/Redpanda pipelines...

  • ETL Tester

    7 days ago


    Thiruvananthapuram, Kerala, India Zafin Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    We are looking for a QA Engineer with experience in ETL testing, Kafka/Redpanda, and MongoDB. The role involves testing large-scale data pipelines, ensuring data accuracy, consistency, and throughput in event-driven systems.Major Responsibilities:Test ETL processes and perform data reconciliation across systems.Validate Kafka/Redpanda pipelines (producers,...


  • Thiruvananthapuram, Kerala, India Zafin Full time

    We are looking for a QA Engineer with experience in ETL testing, Kafka/Redpanda, and MongoDB. The role involves testing large-scale data pipelines, ensuring data accuracy, consistency, and throughput in event-driven systems.Major Responsibilities:- Test ETL processes and perform data reconciliation across systems.- Validate Kafka/Redpanda pipelines...

  • Developer III

    1 week ago


    Thiruvananthapuram, Kerala, India UST Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    3 - 5 Years3 OpeningsKochi, TrivandrumRole descriptionData Engineer (Python, SQL, ETL) Job DescriptionWe are seeking a skilled Data Engineer with strong expertise in Python and SQL—preferably with Snowflake experience—and hands-on knowledge of ETL tools, ideally Informatica Intelligent Cloud Services (IICS). You will join a large, collaborative team...


  • Thiruvananthapuram, Kerala, India Saasvaap techies pvt lmd Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    About the Job : Are you a seasoned data professional with a proven track record of transforming raw data into actionable insights? Do you possess a deep understanding of data modeling, SQL optimization, and Power BI development? We are seeking a highly motivated and experienced Data Lead to join our dynamic team and drive our data strategy. In this role,...

  • Lead Data Engineer

    3 weeks ago


    Thiruvananthapuram, Kerala, India UST Full time

    Key Responsibilities Big Data Architecture Design develop and maintain scalable and distributed data architectures capable of processing large volumes of data Data Storage Solutions Implement and optimize data storage solutions using technologies such as Hadoop Spark and PySpark PySpark Development Develop and implement...

  • Lead I

    1 week ago


    Thiruvananthapuram, Kerala, India UST Full time US$ 1,25,000 - US$ 1,75,000 per year

    Job Title: Senior Software Engineer - Cloud, APIs & RPAExperience: 5-10 YearsLocation: Any UST LocationJob Type: Full-TimeAbout the RoleWe are looking for a highly skilled Senior Software Engineer with strong expertise in RESTful APIs, Cloud platforms (Azure & Alibaba Cloud), and RPA tools. The ideal candidate will design and implement scalable backend...

  • Data Engineer

    7 days ago


    Thiruvananthapuram, Kerala, India Trenser Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    OverviewThis position is for a Data Engineer for a team that works on a long-term software projectfor a US client. The job location is Trivandrum, India. He/ she will be communicating withthe client representatives in the USA, both for technical and management aspects.Communication will be through various modes of collaboration including webconferences,...

  • Lead I

    7 days ago


    Thiruvananthapuram, Kerala, India UST Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    5 - 7 Years3 OpeningsKochi, TrivandrumRole descriptionData Engineer (Snowflake, Python, IICS) Job DescriptionWe're seeking an experienced Data Engineer with strong expertise in Snowflake and Python, alongside hands-on experience with ETL tools—preferably IICS. In this role, you will be part of a large, collaborative team working closely with the client on...