Description

You will lead the migration of enterprise data warehousing workloads from Teradata to Google Cloud Platform. You own the end-to-end transformation of legacy scripts, schema optimization, and performance tuning for BigQuery environments.

Responsibilities

• Map Teradata DDLs and data types to BigQuery-optimized partitioning and clustering schemas.
• Refactor legacy Teradata BTEQ scripts and SQL logic into BigQuery Standard SQL and stored procedures.
• Optimize query performance and slot utilization to manage costs for migrated workloads.
• Configure BigQuery Slot Reservations and Workload Management to replicate Teradata capacity.
• Perform data validation, row-count reconciliations, and checksums between Teradata and GCP.

Required Skills

• 8+ years as a Data Warehouse Engineer or DBA.
• 3+ years of hands-on BigQuery administration in production.
• Strong SQL performance tuning and query optimization skills.
• Hands-on experience with GCP services: BigQuery, Composer/Airflow, Dataflow, Cloud Storage, Pub/Sub, Monitoring/Logging.
• Experience with EDW platform migrations and enterprise-scale data engineering.
• Strong knowledge of IAM, security controls, networking basics, and DR strategies.
• Experience with scripting (Python/Bash) and automation.

Preferred Skills

• Bachelor's degree in Computer Science or related field.

Key Skills

Education

Bachelor's degree