Data Migration Engineer — SQL to Snowflake/Teradata

US Tech Solutions; Omaha (NE); On-site; USD 90,000 - 130,000; Full time

Job summary

US Tech Solutions in Omaha, NE is seeking a data engineer contractor to move SQL Server tables and SSIS jobs to Teradata or Snowflake, ensuring data integrity and lineage. You will trace complex ETL processes, document dependencies, and collaborate with stakeholders across architecture reviews, testing, and production cutover.

Strong SQL, Teradata, Oracle, and Snowflake experience required; 12+ months contract with remote/hybrid options.

Qualifications

• Strong SQL Server and Teradata skills with the ability to trace complex tables, views, stored procedures, SSIS packages, and SQL Agent jobs.
• Analytical and problem-solving skills required.
• Ability to document end-to-end data lineage, dependencies, risks, decisions clearly.
• Experience across SQL Server, Teradata, Oracle, and Snowflake environments.
• Capable of tracing data lineage, reverse engineering ETL processes, and migrating business-critical data and reporting logic between platforms after onboarding.
• Strong communication skills and ability to work with project leadership, technical teams, and business stakeholders.
• Experience supporting architecture reviews, validation testing, historical data migration, production cutover, and implementation activities.
• Strong background delivering accurate migration results while preserving existing business logic and reporting behaviour.

Responsibilities

• Move SQL Server tables and SSIS jobs to Teradata or Snowflake.
• Trace ETL processes and maintain data integrity during migration.
• Document data lineage, dependencies, risks, and decisions clearly.
• Collaborate with project leadership, technical teams, and business stakeholders.
• Support architecture reviews, validation testing, and production cutover activities.
• Preserve existing business logic and reporting behaviour during migration.

Skills

SQL Server

Teradata

SSIS

Oracle

Snowflake

Data Migration

Data Lineage

SQL Development

Query Optimization

ETL

Tools

SQL Agent

Informatica

ETL Tools

Data Warehouse

Job description

US Tech Solutions in Omaha, NE is seeking a data engineer contractor to move SQL Server tables and SSIS jobs to Teradata or Snowflake, ensuring data integrity and lineage. You will trace complex ETL processes, document dependencies, and collaborate with stakeholders across architecture reviews, testing, and production cutover.

Strong SQL, Teradata, Oracle, and Snowflake experience required; 12+ months contract with remote/hybrid options.