Teradata ETL Engineer

Title : Teradata ETL Engineer

Location : Seattle, WA / St. Louis, MO / Plano, TX / Dallas, TX / Houston, TX

Type : Fulltime / Permanent Role

Must Have Technical / Functional Skills

• 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

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.