Teradata Lead Engineer

Design Scalable Data Warehousing Solutions using Teradata.

Develop and maintain normalized (3NF) and dimensional models.

Optimize physical models and fine tune queries for performance.

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.

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 environment

Understanding and implementing job schedules, dependencies, and workflows within Autosys

Analyzing and resolving issues with Autosys jobs and processes