Teradata ETL Engineer

TATA Consulting Services•Seattle, WA

52d•$100,000 - $125,000

About The Position

Design and develop Tera Data ETL jobs and data pipeline. Design, Develop and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities. Extracting data from various data sources, transforming, and loading it into target systems. Ensuring data quality, integrity, and consistency across different systems. Creating BTEQ scripts for complex metadata driven ingestion and massive data loads. Ability to write and understand complex stored procedures. Developing and maintaining data warehouses, data lakes and data mart architecture. Optimizing ETL processes for performance, scalability and reliability. SQL proficiency (intermediate skill level minimum) Ability to manage Teradata/SQL Server/ Oracle database migration including code migration, data loads and server retirements. Troubleshooting and resolving data integration issues Solid skills with writing/translating SQL queries and SQL data validation. Performance tuning of SQL queries. Defining, managing, and monitoring job schedules, as well as troubleshooting issues within the Autosys

Requirements

Teradata ETL jobs
Data pipeline
Enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities
Extracting data from various data sources, transforming, and loading it into target systems
Ensuring data quality, integrity, and consistency across different systems
Creating BTEQ scripts for complex metadata driven ingestion and massive data loads
Ability to write and understand complex stored procedures
Developing and maintaining data warehouses, data lakes and data mart architecture
Optimizing ETL processes for performance, scalability and reliability
SQL proficiency (intermediate skill level minimum)
Ability to manage Teradata/SQL Server/ Oracle database migration including code migration, data loads and server retirements
Troubleshooting and resolving data integration issues
Solid skills with writing/translating SQL queries and SQL data validation
Performance tuning of SQL queries
Defining, managing, and monitoring job schedules, as well as troubleshooting issues within the Autosys

Responsibilities

Design and develop Tera Data ETL jobs and data pipeline.
Design, Develop and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities.
Extracting data from various data sources, transforming, and loading it into target systems.
Ensuring data quality, integrity, and consistency across different systems.
Creating BTEQ scripts for complex metadata driven ingestion and massive data loads.
Ability to write and understand complex stored procedures.
Developing and maintaining data warehouses, data lakes and data mart architecture.
Optimizing ETL processes for performance, scalability and reliability.
Ability to manage Teradata/SQL Server/ Oracle database migration including code migration, data loads and server retirements.
Troubleshooting and resolving data integration issues
Defining, managing, and monitoring job schedules, as well as troubleshooting issues within the Autosys

Benefits

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume