Pentaho Etl Developer

Tekskills; Hyderabad; On-site; INR 1,100,000 - 1,800,000; Full time

Job summary

Tekskills in Hyderabad is seeking an experienced ETL Engineer to design, develop, and maintain ETL processes using Pentaho Kettle. You will collaborate with analysts and developers to translate data requirements into efficient ETL solutions, monitor performance, and ensure data accuracy.

Ideal candidates have 6–9+ years of ETL experience, strong SQL, data modeling skills, and familiarity with Agile/Scrum methodologies.

Qualifications

• 6-9+ years of ETL design, development, and maintenance using Pentaho Kettle.
• Collaborate with Business Analysts and developers to translate data requirements into ETL solutions.
• Monitor and optimize ETL processes for data accuracy and performance.
• Create and maintain data models, ER diagrams, and related documentation.
• Troubleshoot and resolve issues in ETL processes and data integration.
• Participate in cross-functional teams to support organizational goals and projects.
• Provide software solutions to technically challenging business requirements.
• Strong knowledge of data handling and ETL.
• Proficiency in SQL and experience with database management systems.
• Ability to manage complex projects and follow through on tasks.
• Familiarity with Agile/Scrum methodologies and DevOps in prior roles.
• Worked on large and complex code bases.
• Knowledge of reconciliation domain product and using vendors’ application tools; customize UI screens, workflows and database structures to meet business requirements.
• Amending configurations to accommodate upgrade changes.
• Providing full and comprehensive documentation of changes and new components.

Responsibilities

• Design, develop, and maintain ETL processes using Pentaho Kettle.
• Collaborate with BAs and developers to derive data requirements for ETL solutions.
• Monitor ETL performance and ensure data accuracy across processes.
• Create and maintain data models, ER diagrams, and related documentation.
• Troubleshoot ETL issues and ensure reliable data integration.
• Work in cross-functional teams to support business goals and projects.
• Provide software solutions to meet complex business requirements.
• Apply strong SQL and database skills to implement robust ETL jobs.

Skills

ETL design & development

Pentaho Kettle

SQL proficiency

Data modeling

Agile/Scrum

DevOps practices

Data integration

Troubleshooting

Codebase experience

Reconciliation domain

Vendor tools

Documentation

Tools

SQL Server

Job description

• 6-9+ years of experience on design, develop, and maintain ETL (Extract, Transform, Load) processes using Pentaho Kettle.


• Collaborate with Business Analysts and other developers to understand data requirements and translate them into efficient ETL solutions.


• Monitor and optimize ETL processes to ensure data accuracy and performance.


• Create and maintain data model, ER diagrams, and other documentation.


• Troubleshooting and resolving issues related to ETL processes and data integration.


• Participate in cross-functional teams to support organizational goals and projects.


• Provide software solutions to technically challenging business requirements.


• Strong knowledge of data handling, ETL etc.


• Proficiency in SQL and experience with database management systems.


• Ability to manage complex projects and follow through on tasks.


• Familiarity with Agile/Scrum methodologies and task management.


• Good understanding of Agile methodology and development. Should have worked as a DevOps engineer in of one the previous role.


• Worked on large and complex code base


• Technical knowledge of Reconciliation domain product & using the vendors application tools and customize the user interface screens, system workflow and database structures to meet business requirements.


• Amending the configuration in Control to accommodate the upgrade changes


• Providing full and comprehensive documentation of all changed and new components so that they can be successfully