Sr Data Engineer
Remote
W2 Contract
About the engagement
You will lead the hands-on migration of legacy Teradata workloads onto our modern cloud data platform. This is a delivery role, not an advisory one. You will be reading legacy SQL and stored procedures, understanding what they actually do, and rebuilding that logic in the new stack with tests and documentation behind it.
What you'll do
- 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.
Required
- 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 (Snowflake preferred; BigQuery, Redshift, or Databricks acceptable) and how its cost and performance model differs from Teradata.
- 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.
Nice to have
- Prior work in retail, CPG, or ecommerce data, especially product catalog, GTIN/UPC, or item master domains.
- Experience with Airflow or a comparable orchestrator.
- Familiarity with migration accelerator tooling and its limits.
- Comfort writing documentation for a mixed technical and business audience.
- What success looks like in the first 90 days
- A complete, prioritized inventory of in-scope Teradata objects with dependency mapping.
- First migration wave delivered, validated, and running in parallel.
- A repeatable reconciliation approach the rest of the team can reuse for later waves.
What success looks like in the first 90 days
- A complete, prioritized inventory of in-scope Teradata objects with dependency mapping.
- First migration wave delivered, validated, and running in parallel.
- A repeatable reconciliation approach the rest of the team can reuse for later waves.
Aditya Kumar
Technical Recruiter
Email:
[email protected]
Address:
505 Knolle Court
Saint Augustine, FL 32092
Telephone:
+1 732-795-9133
www.stellentit.com
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
