Job Role: Cloud Data Engineer – GCP Migration & Transformation Specialist

Experience Level: 8+ years (with recent GCP project experience)

Job Summary:
We are looking for a skilled Data Engineer with strong experience in Google Cloud Platform (GCP) and enterprise data migrations. The ideal candidate will have a deep understanding of the GCP data landscape, Medallion architecture, and hands-on experience in migrating data models and ETL pipelines from on-premise platforms such as Teradata and Cloudera to GCP BigQuery.

Key Responsibilities:

Design and implement scalable data pipelines using GCP BigQuery and Cloud Composer, following Medallion architecture principles.
Lead data model and data migrations from on-premise platforms like Teradata and Cloudera to BigQuery, ensuring accuracy and performance.
Develop BigQuery SQL-based transformations and standard ELT conversion patterns (e.g., pushdown optimization, partitioning strategies, staging layer design).
Map legacy Informatica workflows and Teradata BTEQ scripts to BigQuery SQL-based ELT solutions.
Migrate Control-M workflows to GCP Cloud Composer, ensuring orchestration compatibility and performance.
Design modular and reusable BigQuery pipeline patterns applicable across multiple use cases.
Collaborate with reporting teams to build dashboards and reports, ensuring BigQuery data type compatibilitywith tools such as QlikSense.
Troubleshoot data pipeline issues, ensuring timely resolution and optimal system performance.

Required Skills & Experience:

Strong working knowledge of GCP services, including BigQuery, Cloud Composer, and the overall GCP data ecosystem.
Experience with in a cloud-based data platform.
Hands-on experience with data migration and transformation projects from Teradata, Cloudera, or similar on-premise systems to GCP.
Proficiency in BigQuery SQL for advanced data transformation tasks.
Familiarity with standard data engineering patterns such as partitioning, staging, modularity, and pipeline reusability.
Experience in converting legacy Informatica and BTEQ workflows to cloud-native solutions.
Experience with QlikSense or similar BI tools, including handling data type compatibility with BigQuery.
Strong debugging and issue resolution skills in a cloud-based data environment.

Experience with data governance, data quality checks, and performance tuning in BigQuery.
Exposure to CI/CD practices and infrastructure as code (IaC) for pipeline deployments.

When you apply, you voluntarily consent to the disclosure, collection and use of your personal data for employment/recruitment and related purposes in accordance with the Tech Aalto Privacy Policy, a copy of which is published at Tech Aalto’s website (https://www.techaalto.com/privacy/)
Confidentiality is assured, and only shortlisted candidates will be notified for interviews.

Cloud Data Engineer – GCP Migration & T...