Data Engineer (Google Cloud)

Quick Facts

• Role: Data Engineer (Middle)

• Focus: Data engineering project and migration of data pipelines to Google Cloud Platform

Description

You will design, implement, and evolve data engineering solutions on Google Cloud Platform, primarily using BigQuery, Cloud Storage, and Pub/Sub. The work includes migrating and rebuilding data processing from Oracle/on-premise to GCP, creating batch and streaming ETL/ELT with data quality, error handling, and retries. You will also build BigQuery data models, optimize SQL for large datasets, migrate logic from Informatica PowerCenter, and support testing, deployments, and post-release verification.

Responsibilities

• Design, implement, and develop Data Engineering solutions on GCP

• Migrate and rebuild data processing and data loading processes from Oracle/on-premise to GCP

• Design batch and streaming pipelines with data quality controls, error handling, and retry mechanisms

• Design data structures and models in BigQuery with performance, scalability, and cost optimization

• Analyze data and prepare logical and physical data models for Oracle, PostgreSQL, and GCP

• Create, analyze, and optimize SQL queries (including execution plan analysis and identifying bottlenecks)

• Analyze existing Informatica PowerCenter processes and migrate them to target solutions in GCP

• Implement transformation, validation, and data integration logic in SQL and Python

• Perform technical impact/dependency analyses and help align solution specifications

• Prepare unit and integration tests; support system, performance, regression, and UAT testing

• Prepare deployment changes and deployment instructions; support deployments and post-deployment verification

• Diagnose and resolve incidents related to data processing and data quality

• Create and update technical documentation

• Work with code repositories and CI/CD processes following DevOps practices

Requirements

• Minimum 2 years of commercial experience designing and implementing data integration or data processing processes

• Middle-level proficiency as a Data Engineer

• Practical knowledge of Google Cloud Platform (BigQuery, Cloud Storage, Pub/Sub)

• Practical Oracle experience (creating and optimizing SQL queries for large data volumes)

• Informatica PowerCenter experience for independent analysis and modification of ETL processes

• SQL proficiency for analyzing, optimizing, and developing data processing workflows

• Experience with ETL/ELT, data migration, and system integration

• Python knowledge needed to implement transformation and processing logic

• Experience testing, documenting, and deploying data solutions

Benefits

• B2B cooperation

• Hybrid work model (remote/on-site depending on project needs)

• Rate: 147.20 PLN net/hour