Data Engineer
Core
Design, build, and optimize data pipelines and ETL/ELT workflows to migrate and process large datasets from Teradata to Snowflake.
Role type
Data Engineer (Data Migration & Pipeline Optimization)
Builds
ETL/ELT pipelines, data models, views, stored procedures, and automated data ingestion workflows.
Domain
Cloud Data Warehousing, Data Migration, Financial Services
Required skills
Snowflake, SQL, Teradata, Python, Shell Scripting, ETL/ELT, Data Modeling, CI/CD, Data Governance
Preferred skills
Snowflake SnowPro Certification, Banking/Financial Services experience
Technologies
Snowflake, Teradata, dbt Cloud, Fivetran, Databricks, Oracle, PostgreSQL, Snowpipe, Streams, Tasks
Responsibilities
Design and develop ETL/ELT pipelines to migrate data from Teradata to Snowflake; Optimize migration processes ensuring data integrity, accuracy, and performance; Create and manage Snowflake objects (tables, views, schemas, stages, procedures); Implement partitioning, clustering, and performance tuning strategies; Automate data ingestion from various sources using Snowflake connectors and external stages; Rewrite and optimize Teradata SQL scripts, macros, and stored procedures for Snowflake compatibility; Conduct data reconciliation between Teradata and Snowflake post-migration; Work closely with data architects, analysts, and business stakeholders to understand requirements.
Seniority
Mid-Senior, hands-on IC