Note: The job is a remote job and is open to candidates in USA. Pivotal Solutions is seeking a Senior Data Engineer with substantial Teradata experience for a remote contractor role supporting a client's cloud data platform migration. The role will lead the hands-on reverse engineering and transformation of legacy Teradata workloads, including rebuilding SQL and stored-procedure logic, validating migrated outputs, documenting lineage, coordinating cutover, and retiring legacy objects.
Responsibilities
- Inventory and profile existing Teradata objects: tables, views, macros, BTEQ scripts, stored procedures, and the jobs that run them
- Translate Teradata SQL to the target platform dialect, including proprietary constructs (QUALIFY, MERGE behavior, SET vs MULTISET tables, PI/PPI-driven logic, RANK/CSUM and other Teradata-specific functions)
- Rebuild transformation logic as modular, testable models in our transformation framework rather than lifting-and-shifting procedural code
- Design the target physical layout: clustering, partitioning, and load patterns appropriate to the new platform instead of carrying over Teradata indexing assumptions
- Build and run reconciliation between legacy and migrated outputs: row counts, aggregate checks, column-level comparison, and edge-case validation on a defined sample
- Document lineage, business logic uncovered during migration, and any deliberate behavior changes so downstream consumers can review them
- Coordinate cutover with downstream BI, Finance, Sales, and partner engineering consumers, including parallel-run windows and rollback plans
- Retire legacy objects once validated, and confirm no orphaned dependencies remain
Skills
- 5+ years in data engineering with substantial hands-on Teradata experience, including reading and reverse-engineering undocumented legacy SQL
- At least one completed Teradata-to-cloud migration where you owned significant scope, not just a supporting role
- Strong SQL, including window functions, complex joins, and performance tuning on large tables
- Working knowledge of a cloud data warehouse
- Experience with a SQL transformation framework such as dbt, including testing and version control practices
- Python for orchestration, tooling, and one-off data validation work
- Git-based workflow: branching, pull requests, code review
- Demonstrated rigor around data validation - you should be able to describe how you proved a migration was correct, not just that it ran
- Snowflake preferred; BigQuery, Redshift, or Databricks acceptable
- Experience with Airflow or a comparable orchestrator is a plus
Benefits
- Remote work arrangement
- 4+ month contractor position
Company Overview
Company H1B Sponsorship