DataStage ETL Engineer – Data Warehousing & Optimization

Tata Consultancy Services Limited; Grand Rapids (MI); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage: Health

Dental & Vision insurance

Disability Planning & Insurance

Pet Insurance Plans

Commuter Benefits & Certification & Re

Training Reimbursement

Vacation, Time Off, Sick Leave &H

401K Plan, Performance Bonus, College/

Job summary

Tata Consultancy Services Limited in the United States is seeking an experienced ETL/DataStage developer to design, develop, and maintain ETL jobs. You will work on data integration for data warehouses and reporting platforms.

The role requires strong SQL, data modeling skills, and the ability to optimize ETL performance while collaborating with analysts, data architects, and application teams to ensure reliable data loads.

Qualifications

• Experience with ETL development using IBM InfoSphere DataStage.
• Strength in SQL and database concepts across Oracle, SQL Server, and DB2.
• Experience with data warehousing and data modeling.
• Ability to performance tune ETL jobs.
• Experience with data validation and reconciliation.
• Collaborates with analysts, data architects and application teams on data solutions.

Responsibilities

• Design, develop, and maintain ETL jobs using IBM InfoSphere DataStage.
• Develop data integration solutions for data warehouses and reporting platforms.
• Perform data mapping, transformation, cleansing, and validation.
• Optimize ETL jobs for performance, scalability, and reliability.
• Analyze and resolve production issues and support data loads.
• Collaborate with business analysts, data architects, and application teams.

Skills

SQL & DB concepts

Data warehousing & modeling

ETL optimization

Data validation & reconciliation

IBM InfoSphere DataStage

Data integration for warehouses

Data mapping & transformation

Tools

Oracle

SQL Server

DB2

IBM InfoSphere DataStage

Job description

Tata Consultancy Services Limited in the United States is seeking an experienced ETL/DataStage developer to design, develop, and maintain ETL jobs. You will work on data integration for data warehouses and reporting platforms.

The role requires strong SQL, data modeling skills, and the ability to optimize ETL performance while collaborating with analysts, data architects, and application teams to ensure reliable data loads.