Teradata Engineer

Tekfortune IT India Pvt Ltd; Buffalo (NY); Hybrid; USD 100,000 - 120,000; Full time

Job summary

A leading staffing and recruiting firm in Buffalo, NY is seeking a Teradata Engineer with over 7 years of experience in Teradata and Informatica. This full-time role requires strong SQL skills and experience in large-scale data integration projects. Candidates should have a solid understanding of data warehousing best practices and the Financial Services Data Model. The position offers a hybrid work environment.

Qualifications

• 5+ years of hands-on experience with Teradata, including SQL, FastLoad, MultiLoad, TPT, BTEQ.
• 3+ years in Informatica PowerCenter for ETL development.
• Strong SQL skills and knowledge of data warehousing best practices.

Responsibilities

• Handle large-scale data integration projects in financial services.
• Apply dimensional modeling and data normalization techniques.

Skills

Teradata

SQL

Informatica PowerCenter

Data warehousing

Job description

Overview

Teradata Engineer with Informatica: (7+ Years) – Hybrid in Buffalo, NY – Full-time Direct Hire – H1B transfer fine

Qualifications

• 5+ years of hands-on experience with Teradata (including SQL, FastLoad, MultiLoad, TPT, BTEQ).
• 3+ years of experience in Informatica PowerCenter for ETL development. 2+ years working with Teradata Financial Services Data Model (FSDM) or equivalent industry-standard models.
• Strong SQL skills and knowledge of data warehousing best practices.
• Experience in handling large-scale data integration projects in financial services.
• Solid understanding of 3NF, dimensional modeling, and data normalization techniques.

Job Details

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology
• Industries: Staffing and Recruiting