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 data sources, transform, and load it into target systems.
Ensure data quality, integrity, and consistency across different systems.
Optimize ETL processes for performance, scalability and reliability.
Manage Teradata SQL.
Troubleshoot and resolve data integration issues.
Write and translate SQL queries and perform SQL data validation.
Tune the performance of SQL queries.
Define, manage, and monitor job schedules; troubleshoot issues within the Autosys environment.
Implement job schedules, dependencies, and workflows within Autosys.
Analyze and resolve issues with Autosys jobs and processes.
Troubleshoot job failures in Autosys; failures can involve Linux scripting, DataStage ETL, Teradata SQL.
Part Loader which is ETL in DataStage.
Optimize database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.
Participate in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations.
Review job logs and performance metrics periodically to identify trends and proactively address potential issues.
Review production issues through meticulous job log reviews, implement necessary design changes via change management, and adhere to the code promotion process.
Maintain documentation for troubleshooting procedures, best practices, and system configurations, facilitating knowledge sharing within the team and managing change requests.
Resolve data issues arising from load delays or database server downtimes, focusing on ensuring customer satisfaction.
Collaborate with stakeholders to understand business requirements, provide insights and recommendations for optimizing data processing workflows.
Base Salary $120,000 - $160,000 per annum
TCS Employee Benefits Summary
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.
Qualifications BACHELOR OF COMPUTER SCIENCE
Seniority level Entry level
Employment type Full-time
Job function Business Development and Sales
Industries: IT Services and IT Consulting
#J-18808-Ljbffr
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 data sources, transform, and load it into target systems.
Ensure data quality, integrity, and consistency across different systems.
Optimize ETL processes for performance, scalability and reliability.
Manage Teradata SQL.
Troubleshoot and resolve data integration issues.
Write and translate SQL queries and perform SQL data validation.
Tune the performance of SQL queries.
Define, manage, and monitor job schedules; troubleshoot issues within the Autosys environment.
Implement job schedules, dependencies, and workflows within Autosys.
Analyze and resolve issues with Autosys jobs and processes.
Troubleshoot job failures in Autosys; failures can involve Linux scripting, DataStage ETL, Teradata SQL.
Part Loader which is ETL in DataStage.
Optimize database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.
Participate in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations.
Review job logs and performance metrics periodically to identify trends and proactively address potential issues.
Review production issues through meticulous job log reviews, implement necessary design changes via change management, and adhere to the code promotion process.
Maintain documentation for troubleshooting procedures, best practices, and system configurations, facilitating knowledge sharing within the team and managing change requests.
Resolve data issues arising from load delays or database server downtimes, focusing on ensuring customer satisfaction.
Collaborate with stakeholders to understand business requirements, provide insights and recommendations for optimizing data processing workflows.
Base Salary $120,000 - $160,000 per annum
TCS Employee Benefits Summary
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.
Qualifications BACHELOR OF COMPUTER SCIENCE
Seniority level Entry level
Employment type Full-time
Job function Business Development and Sales
Industries: IT Services and IT Consulting
#J-18808-Ljbffr