Data Stage ETL Developer

Tata Consultancy Services; Seattle (WA); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Vacation and Time Off

401K Plan

Job summary

A leading IT services company is seeking a Data Stage ETL Developer in Seattle to design, develop, and support Teradata ETL jobs. The ideal candidate has solid skills in Teradata SQL and experience optimizing data pipelines. This role offers a competitive salary and comprehensive benefits including medical coverage, family support, and professional growth opportunities.

Qualifications

• Intermediate skill level in Teradata SQL.
• Experience in designing and developing Teradata ETL jobs.
• Ability to manage Teradata SQL, troubleshoot data integration issues.

Responsibilities

• Design, develop, and support Teradata ETL jobs.
• Extract, transform, and load data into target systems.
• Optimize ETL processes for performance and scalability.

Skills

Teradata SQL

ETL processes

Autosys

SQL query performance tuning

Data integration issues

Analytical skills

Job description

Data Stage ETL Developer

Join Tata Consultancy Services as a Data Stage ETL Developer and contribute to enterprise data warehouse solutions, leveraging Teradata, DataStage, and Autosys.

Responsibilities

• Design, develop, and support Teradata ETL jobs and data pipelines.
• Extract data from various sources, transform it, and load it into target systems.
• Ensure data quality, integrity, and consistency across different systems.
• Optimize ETL processes for performance, scalability, and reliability.
• Write and tune Teradata SQL queries, including data validation.
• Define, manage, and monitor job schedules; troubleshoot issues within the Autosys environment.
• Analyze and resolve issues with Autosys jobs and dependencies.
• Collaborate with DBAs to optimize database job performance and implement SQL design changes.
• Participate in troubleshooting production issues, reviewing job logs and making necessary design changes via change management.
• Document troubleshooting procedures, best practices, and system configurations; manage Change Requests.
• Collaborate with stakeholders to understand business requirements and recommend optimizations for data processing workflows.

Qualifications

• Intermediate skill level in Teradata SQL and SQL query performance tuning.
• Experience designing and developing Teradata ETL jobs and data pipelines.
• Solid skills in writing and translating SQL queries; perform SQL data validation.
• Ability to manage Teradata SQL, including troubleshooting and resolving data integration issues.
• Experience with Autosys: defining, managing, and monitoring job schedules; troubleshooting Autosys job failures; understanding job dependencies and workflows.
• Background in optimizing database jobs for performance, collaborating with DBAs to implement design changes.
• Strong analytical skills to review job logs, identify trends, and proactively address potential issues.
• Proficiency in troubleshooting production issues through meticulous job log reviews and design changes via change management.

Base Salary Range

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

Equal Opportunity Employer

We are an equal opportunity employer and encourage applicants from all backgrounds.