Tata Consultancy Services · 3 weeks ago
Teradata Development Lead Engineer
Seattle, WA
Full-time
Onsite
Senior Level, Lead/Staff
$120K/yr - $140K/yr
14+ years expTata Consultancy Services is seeking a Teradata Development Lead Engineer. The role involves designing scalable data warehousing solutions, optimizing ETL processes, and ensuring data quality and integrity across systems.
Business Information SystemsConsultingInformation TechnologyIT Management
Hiring Manager
Aarthi A
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
Collaborated with stakeholders to understand business requirements, providing valuable insights and recommendations for optimizing data processing workflows
Qualification
Required
14 - 18 years of experience
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
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.
10001+ employees
H1B Sponsorship
Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)
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
Business Standard India
2026-01-09
Company data provided by crunchbase