Haystack
← Back to Jobs
Remote
Technology
ME

(Only W2) Data Architect - Remote

MetaSense, Inc.United States🇺🇸United StatesPosted Oct 13, 2026

Quick Overview

Seniority
Mid Senior
Work mode
Remote
Location
United States
Posted
21 hours ago
OraclePL/SQLSQLShellETLApacheBigQueryGitGoogle CloudPythonTerraform

Job Description

  • 12–15 years in data engineering, ETL, database migration, or data architecture, including 5+ years in an architect or senior technical leadership role.
  • Knowledge on Agentic Implementation with industry standard Agentic Platforms
  • Deep Oracle SQL and PL/SQL expertise: schemas, packages, procedures, triggers, execution plans, partitioning, indexing, bulk processing, tuning, and large-volume migration.
  • Understanding of Informatica PowerCenter expertise: repository objects, mappings, sessions, workflows, parameterization, dependencies, troubleshooting, tuning, and migration assessment.
  • Working knowledge of Pro*C, embedded SQL, host variables, cursors, transaction control, file processing, and refactoring to Google Cloud Platform-native patterns.
  • Hands-on Google Cloud Platform skills in BigQuery, Cloud Storage, IAM, VPC Service Controls, Composer, Dataflow or Apache Beam, Dataproc or Spark, Pub/Sub, Datastream, Cloud SQL or AlloyDB, Logging, and Monitoring.
  • BigQuery modeling, partitioning, clustering, SQL optimization, batch and streaming ingestion, governance, metadata, lineage, reconciliation, security, and cost management.
  • Python, SQL, shell scripting, Git, CI/CD, Terraform or equivalent infrastructure automation, and production deployment practices.
  • Proven ability to lead global teams and translate legacy business logic into secure, scalable, supportable Google Cloud Platform solutions.

Similar jobs