ETL Architect GCP

Overview

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

• 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.

• 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.
• Dev Ops 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 No
  
  SQL 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.