ETL Developer

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

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Time Off: Vacation, Sick Leave & Holidays

401K Plan

Performance Bonus

Job summary

Tata Consultancy Services is looking for a highly skilled ETL Developer in Seattle, WA. The ideal candidate will have extensive experience with IBM DataStage and cloud solutions, responsible for developing and optimizing ETL processes in an Agile environment.

The role involves designing scalable data integration solutions and ensuring best practices in performance and compliance. The salary range is $100,000 to $110,000 annually along with various employee benefits.

Qualifications

• Expertise in IBM DataStage and ETL development.
• Strong understanding of data warehousing and transformation.
• Familiarity with Agile methodologies.

Responsibilities

• Design and develop ETL solutions using IBM DataStage.
• Lead migration to cloud-native data platforms.
• Collaborate with cross-functional teams in Agile.

Skills

IBM DataStage (11.x and above)

IBM Cloud Pak for Data (CP4D)

ETL Design & Development

Data Warehousing Concepts

SQL (Advanced)

Data Migration & Modernization

Unix/Linux Shell Scripting

Job description

Job Description

Role Summary

We are seeking a highly skilled and results-driven ETL Developer with extensive hands‑on experience in IBM DataStage and IBM Cloud Pak for Data (CP4D). The ideal candidate will be responsible for designing, developing, optimizing, and supporting enterprise-scale ETL solutions, data integration pipelines, and modernization initiatives involving migration from legacy DataStage environments to cloud‑native data platforms.

The candidate should possess strong expertise in data warehousing, data transformation, performance optimization, and production support while collaborating with cross‑functional teams in an Agile delivery environment.

Key Responsibilities

• Design, develop, test, and deploy ETL/Data Integration solutions using IBM DataStage (latest versions).
• Develop scalable and high-performance data pipelines for batch and near real‑time processing.
• Lead migration and modernization initiatives from traditional DataStage environments to IBM Cloud Pak for Data (CP4D).
• Design and implement reusable ETL frameworks, shared containers, parameter sets, and automation components.
• Perform complex data mapping, transformation, cleansing, enrichment, and validation activities.
• Conduct performance tuning and optimization of ETL jobs, databases, and data flows.
• Analyze production issues, perform root‑cause analysis, and implement permanent fixes.
• Collaborate with Data Architects, Business Analysts, Product Owners, and QA teams during solution design and delivery.
• Participate in Agile ceremonies including Sprint Planning, Daily Standups, Reviews, and Retrospectives.
• Create and maintain technical design documents, source‑to‑target mappings, and operational runbooks.
• Ensure compliance with enterprise security, governance, and data quality standards.

Primary Skills

• IBM DataStage (11.x and above) – Expert Level
• IBM Cloud Pak for Data (CP4D)
• ETL Design & Development
• Data Warehousing Concepts
• SQL (Advanced)
• Data Modeling
• Data Migration & Modernization
• Performance Tuning and Optimization
• Unix/Linux Shell Scripting

Preferred Skills

• Experience migrating ETL workloads from IBM DataStage to Cloud Pak for Data.
• Exposure to cloud‑native architecture and enterprise modernization programs.
• Experience with Autosys, Control‑M, or enterprise scheduling tools.
• Understanding of data governance, metadata management, and data lineage.
• Knowledge of DevOps and automated deployment pipelines for ETL applications.
• Exposure to Banking and Financial Services domain is highly preferred.
• Experience working in large‑scale enterprise data platforms handling high‑volume data processing.

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.

Salary Range: $100,000-$110,000 a year