Data Stage ETL Developer

Join to apply for the Data Stage ETL Developer role at Tata Consultancy Services
.

• 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 Auto Sys, including Linux scripting, Data Stage ETL, and Teradata SQL.
• Use Part Loader in Data Stage.
• 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.

• 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 Data Stage ETL.
• BACHELOR OF COMPUTER SCIENCE.

• 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.

Base Salary Range: $120,000 - $160,000 per annum

Entry level

Full-time

Business Development and Sales

Referrals increase your chances of interviewing at Tata Consultancy Services by 2x.

Apply BELOW