Cloud Data Engineer – GCP Migration & Transformation Specialist

Singapore (Singapore)

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.