Tata Consultancy Services · 1 day ago
Teradata Development Lead Engineer
Seattle, WA
Full-time
Onsite
Mid, Senior Level
$120K/yr - $140K/yrTata Consultancy Services is seeking a Teradata Development Lead Engineer who will be responsible for designing scalable data warehousing solutions using Teradata. The role involves developing and maintaining data models, optimizing ETL processes, and ensuring data quality and integrity across systems.
Business Information SystemsConsultingInformation TechnologyIT Management
No H1B
U.S. Citizen Only
Responsibilities
Optimizing Database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure
Actively participated in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations
Engaged 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
Qualification
Required
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
Optimizing Database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure
Actively participated in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations
Engaged 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
BACHELOR OF COMPUTER SCIENCE
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.
Company
Tata Consultancy Services
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
Founded in 1968
10001+ employees
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
K. Krithivasan
Chief Executive Officer & Managing Director
Aarthi Subramanian
President and Chief Operating Officer
Recent News
Trak.in - Indian Business of Tech, Mobile & Startups
2026-01-22
Hindu Business Line
2026-01-21
Company data provided by crunchbase