MetaSense, Inc.
MetaSense, Inc.

Data Architect - PL/SQL

Remote • Posted 8 hours ago • Updated 8 hours ago
Full Time
Remote
Up to $150,000/yr
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • PL/SQL
  • SQL
  • Oracle
  • Extract
  • Transform
  • Load
  • Good Clinical Practice
  • Google Cloud Platform
  • Continuous Integration
  • Database Migration
  • Embedded SQL
  • IT Management
  • Informatica PowerCenter
  • Meta-data Management
  • Supply Chain Management
  • Streaming
  • Informatica
  • Git
  • Testing
  • Retail
  • Modeling

Summary

Key Responsibilities
  • Assess Oracle schemas and PL/SQL, Informatica mappings and workflows, Pro*C programs, SQL scripts, schedules, dependencies, volumes, and lineage.
  • Define Google Cloud Platform target architecture using BigQuery, Cloud Storage, Dataflow, Dataproc, Cloud Composer, Pub/Sub, Datastream, and Cloud SQL or AlloyDB.
  • Map Oracle data types, partitioning, indexing, constraints, sequences, stored logic, and embedded SQL to scalable Google Cloud Platform-native designs; identify refactoring needs.
  • Modernize Informatica and batch pipelines into SQL, Dataflow, Dataproc, or Composer patterns for joins, lookups, aggregations, routing, updates, and high-volume processing.
  • Design bulk and incremental loads, CDC, restartability, idempotency, orchestration, error handling, audit, lineage, observability, security, and cost/performance controls.
  • Establish reconciliation and traceability for counts, totals, balances, transformations, integrity, and business rules; lead testing, cutover, rollback, validation, and hypercare.
  • Lead architecture and code reviews and communicate decisions, risks, dependencies, and readiness to client stakeholders and distributed teams.
Required Experience and Skills
  • 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.
Preferred
Google Professional Data Engineer or Cloud Architect certification; Oracle-to-BigQuery migration, Informatica modernization, database-conversion tools, Terraform, dbt, data-quality frameworks, and retail, supply chain, inventory, pharmacy, or reporting experience.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10282828
  • Position Id: 9115555
  • Posted 8 hours ago

Company Info

About MetaSense, Inc.

Join MetaSense, Inc.™, a leading force in IT placement nationwide! As an Inc. 5000 award-winning talent and technology powerhouse, we're experiencing rapid growth and gaining widespread recognition. Our main office is in West Berlin, NJ, with a branch in Philadelphia, PA. 

 

We're transforming the industry with our dedication to exceptional service.

 

When you join our dynamic team, you'll have the opportunity to make a real difference. Whether you're helping job seekers find their dream roles or providing essential staffing solutions to companies in transition, your role will be impactful. You'll work closely with our amazing team of Coaches, Staffing Consultants, and IT Professionals, understanding the unique needs of individuals and businesses, and delivering personalized career and talent solutions that lead to success.

 

At MetaSense, Inc., we value innovative thinking, practical solutions, and an unwavering commitment to excellence. With decades of combined experience in career coaching and staffing solutions, our leadership and staff are dedicated to creating strategies that help our clients thrive. We're passionate about our mission and driven to connect people with meaningful opportunities.

 

Join us at MetaSense, Inc. We are more than just a team – we’re family. Let us support you on your journey because, at MetaSense, your success is our top priority.

Go to company profile
Contact the job poster
AP

Aeri Panchal

Recruiter @ MetaSense, Inc.

View Profile
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.
Remote jobs at MetaSense, Inc.