Remote Data Engineer - Teradata Migration

Legacy Teradata Workload Migration LeadYou 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.We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.