ETL Architect with GCP

Govserviceshub; San Jose (CA); On-site; USD 100,000 - 130,000; Full time

Job summary

A technology services company is seeking an experienced ETL Developer in San Jose, California. This role involves designing and developing reusable ETL jobs for various data sources. Candidates should have strong Java and SQL skills, along with a good understanding of data warehousing and cloud-based ETL frameworks. The position provides an opportunity to work on diverse data processing projects in a dynamic environment.

Qualifications

• Strong background in cloud-based ETL tools and frameworks.
• Experience with both batch and streaming data processing.
• Proficient in SQL and Java programming.

Responsibilities

• Design and develop ETL jobs and data pipelines.
• Extract data from various sources including Oracle and flat files.
• Troubleshoot and resolve performance issues.

Skills

Data Warehousing architecture

Cloud-based ETL frameworks

Batch data processing

Streaming data processing

Analytical skills

Java programming

SQL expertise

DevOps practices

Tools

Pentaho Data Integration

Oracle

SQL Server

MySQL

NoSQL databases

Job description

Overview

San Jose, United States | Posted on 10/09/2025

Responsibilities

• Design and develop various standard/reusable ETL jobs and pipelines.
• Work with the team in extracting the data from different data sources like Oracle, cloud storage and flat files.
• Work with database objects including tables, views, indexes, schemas, stored procedures, functions, and triggers.
• Work with the team to troubleshoot and resolve issues in job logic as well as performance.
• Write ETL validations based on design specifications for unit testing.
• Work with the BAs and the DBAs for requirements gathering, analysis, testing, metrics and project coordination.

Requirements

• Good knowledge and understanding of cloud based ETL framework and tools.
• Good understanding and working knowledge of batch and streaming data processing.
• Good understanding of the Data Warehousing architecture.
• Knowledge of open table and file formats (e.g. delta, hudi, iceberg, avro, parquet, json, csv).
• Strong analytic skills related to working with unstructured datasets.
• Excellent numerical and analytical skills.
• Technical Skills
• Programming & Languages: JAVA
• Hands-on experience in building and optimizing data pipelines and data sets.
• Hands-on experience in migrating integrations from one server to another.
• Hands-on experience in Dev Ops implementation.
• Strong testing and debugging skills - writing unit tests and familiarity with the tools and techniques to fix issues.
• DevOps knowledge - CI/CD practices and tools.
• Hands-on CI/CD experience in automating the build, test, and deployment processes to ensure rapid and reliable delivery of API updates.
• Hands-on experience with data extraction and transformation tasks while taking care of data security, error handling and pipeline performance.
• Hands-on experience with relational SQL (Oracle, SQL Server or MySQL) and NoSQL databases.
• Advanced SQL experience - creating, debugging Stored Procedures, Functions, Triggers and Object Types in PL/SQL statements.
• Hands-on experience with programming languages - Java (mandatory), Go, Python.
• Experience in using Pentaho Data Integration (Kettle/Spoon) and debugging issues.
• Experience supporting and working with cross-functional teams in a dynamic environment.