Teradata Solution Lead

Seattle, OR - USA

Monthly Salary: Not Disclosed

Posted on: 18 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Title : Teradata Solution Lead
Location : Seattle WA
Type of Hire : Full Time

MOI: Video

Job Description:-

Skill: Teradata
Minimum Experience: 10 - 15 Years
Qualification: BACHELOR OF COMPUTER SCIENCE

Must Have Technical/Functional Skills

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

Roles & Responsibilities

Lead and optimize Database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.
Lead and actively participate in troubleshooting and resolving issues related to data loading delays and database server outages ensuring minimal disruption to data flow and system operations.
Provide technical leadership and guidance to team members fostering a collaborative and supportive team culture.
Lead the planning solution design and implementation ensuring alignment with program objectives and timeline
Engage in periodic reviews of job logs and performance metrics to identify trends proactively addressing potential issues.
Troubleshooting production issues through meticulous job log reviews implementing necessary design changes via change management and adhering to the code promotion process.
Contributed to the development and maintenance of documentation for troubleshooting procedures best practices and system configurations facilitating knowledge sharing within the team and managing Change Requests
Resolving data issues arising from load delays or database server downtimes with a focus on ensuring customer satisfaction.
Collaborate with stakeholders to understand business requirements providing valuable insights and recommendations for optimizing data processing workflows.

Generic Managerial Skills If any

Strong technical expertise in legacy application modernization including proficiency in ETL Solution frameworks and technologies.
Excellent communication skills with the ability to manage business expectation efficiently
Detail-oriented with solid problem-solving and analytical abilities

Thanks & Regards
Amit Kumar Technical Recruiter
Edge Global LLC

Job Title : Teradata Solution Lead Location : Seattle WA Type of Hire : Full Time MOI: Video Job Description:- Skill: Teradata Minimum Experience: 10 - 15 Years Qualification: BACHELOR OF COMPUTER SCIENCE Must Have Technical/Functional Skills Design Scalable Data Warehousing Solutions using Tera...