Teradata ETL Developer

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

Benefits offered by this job

Discretionary annual incentive

Comprehensive medical coverage

401(k) plan

Training reimbursement

Job summary

A leading IT services firm is seeking a Teradata ETL Developer in Seattle, WA. This full-time position requires 4-8 years of experience in Teradata programming and SQL development. Responsibilities include developing complex ETL processes, collaborating with stakeholders, and ensuring compliance with business requirements. The company offers competitive benefits including comprehensive medical coverage, wellness support, and professional growth opportunities. Ideal candidates will have a Bachelor’s degree in Computer Science and strong analytical skills.

Qualifications

• 4-8 years hands-on experience writing Teradata code.
• Extensive experience developing complex SQL code using Teradata.
• Knowledge of ETL and Data Warehouse concepts.

Responsibilities

• Develop Teradata code meeting 100% of technical specifications.
• Analyze, design, code, and test complex ETL processes.
• Collaborate with stakeholders to translate business requirements.

Skills

Teradata programming

SQL development

Unix Shell scripting

ETL process design

Data warehousing

Education

Bachelor of Computer Science

Tools

Teradata Utilities (BTEQ, Fast Load, Multi Load)

SQL Server

Autosys

Job description

Teradata ETL Developer – Tata Consultancy Services

Base Salary: $100,000 - $130,000 per annum

Must Have Technical/Functional Skills

• 4-8 years hands‑on experience writing Teradata code.
• Experience with Teradata Utilities (BTEQ, Fast Load, Multi Load).
• Extensive experience developing complex SQL code using Teradata stored procedures, macros, etc.
• Proficiency in Unix Shell scripting.
• Ability to create design documents, mapping documents, and design development standards.
• Knowledge of ETL and Data Warehouse concepts.
• Knowledge of SQL Server and Autosys.

Roles & Responsibilities

• Collaborate with stakeholders to understand current processes.
• Translate business requirements into technical requirements.
• Develop Teradata code meeting 100% of technical specifications and business requirements according to design patterns.
• Analyze, design, code, and test highly complex ETL processes for data warehouses and/or operational data stores.
• Design ETL applications including data sources, targets, definitions, relationships, and business rules.
• Work closely with technical leads, analysts, data modelers, and other developers to understand project requirements and contribute to solutions.
• Provide post go‑live and application maintenance support.
• Provide technical expertise on database design, data modeling, data warehousing, and data integration.
• Create solutions for large and complex data‑driven applications.
• Reconcile and test developed solutions.
• Design, develop, and support application solutions leveraging Teradata and related tools.
• Prepare test cases for unit testing, SIT, regression.
• Take ownership and deliver independently; report to stakeholders on achievements, risks, and future work.
• Follow Agile standards for requested proposal development.
• Bring best practices, standards, and innovative architecture ideas.
• Deploy data ingestion pipelines into dev, pre, and production environments.
• Conduct unit, integration, functional, and non‑functional testing.

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, 401(k) plan, performance bonus, college fund, student loan refinancing.

Qualifications

Bachelor of Computer Science

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Business Development and Sales

Industries

IT Services and IT Consulting