DataStage ETL Developer: Data Warehouse Specialist

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

Benefits offered by this job

Discretionary annual incentive

Medical coverage

Parental leaves

401K plan

Training reimbursement

Vacation & holidays

Job summary

Tata Consultancy Services in Grand Rapids, MI, seeks an experienced ETL/Data Integration Specialist to design, develop, and maintain IBM InfoSphere DataStage ETL jobs for data warehouses and reporting platforms.

You will optimize ETL processes, perform data mapping, cleansing, validation, and coordinate with business analysts and application teams in an Agile environment. Strong SQL and Unix shell scripting are required.

Qualifications

• Experience designing ETL solutions using IBM InfoSphere DataStage.
• Experience with data warehouses and dimensional modeling.
• Proficiency in SQL (Oracle, SQL Server, DB2) and scripting.
• Ability to validate and reconcile data across loads in Agile environments.

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

ETL Development

Performance tuning

Data validation

Agile/Scrum

Data mapping

Team collaboration

Tools

IBM InfoSphere DataStage

Unix/Linux Shell scripting

SQL

Oracle

SQL Server

DB2

Data Warehousing

Data Modeling

Job description

Tata Consultancy Services in Grand Rapids, MI, seeks an experienced ETL/Data Integration Specialist to design, develop, and maintain IBM InfoSphere DataStage ETL jobs for data warehouses and reporting platforms.

You will optimize ETL processes, perform data mapping, cleansing, validation, and coordinate with business analysts and application teams in an Agile environment. Strong SQL and Unix shell scripting are required.