Datastage Developer

Tata Consultancy Services Limited; Grand Rapids (MI); In loco; USD 90.000 - 130.000; Tempo pieno

Vantaggi offerti da questo lavoro

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/

Descrizione del lavoro

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.

Competenze

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

Mansioni

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

Conoscenze

SQL & DB concepts

Data warehousing & modeling

ETL optimization

Data validation & reconciliation

IBM InfoSphere DataStage

Data integration for warehouses

Data mapping & transformation

Strumenti

Oracle

SQL Server

DB2

IBM InfoSphere DataStage

Descrizione del lavoro

• SQL and Database Concepts (Oracle, SQL Server, DB2)
• Data Warehousing and Data Modeling
• Performance Tuning and Job Optimization
• Data Validation and Reconciliation
• 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.

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: Aut& 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.