Teradata - Datastage ETL Data Engineer

Tata Consultancy Services

Seattle, WA

Full Time

Mid Level

110k-125k

16 days ago

Job Description

About the Role

The role involves designing and developing Teradata ETL jobs and data pipelines, supporting enterprise data warehouse solutions, and ensuring data quality and integrity across systems. The position requires working with Teradata, SQL, and Autosys to optimize data processes and manage data migration and integration tasks.

Key Responsibilities

Design and develop Teradata ETL jobs and data pipelines.
Design, develop, and support enterprise data warehouse solutions leveraging Teradata and related tools.
Extract data from various sources, transform it, and load into target systems.
Ensure data quality, integrity, and consistency across different systems.
Develop and maintain data warehouses, data lakes, and data marts architecture.
Optimize ETL processes for performance, scalability, and reliability.
Manage Teradata, SQL Server, and Oracle database migrations including code migration, data loads, and server retirements.
Troubleshoot and resolve data integration issues.
Write and translate SQL queries and perform SQL data validation.
Perform performance tuning of SQL queries.
Define, manage, and monitor job schedules, troubleshoot issues within Autosys environment, and implement job dependencies and workflows.
Analyze and resolve issues with Autosys jobs and processes.

Requirements

Proficiency in SQL with at least an intermediate skill level.
Ability to manage Teradata, SQL Server, and Oracle database migration tasks.
Experience with troubleshooting data integration issues.
Solid skills in writing and translating SQL queries and performing data validation.
Experience with performance tuning of SQL queries.
Understanding of job scheduling, dependencies, and workflows within Autosys.
Ability to analyze and resolve issues related to Autosys jobs and processes.

Qualifications

Proficiency in SQL (intermediate skill level minimum).

Benefits & Perks

Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.