ETL Developer

Job Title : ETL Developer with Pentaho
No of Openings : 2

Client: Banking

Expr level 10+ years

Location: New York City, NY (Hybrid3-4 Days)

Rate: Per Market (CTH 6 months)

RH ID 891041

Pls Note: COI: 5MM COI (Certificate of Insurance) is required from candidate's employer (who is running his payroll)

Job Overview:

Seeking an experienced ETL Developer with strong Pentaho PDIKettle expertise to design develop and support data integration and data warehousing solutions The candidate should have hands on experience in ETL development SQL data modeling and production support.

Key Skills: Pentaho PDI ETL SQL Data Warehousing Data Modeling Performance Tuning Production Support Data Integration

Mandatory Skills : Data Architecture, Dimensional Data Modeling, ETL / Datawarehouse testing, MySQL

Key Responsibilities

• Develop and maintain ETL workflows using Pentaho PDIKettle
• Design data extraction transformation and loading processes
• Perform data mapping validation reconciliation and quality checks
• Optimize ETL jobs and SQL queries for performance
• Support production deployments monitoring and issue resolution
• Collaborate with business analysts architects and stakeholders
• Prepare technical documentation and participate in code reviews

Required Skills

• Exp of ETLData Warehousing experience
• Strong expertise in Pentaho Data Integration PDIKettle
• Advanced SQL and database development experience Oracle SQL Server PostgreSQL Teradata
• Good understanding of Data Warehousing and Dimensional Modelling
• Experience with Shell Scripting and scheduling tools
• Knowledge of performance tuning and production support

Preferred Skills

• BFSI domain experience
• Exposure to Python Cloud Platforms AWS Azure and Agile methodologies
• Experience with Jira ServiceNow and CICD practices.