Tata Consultancy Services
Join to apply for the
Data Stage ETL Developer
role at
Tata Consultancy Services .
Job Description
Design and develop Teradata ETL jobs and data pipeline.
Design, develop, and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities.
Extract data from various sources, transform, and load it into target systems.
Ensure data quality, integrity, and consistency across systems.
Optimize ETL processes for performance, scalability, and reliability.
Manage Teradata SQL and perform performance tuning of queries.
Troubleshoot and resolve data integration issues.
Define, manage, and monitor job schedules and troubleshoot in the Autosys environment.
Implement job schedules, dependencies, and workflows within Autosys.
Analyze and resolve issues with Autosys jobs and processes.
Handle job failures in AutoSys, including Linux scripting, DataStage ETL, and Teradata SQL.
Use Part Loader in DataStage.
Collaborate with DBAs to optimize database jobs and implement SQL coding and design changes within job structures.
Participate in troubleshooting and resolving data loading delays and database server outages.
Conduct periodic reviews of job logs and performance metrics to identify trends and proactively address potential issues.
Implement design changes via change management and adhere to code promotion process while troubleshooting production issues.
Develop and maintain documentation for troubleshooting procedures, best practices, and system configurations.
Resolve data issues arising from load delays or server downtimes, focusing on customer satisfaction.
Collaborate with stakeholders to understand business requirements and recommend optimizations for data processing workflows.
Qualifications
Intermediate level SQL proficiency.
Experience managing Teradata SQL.
Solid skills in writing and translating SQL queries and data validation.
Performance tuning of SQL queries.
Experience with Autosys scheduling and troubleshooting.
Ability to troubleshoot Linux scripting and DataStage ETL.
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.
Salary Base Salary Range: $120,000 - $160,000 per annum
Seniority Level Entry level
Employment Type Full-time
Job Function Business Development and Sales
Referrals increase your chances of interviewing at Tata Consultancy Services by 2x.
Get notified about new ETL Developer jobs in
Seattle, WA .
#J-18808-Ljbffr
Data Stage ETL Developer
role at
Tata Consultancy Services .
Job Description
Design and develop Teradata ETL jobs and data pipeline.
Design, develop, and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities.
Extract data from various sources, transform, and load it into target systems.
Ensure data quality, integrity, and consistency across systems.
Optimize ETL processes for performance, scalability, and reliability.
Manage Teradata SQL and perform performance tuning of queries.
Troubleshoot and resolve data integration issues.
Define, manage, and monitor job schedules and troubleshoot in the Autosys environment.
Implement job schedules, dependencies, and workflows within Autosys.
Analyze and resolve issues with Autosys jobs and processes.
Handle job failures in AutoSys, including Linux scripting, DataStage ETL, and Teradata SQL.
Use Part Loader in DataStage.
Collaborate with DBAs to optimize database jobs and implement SQL coding and design changes within job structures.
Participate in troubleshooting and resolving data loading delays and database server outages.
Conduct periodic reviews of job logs and performance metrics to identify trends and proactively address potential issues.
Implement design changes via change management and adhere to code promotion process while troubleshooting production issues.
Develop and maintain documentation for troubleshooting procedures, best practices, and system configurations.
Resolve data issues arising from load delays or server downtimes, focusing on customer satisfaction.
Collaborate with stakeholders to understand business requirements and recommend optimizations for data processing workflows.
Qualifications
Intermediate level SQL proficiency.
Experience managing Teradata SQL.
Solid skills in writing and translating SQL queries and data validation.
Performance tuning of SQL queries.
Experience with Autosys scheduling and troubleshooting.
Ability to troubleshoot Linux scripting and DataStage ETL.
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.
Salary Base Salary Range: $120,000 - $160,000 per annum
Seniority Level Entry level
Employment Type Full-time
Job Function Business Development and Sales
Referrals increase your chances of interviewing at Tata Consultancy Services by 2x.
Get notified about new ETL Developer jobs in
Seattle, WA .
#J-18808-Ljbffr