Pentaho Data Integration

5 days ago

Remote, India 263be4dd-7cbe-48e0-8cc4-37186fa5c729 Full time ₹ 72,00,000 - ₹ 1,44,00,000 per year

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:

Immediate joiners are highly preferred.

Job Type: Contractual / Temporary

Contract length: 09 months

Pay: From ₹75,000.00 per month

Benefits:

  • Work from home

Experience:

  • Pentaho Data Integration (PDI) Developer: 5 years (Required)
  • ETL Development: 5 years (Required)
  • Database management: 5 years (Required)
  • Oracle: 5 years (Required)
  • Microsoft SQL Server: 5 years (Required)
  • AWS: 5 years (Required)

Work Location: Remote

  • Data Integration Manager

    7 days ago

    Remote, India Corporate Hierarchy Solutions Pvt. Ltd Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Key ResponsibilitiesData Integration & ArchitectureLead the design, development, and maintenance of data integration pipelines across systems and applications.Manage ETL/ELT workflows using tools like Informatica, Talend, MuleSoft, Azure Data Factory, SSIS, or similar platforms.Conduct data mapping, transformation, validation, and error-handling to ensure...

  • Senior Azure Data Engineer

    7 days ago

    Remote, India Data PlatformExperts Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Job Description:We are looking for a skilled and motivated AI Azure Data Engineer with strong expertise in Microsoft Azure data services. The ideal candidate must have hands-on experience with Databricks or Microsoft Fabric and hold a valid certification in either. You will be responsible for designing, developing, and deploying scalable data pipelines,...

  • Oracle Data Integrator Resource –

    2 weeks ago

    Remote, India Intellion Technologies Pvt Ltd Full time ₹ 3,60,000 - ₹ 4,32,000 per year

    Job Title: ODI Resource – Part-Time (Freelance/Remote)Job Description:We are looking for an experienced ODI (Oracle Data Integrator) professional to provide part-time job support. The role is freelance and remote, offering flexible hours to assist our team with ODI-related tasks and projects.Key Responsibilities:Provide technical support and guidance on...

  • Data Integration Developer

    3 days ago

    Remote, India TWO95 International, Inc Full time US$ 10,000 - US$ 30,000 per year

    Job Title: Data Integration DeveloperLocation: 100% Remote work (India)Type: 6+ Months ContractRate: $Open /MarketRequirements:Requirements: Bachelor's degree in computer engineering, computer science, or a related field.A minimum of 5 years of experience as a programmer or a computer scientist.Experience with ETL tools such as Informatica and knowledge of...

  • Data Integration Engineer

    2 weeks ago

    Remote, India Cotiviti Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    OverviewEdifecs/Cotiviti is seeking a Data Integration Engineer to join our innovative software teams. In this position, you will be responsible for onboarding customers to the Risk Adjustment workflow applications. As part of this role, you will work with platform engineering, product, and implementation teams. The ideal candidate has experience in building...

  • Principal Developer, Application and Data Integration

    1 week ago

    remote, India Myers-Holum Full time

    Principal Developer, Application and Data IntegrationMyers-Holum is expanding operations to India, and is actively seeking experienced Principal Developers with strong application integration and data integration experience to play a pivotal role in the expansion of the India Practice.Responsibilities:Hands-on design, development, deployment, and maintenance...

  • Accounts Intern

    4 days ago

    Remote, India Target Integration Full time

    Are you a recent graduate with a Bachelor's degree in Commerce (B.Com) and a solid foundation in accounting and taxation principles? We are offering a unique opportunity for an enthusiastic individual to join our team as an Accountant Trainee. **Key Responsibilities**: **Data Entry and Bookkeeping**: Ensure accurate and timely entry of day-to-day bills and...

  • Accounts Intern

    4 days ago

    Remote, India Target Integration Full time

    Are you a recent graduate with a Bachelor's degree in Commerce (B.Com) and a solid foundation in accounting and taxation principles? We are offering a unique opportunity for an enthusiastic individual to join our team as an Accountant Trainee. **Key Responsibilities**: **Data Entry and Bookkeeping**: Ensure accurate and timely entry of day-to-day bills and...

  • Sales Admin

    2 days ago

    Remote, India Target Integration Full time

    **Job Type**: Full-time **Responsibilities**: - Provide administrative support to the sales team, including reporting and follow-ups. - Manage software systems and maintain accurate sales records - Assist with the preparation of sales presentations and proposal. - Support the sales team with data entry and administrative tasks. - Ensure smooth...

  • Principal Consultant, Data Integration and BI

    2 days ago

    remote, India Myers-Holum Full time

    Myers-Holum is expanding operations to India, and is actively seeking experienced Principal Consultants with strong data warehousing and business intelligence experience to play a pivotal role in the expansion of the India Practice.ResponsibilitiesDesign, build, and test custom data warehouse and BI solutions for Myers-Holum clients using the Oracle NetSuite...