Develop complex Teradata SQL and automate loads using TPT, FastLoad, MultiLoad, FastExport/Export, and BTEQ
Optimize performance: explain plans, stats strategy, PI/partitioning, and workload management
Build and support Informatica mappings, workflows, and performance-tuned ETL pipelines
Design and maintain scalable data pipelines across Teradata, Snowflake, and cloud storage
Develop Python scripts for automation, data processing, and quality validations
Build Snowflake objects (tables, views, tasks) and support migration from Teradata to Snowflake
Implement data quality checks, metadata-driven frameworks, and CI/CD-driven deployments

Requirements

6+ years Strong hands-on expertise with Teradata utilities (TPT, FastLoad, MultiLoad, FastExport)
Advanced SQL and BTEQ scripting experience
Proven experience with Informatica PowerCenter
Data engineering experience with Snowflake
Unix/Linux scripting, Git, and CI/CD knowledge
Experience with migration from Teradata to Snowflake is plus
Exposure to AI, CO-pilot experience is plus
Experience with cloud platforms such as AWS, Azure, or GCP

Benefits

Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade
Company paid holidays
Personal Days
Sick Leave
Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs
Other benefits as provided by local policy and eligibility

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Teradata SQLTPTFastLoadMultiLoadFastExportBTEQInformaticaPythonETLSQL